XlPrintTitles Class

Represents the object that specifies rows and columns to be repeated on every printed page.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public class XlPrintTitles

VB.NET

Public Class XlPrintTitles

Related API Members

The following members return XlPrintTitles objects:

• IXlSheet.PrintTitles

Remarks

To get an instance of the XlPrintTitles class, use the IXlSheet.PrintTitles property. To print specific rows at the top of every page, utilize the XlPrintTitles.SetRows method. To print specific columns on the left of every page, use the XlPrintTitles.SetColumns method. For more details, refer to the How to: Print Titles on a Worksheet example.

Example

Note

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

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)

Inheritance

Object

XlPrintTitles