SpreadJS 13
SpreadJS Documentation / Import and Export Reference / Excel-Formatted Files Import / Row and Column Settings Imported
In This Topic
    Row and Column Settings Imported
    In This Topic

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

    Excel Setting SpreadJS Setting Remarks
    Hidden columns or rows Sheet.setRowVisible or Sheet.setColumnVisible SpreadJS imports this setting from Excel.
    Row height Sheet.setRowHeight SpreadJS imports this setting from Excel.
    Column width Sheet.setColumnWidth SpreadJS imports this setting from Excel.
    Row Count or Column Count Sheet.setRowCount or Sheet.setColumnCount When importing, rowCount and columnCount are the last non-null row and column. If there is no data in the sheet, the row and column are the activeCell.row and column.
    Starting column and row   Not supported at this time.