var sheet = this.spread.getActiveSheet();
var printInfo = sheet.printInfo();
console.log(printInfo)
//打印设置纸张设置为A4
printInfo.paperSize(new GC.Spread.Sheets.Print.PaperSize(GC.Spread.Sheets.Print.PaperKind.a4));
// 纸张设置为其他尺寸
// printInfo.paperSize(new GC.Spread.Sheets.Print.PaperSize(950,1350));
// 设置页边距
printInfo.margin({ top: 10, bottom: 0, left: 0, right: 0, header: 0, footer: 0 });
//是否打印控件的外边框
printInfo.showBorder(false);
//是否打印网格线(默认打印)
printInfo.showGridLine(false);
// printInfo.headerCenter("&\ "Comic Sans MS"System Information ");
// printInfo.footerCenter("&P/&N/&F ");
printInfo.zoomFactor(0.99);//缩放
printInfo.qualityFactor(5);//打印的质量因子
printInfo.orientation(GC.Spread.Sheets.Print.PrintPageOrientation.landscape);//打印的页面方向。portrait纵 landscape
printInfo.centering(GC.Spread.Sheets.Print.PrintCentering.horizontal);//打印页面的居中方式。
printInfo.showColumnHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);//获取或设置是否打印列标题。
printInfo.showRowHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);
//设置是否以黑白打印
printInfo.blackAndWhite(false);
// 给每个表单循环设置printInfo
for (var i = 0; i < this.spread.getSheetCount(); i++) {
this.spread.sheets[i].printInfo(printInfo);
}
|
|