Skip to main content

XlPrintTitles.SetColumns(Int32, Int32) Method

Sets columns to be repeated on the left side of every printed page.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

#Declaration

public void SetColumns(
    int startIndex,
    int endIndex
)

#Parameters

Name Type Description
startIndex Int32

A zero-based integer representing the index of the first column to be printed on each page.

endIndex Int32

A zero-based integer representing the index of the last column to be printed on each page.

#Remarks

To repeat specific rows at the top of every printed page, use the XlPrintTitles.SetRows method. For an example, refer to the How to: Print Titles on a Worksheet document.

#Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

// Print the first column and the first row on every page.
sheet.PrintTitles.SetColumns(0, 0);
sheet.PrintTitles.SetRows(0, 0);
See Also