SpreadJS Documentation
Print Settings Imported

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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.