IXlRow.BlankCells(Int32, XlCellFormatting) Method

Creates the specified number of empty cells to which specific formatting options are applied.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

void BlankCells(
    int count,
    XlCellFormatting formatting
)

VB.NET

Sub BlankCells(
    count As Integer,
    formatting As XlCellFormatting
)

Parameters

Name	Type	Description
count	Int32	A positive integer that specifies the number of blank cells to be created.
formatting	XlCellFormatting	An XlCellFormatting object that specifies formatting settings to be applied to the created cells. If formatting is null, a System.ArgumentNullException exception occurs.

Example

The example below demonstrates how to use the IXlRow.BlankCells method to quickly generate multiple empty cells in a row that share the same formatting settings. Note that you can also use the IXlRow.BulkCells method to create row cells with the specified values and format characteristics.

For more information on how to create and format cells in a worksheet, see the Cells and Formatting example sections.

C#

// Create a worksheet. 
using (IXlSheet sheet = document.CreateSheet())
{
    // Create the first row in the worksheet.                      
    using (IXlRow row = sheet.CreateRow())
    {
        // Create five successive cells in the row and set their background color to light blue.
        row.BlankCells(5, XlFill.SolidFill(Color.LightBlue));
    }
}

VB.NET

' Create a worksheet. 
Using sheet As IXlSheet = document.CreateSheet()
    ' Create the first row in the worksheet.                      
    Using row As IXlRow = sheet.CreateRow()
        ' Create five successive cells in the row and set their background color to light blue.
        row.BlankCells(5, XlFill.SolidFill(Color.LightBlue))
    End Using
End Using

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the BlankCells(Int32, XlCellFormatting) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-library-generate-an-invoice/CS/XLExportExample/Form1.cs#L427

// Create one blank cell with the specified formatting settings.
row.BlankCells(1, headerRowFormatting);

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L216

    // Create five empty cells with the title formatting.
    row.BlankCells(5, formatting);
}

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/CS/XLExportExample/Form1.cs#L210

    // Create four empty cells with the title formatting.
    row.BlankCells(4, formatting);
}

VB.NET

excel-export-library-generate-an-invoice/VB/XLExportExample/Form1.vb#L440

' Create one blank cell with the specified formatting settings.
row.BlankCells(1, headerRowFormatting)

excel-export-library-generate-sales-report/VB/XLExportExampleSalesReport/Form1.vb#L228

    ' Create five empty cells with the title formatting.
    row.BlankCells(5, formatting)
End Using

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/VB/XLExportExample/Form1.vb#L196

    ' Create four empty cells with the title formatting.
    row.BlankCells(4, formatting)
End Using