IXlSheet.SkipRows(Int32) Method

Specifies the number of successive rows to be skipped in the worksheet before starting to generate a new row.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

void SkipRows(
    int count
)

VB.NET

Sub SkipRows(
    count As Integer
)

Parameters

Name	Type	Description
count	Int32	A positive integer value that specifies the number of rows to be skipped.

Remarks

Note that you can also use the IXlSheet.CreateRow method overload with the rowIndex parameter to specify where the created row should be located in a worksheet. For more information on how to generate and modify worksheet rows, refer to the Rows and Columns section of examples.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SkipRows(Int32) 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-api-examples/CS/XLExportExamples/SpreadsheetActions/PictureActions.cs#L67

}
sheet.SkipRows(1);
// Create the second row and set its height.

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

// Skip one row before starting to generate the total row.
sheet.SkipRows(1);

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

// Skip one row before starting to generate data rows.
sheet.SkipRows(1);

excel-export-library-generate-sales-analysis-report/CS/XLExportExample/Form1.cs#L227

// Skip one row before starting to generate data rows.
sheet.SkipRows(1);

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

    // Skip one row before starting to generate data rows.
    sheet.SkipRows(1);
}

VB.NET

excel-export-api-examples/VB/XLExportExamples/SpreadsheetActions/PictureActions.vb#L59

End Using
sheet.SkipRows(1)
' Create the second row and set its height.

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

' Skip one row before starting to generate the total row.
sheet.SkipRows(1)

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

' Skip one row before starting to generate data rows.
sheet.SkipRows(1)

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

    ' Skip one row before starting to generate data rows.
    sheet.SkipRows(1)
End Sub

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

    ' Skip one row before starting to generate data rows.
    sheet.SkipRows(1)
End Sub