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. |
Return to Excel-Formatted File Import overview.