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. |