Print a Worksheet
Set Print Area
Code Sample
//Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook();
//Get the page setup of the worksheet
XlsPageSetup pageSetup = workbook.Worksheets[0].PageSetup;
//Set the area of the worksheet to print
pageSetup.PrintArea = "A1:D20";
'Create a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook ()
'Get the page setup of the worksheet
Dim pageSetup As XlsPageSetup = workbook.Worksheets(0).PageSetup
'Set the area of the worksheet to print
pageSetup.PrintArea = "A1:D20"
Set Print Tile
Code Sample
//Create a Workbook object
XlsWorkbook workbook = new XlsWorkbook();
//Get the page setup of the worksheet
XlsPageSetup pageSetup = workbook.Worksheets[0].PageSetup;
//Set print title columns
pageSetup.PrintTitleColumns = "$A:$B";
//Set print title rows
pageSetup.PrintTitleRows = "$1:$2";
'Create a Workbook object
Dim workbook As XlsWorkbook = New XlsWorkbook ()
'Get the page setup of the worksheet
Dim pageSetup As XlsPageSetup = workbook.Worksheets(0).PageSetup
'Set print title columns
pageSetup.PrintTitleColumns = "$A:$B"
'Set print title rows
pageSetup.PrintTitleRows = "$1:$2"