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