How to apply a number format to an entire row in Excel?

16 Dec 20253 minutes to read

The following examples illustrate how to apply a number format to an entire row in Excel in C# (cross-platform and Windows-specific) and VB.NET.

using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;
    IWorkbook workbook = application.Workbooks.Create(1);
    IWorksheet worksheet = workbook.Worksheets[0];

    worksheet["A1"].Number = 1000.500;
    worksheet["B1"].Number = 1234;
    worksheet["C1"].Number = 54321.500;
    worksheet["D1"].Number = .500;

    worksheet["A1"].EntireRow.NumberFormat = "#,##0.0000";

    workbook.SaveAs("../../../Output/NumberFormats.xlsx");
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;
    IWorkbook workbook = application.Workbooks.Create(1);
    IWorksheet worksheet = workbook.Worksheets[0];

    worksheet["A1"].Number = 1000.500;
    worksheet["B1"].Number = 1234;
    worksheet["C1"].Number = 54321.500;
    worksheet["D1"].Number = .500;

    worksheet["A1"].EntireRow.NumberFormat = "#,##0.0000";

    workbook.SaveAs("../../Output/NumberFormats.xlsx");
}
Using excelEngine As New ExcelEngine()
    Dim application As IApplication = excelEngine.Excel
    application.DefaultVersion = ExcelVersion.Xlsx

    Dim workbook As IWorkbook = application.Workbooks.Create(1)
    Dim worksheet As IWorksheet = workbook.Worksheets(0)

    worksheet("A1").Number = 1000.5
    worksheet("B1").Number = 1234
    worksheet("C1").Number = 54321.5
    worksheet("D1").Number = 0.5

    worksheet("A1").EntireRow.NumberFormat = "#,##0.0000"

    workbook.SaveAs("../../Output/NumberFormats.xlsx")
End Using

A complete working example to demonstrate how to apply a number format to an entire row in Excel using C# is present on this GitHub page.