The following table summarizes how the row and column settings are handled when Spread imports data from an Excel-formatted file.
| Setting |
How the Setting is Imported |
| Default row height |
Spread reads the default row height from the Excel file, then sets the default row height for all rows in the sheet. |
| Default column width |
Spread reads the default column width from the Excel file, then sets the default row height for all rows in the sheet. |
| Row height |
Spread reads the row heights from the Excel file, then sets the RowHeight property for the individual rows using those values. |
| Column width |
Spread reads the column widths from the Excel file, then sets the ColumnWidth property for the individual columns using those values. |
| Hidden columns |
Columns hidden in the Excel file are hidden in Spread. |
| Hidden rows |
Rows hidden in the Excel file are hidden in Spread. |