Setting Print Options

Aspose.Cells supports all of these print options and developers can easily configure these options for their desired worksheets using the several properties offered by PageSetup class. The usage of these properties of PageSetup class is discussed below in more detail.

By default, only that print area is selected that incorporates the entire area of the worksheet, which contains data but developers can also establish a specific print area of the worksheet according to their desire.

To select a specific print area, developers can use PrintArea property of the PageSetup class. You can assign the cells range of the print area to this property.

Example:

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Obtaining the reference of the PageSetup of the worksheet
PageSetup pageSetup = workbook.Worksheets[0].PageSetup;

//Specifying the cells range (from A1 cell to T35 cell) of the print area
pageSetup.PrintArea = "A1:T35";
 

'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()

'Obtaining the reference of the PageSetup of the worksheet
Dim pageSetup As PageSetup = workbook.Worksheets(0).PageSetup

'Specifying the cells range (from A1 cell to T35 cell) of the print area
pageSetup.PrintArea = "A1:T35"
 

Aspose.Cells allows you to designate row and column headers that you want to have repeated on all pages of your printed worksheet. To do so, developers can use PrintTitleColumns and PrintTitleRows properties of the PageSetup class.

The rows or columns (to be repeated on all pages of the printed worksheet) are defined by passing their row or column numbers. For example, rows are defined as $1:$2 and columns are defined as $A:$B.

Example:

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Obtaining the reference of the PageSetup of the worksheet
Aspose.Cells.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";
 

'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()

'Obtaining the reference of the PageSetup of the worksheet
Dim pageSetup As 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"
 

PageSetup class also provides several other properties to set general print options as follows:

• PrintGridlines , a boolean property that defines whether to print or not print gridlines
• PrintHeadings , a boolean property that defines whether to print row and column headings or not
• BlackAndWhite , a boolean property that defines whether to print worksheet in black and white mode or not
• PrintComments , defines that whether to display the print comments on the worksheet or at the end of the worksheet
• Draft , a boolean property that defines whether to print worksheet in draft quality or not
• PrintErrors , defines that whether to print cell errors as displayed, blank, dash or N/A

To set PrintComments and PrintErrors properties, Aspose.Cells also provides two enumerations, PrintCommentsType & PrintErrorsType that contain pre-defined values to be assigned to PrintComments and PrintErrors properties respectively.

The pre-defined values of PrintCommentsType enumeration are listed below with their descriptions:

PageSetup class provides Order property that is used to order multiple pages of your worksheet to be printed. There are two possibilities to order the pages as follows:

• Down then over thus it will print all pages down before printing pages to the right
• Over then down thus it will print pages left to right before printing pages below

Aspose.Cells provides an enumeration, PrintOrderType that contains all pre-defined order types to be assigned to Order property.

The pre-defined values of PrintOrderType enumeration are listed below with their descriptions: