SpreadJS Documentation
Row and Column Settings Imported

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

Excel Setting SpreadJS Setting Remarks
Hidden columns or rows Sheet.setRowVisible or Sheet.setColumnVisible SpreadJS imports this setting from Excel.
Row height Sheet.setRowHeight SpreadJS imports this setting from Excel.
Column width Sheet.setColumnWidth SpreadJS 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.