SpreadJS 14
Import and Export Reference / Excel-Formatted Files Import / Worksheet Settings Imported
In This Topic
    Worksheet Settings Imported
    In This Topic

    This table summarizes how the sheet settings are handled when SpreadJS imports data from an Excel-formatted file. These settings are members of the GC.Spread.Sheets.Worksheet class unless otherwise noted.

    Excel Setting SpreadJS Setting Remarks
    Worksheets Worksheet names SpreadJS Spread.name SpreadJS imports this setting from Excel.
    Default Width Sheet.defaults.colWidth SpreadJS imports this setting from Excel.
    Frozen panes Sheet.frozenRowCount or Sheet.frozenColumnCount SpreadJS imports this setting from Excel.
    Data   SpreadJS loads the data from Excel.
    Sparkline Sheet.setSparkline SpreadJS imports this setting from Excel.
    Spans Sheet.addSpan SpreadJS loads all span information from Excel.
    ActiveCell Sheet.setActiveCell SpreadJS sets the active cell when importing from Excel.
    Selections Sheet.setSelection SpreadJS sets the selection when importing from Excel.
    GridLine Sheet.options.gridline SpreadJS imports this setting from Excel.
    Zoom Sheet.zoom SpreadJS keeps the zoom factor when importing from Excel.
    Theme Sheet.currentTheme SpreadJS imports this setting from Excel.
    Conditional Formats Sheet.ConditionalFormats SpreadJS loads all conditional formats when importing from Excel.
    TabColor Sheet.options.sheetTabColor SpreadJS imports this setting from Excel.
    Sheet Protected Sheet.options.isProtected  SpreadJS imports this setting from Excel.
    Tables Sheet.tables.add SpreadJS loads all tables when importing from Excel.
    Range Group Sheet.rowOutlines or Sheet.columnOutlines SpreadJS loads all group information when importing from Excel.
    Cell Overflow Sheet.options.allowCellOverflow SpreadJS sets allowCellOverflow to true (cells can always overflow in Excel).
    Filter Sheet.rowFilter SpreadJS loads all filter information when importing from Excel.
    Sheet Custom Names Sheet.addCustomName SpreadJS loads all custom names when importing from Excel.
    Sheet Row or Column Header Sheet.options.rowHeaderVisible or Sheet.options.colHeaderVisible SpreadJS imports this setting from Excel.