SpreadJS 13
SpreadJS Documentation / Import and Export Reference / Excel-Formatted Files Export / Sheet Settings Exported
In This Topic
    Sheet Settings Exported
    In This Topic

    This table summarizes how the Sheet settings are handled when SpreadJS exports to an Excel-formatted file. These functions are in the GC.Spread.Sheets.Worksheet class unless otherwise noted.

    Sheet Setting Excel Setting and Remarks
    name Excel uses this setting.
    defaults : rowHeight, columnWidth,
    columnHeaderRowHeight, rowHeaderColumnWidth
    Excel only use the default.colWidth setting, but loads other settings to the column or row header.
    columns Excel uses this setting.
    rows Excel uses this setting.
    autoGenerateColumns Excel ignores the Sheet setting. This is specific to SpreadJS.
    dataSource Excel ignores the Sheet setting. This is specific to SpreadJS.
    frozenRowCount or frozenColumnCount Excel uses this setting.
    frozenTrailingRowCount or frozenTrailingColumnCount Excel ignores the Sheet setting. This is specific to SpreadJS.
    rowCount Excel ignores the Sheet setting. This is specific to SpreadJS.
    columnCount Excel ignores the Sheet setting. This is specific to SpreadJS.
    data Excel loads the data from SpreadJS.
    sparkline Excel uses this setting.
    spans Excel uses this setting.
    selections Excel uses this setting.
    selectionBackColor Excel ignores the Sheet setting. This is specific to SpreadJS.
    selectionBorderColor Excel ignores the Sheet setting. This is specific to SpreadJS.
    activeRowIndex Excel uses this setting.
    activeColumnIndex Excel uses this setting.
    gridline Excel uses this setting, but if the vertical or horizontal grid line is hidden, then both are exported as hidden in Excel.
    allowCellOverflow Excel ignores the Sheet setting. allowCellOverflow is always true in Excel.
    zoomFactor Excel uses this setting.
    theme Excel uses the first sheet theme as the current theme and ignores other sheet theme settings.
    showRowOutline or showColumnOutline Excel ignores the Sheet setting. Excel uses the range group that is shown.
    rowOutlines or columnOutlines Excel uses this setting.
    rowFilter Excel uses this setting.
    conditional formats Excel uses this setting.
    sheetTabColor Excel uses this setting.
    frozenlineColor Excel ignores the Sheet setting. This is specific to SpreadJS.
    rowHeaderAutoText(Index) or colHeaderAutoText(Index) Excel ignores the Sheet setting. This is specific to SpreadJS.
    rowHeaderVisible or colHeaderVisible Excel uses this setting.
    row header column count Excel ignores the Sheet setting. This is specific to SpreadJS.
    column header row count Excel ignores the Sheet setting. This is specific to SpreadJS.
    clipboardOptions Excel ignores the Sheet setting. This is specific to SpreadJS.
    isProtected Excel uses this setting.
    borderColor Excel ignores the Sheet setting. This is specific to SpreadJS.
    borderWidth Excel ignores the Sheet setting. This is specific to SpreadJS.
    table Excel uses this setting.
    named styles Excel uses this setting.