Spread.Sheets Documentation
Row and Column Settings Imported

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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.