Set Print Titles
Contents
[
Hide
]
Aspose.Cells - Set Print Titles
Aspose.Cells allows you to designate row and column headers to repeat on all pages of a printed worksheet. To do so, use the PageSetup class PrintTitleColumns and PrintTitleRows properties.
The rows or columns that will be repeated are defined by passing their row or column numbers. For example, rows are defined as $1:$2 and columns are defined as $A:$B.
C#
//Instantiating a Workbook object
Workbook workbook = new Workbook("../../data/test.xlsx");
//Obtaining the reference of the PageSetup of the worksheet
PageSetup pageSetup = workbook.Worksheets[0].PageSetup;
//Defining column numbers A & B as title columns
pageSetup.PrintTitleColumns = "$A:$B";
//Defining row numbers 1 & 2 as title rows
pageSetup.PrintTitleRows= "$1:$2";
Download Running Code
Download Set Print Titles form any of the below mentioned social coding sites:
For more details, visit Setting Print Options.