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 GcSpread.Sheets.Sheet 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. |