Spread for ASP.NET 12 Product Documentation
Row and Column Settings Imported
Spread for ASP.NET 12 Product Documentation > Import and Export Reference > Excel-Formatted File Import > Row and Column Settings Imported

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.