SpreadJS Documentation
Print Settings Exported

This table summarizes how the PrintInfo settings are handled when SpreadJS exports data to an Excel-formatted file.

SpreadJS Setting Excel Setting Remarks
blackAndWhite BlackAndWhite Excel uses this setting.
centering CenterHorizontally or CenterVertically Excel uses this setting.
columnEnd PrintArea Excel uses this setting.
columnStart PrintArea Excel uses this setting.
firstPageNumber FirstPageNumber Excel uses this setting.
fitPagesTall FitToPagesTall Excel uses this setting.
fitPagesWide FitToPagesWide Excel uses this setting.
footerCenter CenterFooter Excel uses this setting.
footerCenterImage CenterFooterPicture SpreadJS only supports this with OpenXml Excel.
footerLeft LeftFooter Excel uses this setting.
footerLeftImage LeftFooterPicture SpreadJS only supports this with OpenXml Excel.
footerRight RightFooter Excel uses this setting.
footerRightImage RightFooterPicture SpreadJS only supports this with OpenXml Excel.
headerCenter CenterHeader Excel uses this setting.
headerCenterImage CenterHeaderPicture SpreadJS only supports this with OpenXml Excel.
headerLeft LeftHeader Excel uses this setting.
headerLeftImage LeftHeaderPicture SpreadJS only supports this with OpenXml Excel.
headerRight RightHeader Excel uses this setting.
headerRightImage RightHeaderPicture SpreadJS only supports this with OpenXml Excel.
margin LeftMargin or RightMargin or TopMargin or BottomMargin or FooterMargin or HeaderMargin Excel uses this setting.
orientation Orientation Excel uses this setting.
pageOrder Order Excel uses this setting.
paperSize PaperSize Excel uses this setting.
repeatColumnEnd PrintTitleColumns Excel uses this setting.
repeatColumnStart PrintTitleColumns Excel uses this setting.
repeatRowEnd PrintTitleRows Excel uses this setting.
repeatRowStart PrintTitleRows Excel uses this setting.
rowEnd PrintArea Excel uses this setting.
rowStart PrintArea Excel uses this setting.
showColumnHeader PrintHeadings Excel uses this setting.
showGridLine PrintGridlines Excel uses this setting.
showRowHeader PrintHeadings Excel uses this setting.
zoomFactor Zoom Excel uses this setting.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.