SmartXLS Software

• Setting Print Page.
• Setting Print Margins.
• Setting Print Header/Footer.
• Setting Print Sheet.
• Setting Page Break.

Setting Print Page

set print options for pages

//set landscape orientation
workBook.PrintLandscape = true;
//fit page
workBook.PrintScaleFitToPage = true;
//fitToWidth
workBook.PrintScaleFitHPages = 1;
//FitHeight
workBook.PrintScaleFitVPages = 2;
//set paper size
workBook.setPrintPaperSize(11906, 16838);//A4
//auto number
workBook.PrintAutoPageNumbering = true;

Setting Print Margins

set print options for margins

workBook.PrintLeftMargin = 0.7;
workBook.PrintTopMargin = 0.75;
workBook.PrintRightMargin = 0.7;
workBook.PrintBottomMargin = 0.75;
workBook.PrintHeaderMargin = 0.3;
workBook.PrintFooterMargin = 0.3;
workBook.PrintHCenter = true;
workBook.PrintVCenter = false;

Setting Print Header/Footer

set print options for headers/footers
MS Link(Formatting and VBA Codes for Headers and Footers)

workBook.PrintHeader = "&L&G";
workBook.PrintFooter = "&CPage &P of &N";

Setting Print Sheet.

set print options for sheet

workBook.PrintArea = "Sheet1!$A$1:$AG$787";
workBook.PrintTitles = "Sheet2!$M:$M,Sheet2!$11:$11";
workBook.PrintGridLines = false;
workBook.PrintNoColor = true;
workBook.PrintRowColHeading = true;

Setting Page Break.

set page/row/column break for printing

//add page break at B2
workBook.addRowPageBreak(2);
workBook.addColPageBreak(2);