IXlRow.BulkCells(IEnumerable, XlCellFormatting) Method

Creates cells with the specified values and format characteristics.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

void BulkCells(
    IEnumerable values,
    XlCellFormatting formatting
)

VB.NET

Sub BulkCells(
    values As IEnumerable,
    formatting As XlCellFormatting
)

Parameters

Name	Type	Description
values	IEnumerable	An object exposing the System.Collections.IEnumerable interface that provides values for cells to be created. If the values parameter is null, a System.ArgumentNullException exception occurs.
formatting	XlCellFormatting	An XlCellFormatting object that specifies formatting settings be applied to the created cells. If null, no special formatting is applied.

Example

The example below demonstrates how to use the IXlRow.BulkCells method to quickly generate multiple non-empty cells in a row that share the same formatting settings. This method can be useful if you wish, for example, to create the header row for your table. To generate a bunch of empty cells and apply the same format to them in a single step, use the IXlRow.BlankCells method.

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

C#

string[] columnLabels = new string[] { "State", "Sales", "Profit", "Market Share" };

// Create a worksheet. 
using (IXlSheet sheet = document.CreateSheet())
{
    // Specify formatting settings for the header row.
    XlCellFormatting headerRowFormatting = new XlCellFormatting();
    headerRowFormatting.Font = new XlFont();
    headerRowFormatting.Font.Name = "Century Gothic";
    headerRowFormatting.Font.SchemeStyle = XlFontSchemeStyles.None;
    headerRowFormatting.Font.Color = XlColor.FromTheme(XlThemeColor.Light1, 0.0);
    headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent1, 0.0));

    // Create the header row.
    using (IXlRow row = sheet.CreateRow())
        {
        // Set the row height.
        row.HeightInPixels = 25;
        // Create the required cells in the header row:  
        // assign values of the "columnLabels" array to these cells and apply specific formatting settings to them.
        row.BulkCells(columnLabels, headerRowFormatting);
        }
}

VB.NET

Dim columnLabels() As String = { "State", "Sales", "Profit", "Market Share" }

' Create a worksheet. 
Using sheet As IXlSheet = document.CreateSheet()
    ' Specify formatting settings for the header row.
    Dim headerRowFormatting As New XlCellFormatting()
    headerRowFormatting.Font = New XlFont()
    headerRowFormatting.Font.Name = "Century Gothic"
    headerRowFormatting.Font.SchemeStyle = XlFontSchemeStyles.None
    headerRowFormatting.Font.Color = XlColor.FromTheme(XlThemeColor.Light1, 0.0)
    headerRowFormatting.Fill = XlFill.SolidFill(XlColor.FromTheme(XlThemeColor.Accent1, 0.0))

    ' Create the header row.
    Using row As IXlRow = sheet.CreateRow()
        ' Set the row height.
        row.HeightInPixels = 25
        ' Create the required cells in the header row:  
        ' assign values of the "columnLabels" array to these cells and apply specific formatting settings to them.
        row.BulkCells(columnLabels, headerRowFormatting)
    End Using
End Using

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the BulkCells(IEnumerable, 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-sales-analysis-report/CS/XLExportExample/Form1.cs#L237

    // Create required cells in the header row, assign values from the columnNames array to them and apply specific formatting settings.
    row.BulkCells(columnNames, headerRowFormatting);
}

VB.NET

excel-export-library-generate-sales-analysis-report/VB/XLExportExample/Form1.vb#L222

    ' Create required cells in the header row, assign values from the columnNames array to them and apply specific formatting settings.
    row.BulkCells(columnNames, headerRowFormatting)
End Using