The following table summarizes how the row and column settings are handled when Spread exports to an Excel-formatted file. In most cases Excel uses the Spread setting.

Spread Property	How the Setting is Exported
ColumnHeaderVisible	This setting is exported only if RowHeaderVisible has the same setting.
Columns.Visible	The column is displayed or hidden in Excel according to this setting.
Columns.Width	The column width for each individual column in Excel is set according to this setting.
FrozenColumnCount	This setting is exported.
FrozenRowCount	This setting is exported.
RowHeaderVisible	This setting is exported only if ColumnHeaderVisible has the same setting.
Rows.Height	The height for each individual row in Excel is set according to this setting.
Rows.Visible	The row is displayed or hidden in Excel according to this setting.

Row or Column Quantity

Since Spread supports up to two billion rows and two billion columns on any sheet, and Excel supports less than this, only the number of rows and columns that Excel can handle is exported.