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