[]
        
(Showing Draft Content)

Row and Column Settings Imported

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.