This table summarizes how the row and column settings are handled when Spread.Sheets imports data from an Excel file. These properties are members of the GC.Spread.Sheets.Worksheet class unless otherwise noted.
| Excel Setting |
Spread.Sheets Setting |
Remarks |
| Hidden columns or rows |
Sheet.setRowVisible or Sheet.setColumnVisible |
Spread.Sheets imports this setting from Excel. |
| Row height |
Sheet.setRowHeight |
Spread.Sheets imports this setting from Excel. |
| Column width |
Sheet.setColumnWidth |
Spread.Sheets 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. |