[]
        
(Showing Draft Content)

Print Settings Exported

This table summarizes how the PrintInfo settings are handled when SpreadJS exports data to an Excel-formatted file.

SpreadJS 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

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.

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.