This table summarizes how the row and column settings are handled when Spread.Sheets imports data from an Excel file. These properties are members of the GC.Spread.Sheets.Worksheet class unless otherwise noted.

Excel Setting	Spread.Sheets Setting	Remarks
Hidden columns or rows	Sheet.setRowVisible or Sheet.setColumnVisible	Spread.Sheets imports this setting from Excel.
Row height	Sheet.setRowHeight	Spread.Sheets imports this setting from Excel.
Column width	Sheet.setColumnWidth	Spread.Sheets imports this setting from Excel.
Row Count or Column Count	Sheet.setRowCount or Sheet.setColumnCount	When importing, rowCount and columnCount are the last non-null row and column. If there is no data in the sheet, the row and column are the activeCell.row and column.
Starting column and row		Not supported at this time.