IXlSheet.CreateRow() Method

Creates a new row in the worksheet and returns the IXlRow object.

Namespace: DevExpress.Export.Xl

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

Declaration

IXlRow CreateRow()

Returns

Type Description
IXlRow

An IXlRow object that is the newly created row.

Example

// Create a worksheet.
using (IXlSheet sheet = document.CreateSheet()) {

    // Create the first row and set its height to 40 pixels.
    using (IXlRow row = sheet.CreateRow()) {
        row.HeightInPixels = 40;
    }

    // Hide the third row in the worksheet.
    using (IXlRow row = sheet.CreateRow(2)) {
        row.IsHidden = true;
    }
}
See Also