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. |