[]
This table summarizes how the PrintInfo settings are handled when SpreadJS exports data to an Excel-formatted file.
SpreadJS Setting | Excel Setting | Remarks |
---|---|---|
BlackAndWhite | Excel uses this setting. | |
CenterHorizontally or CenterVertically | Excel uses this setting. | |
PrintArea | Excel uses this setting. | |
PrintArea | Excel uses this setting. | |
FirstPageNumber | Excel uses this setting. | |
FitToPagesTall | Excel uses this setting. | |
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. |
LeftMargin or RightMargin or TopMargin or BottomMargin or FooterMargin or HeaderMargin | Excel uses this setting. | |
Orientation | Excel uses this setting. | |
Order | Excel uses this setting. | |
PaperSize | Excel uses this setting. | |
PrintTitleColumns | Excel uses this setting. | |
PrintTitleColumns | Excel uses this setting. | |
PrintTitleRows | Excel uses this setting. | |
PrintTitleRows | Excel uses this setting. | |
PrintArea | Excel uses this setting. | |
PrintArea | Excel uses this setting. | |
PrintHeadings | Excel uses this setting. | |
PrintGridlines | Excel uses this setting. | |
PrintHeadings | Excel uses this setting. | |
Zoom | Excel uses this setting. |