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.v20.2.Core.dll

NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core

Declaration

C#

public void SetColumns(
    int startIndex,
    int endIndex
)

VB.NET

Public Sub SetColumns(
    startIndex As Integer,
    endIndex As Integer
)

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-t253492

PageViewAndLayoutActions.cs

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

PageViewAndLayoutActions.vb

' Print the first column and the first row on every page.
sheet.PrintTitles.SetColumns(0, 0)
sheet.PrintTitles.SetRows(0, 0)