This table summarizes how the PrintInfo settings are handled when Spread.Sheets exports data to an Excel-formatted file.
Spread.Sheets 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 | Spread.Sheets only supports this with OpenXml Excel. |
footerLeft | LeftFooter | Excel uses this setting. |
footerLeftImage | LeftFooterPicture | Spread.Sheets only supports this with OpenXml Excel. |
footerRight | RightFooter | Excel uses this setting. |
footerRightImage | RightFooterPicture | Spread.Sheets only supports this with OpenXml Excel. |
headerCenter | CenterHeader | Excel uses this setting. |
headerCenterImage | CenterHeaderPicture | Spread.Sheets only supports this with OpenXml Excel. |
headerLeft | LeftHeader | Excel uses this setting. |
headerLeftImage | LeftHeaderPicture | Spread.Sheets only supports this with OpenXml Excel. |
headerRight | RightHeader | Excel uses this setting. |
headerRightImage | RightHeaderPicture | Spread.Sheets 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. |