Spread Windows Forms 11.0 Product Documentation
Row and Column Settings Imported
Spread Windows Forms 11.0 Product Documentation > Import and Export Reference > Excel-Formatted Files Import > Row and Column Settings Imported

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

Excel Setting Related Spread Property Remarks

Active cell

ActiveCell

Sets active cell in Spread as it was when file was saved in Excel.

 

ActiveColumn

ActiveColumnIndex

ActiveRow

ActiveRowIndex

Sets active cell in Spread as it was when file was saved in Excel.

Cell blocks

 

These are ranges of cells. See Selections, in this section on Row and Column Settings Imported.

Column headers and Row headers

ColumnHeader

ColumnHeaderHorizontalGridLine

ColumnHeaderVerticalGridLine

ColumnHeaderVisible

RowHeader

RowHeaderHorizontalGridLine

RowHeaderVerticalGridLine

RowHeaderVisible

Excel shows or hides both column and row headers; therefore, if both are displayed in Excel, both are displayed in Spread.

Also, refer to the ColumnHeader class and RowHeader class.

Hidden columnsHidden rows

Visible

Columns and rows hidden in Excel are hidden in Spread.

These are columns or rows that are not displayed.

Row height

Row.Height

Spread imports the Excel setting.

Column width

Column.Width

Spread imports the Excel setting.

Frozen columns

Frozen rows

FrozenColumnCount

FrozenRowCount

Spread imports these settings from Excel.

These are rows or columns that are non-scrollable.

Grid lines

HorizontalGridLine

VerticalGridLine

ColumnHeaderHorizontalGridLine

ColumnHeaderVerticalGridLine

RowHeaderHorizontalGridLine

RowHeaderVerticalGridLine

Excel shows or hides both horizontal and vertical grid lines; therefore, if both are displayed in Excel, both are displayed in Spread.

Print information

PrintInfo

Refer to Print Settings Imported. And refer to the PrintInfo class.

Protected cells

Protect

Spread imports the Excel setting. Note that the default value for the Protect property in Excel is False—the opposite of the Spread Protect property default setting.

See locked cells in the table of Cell Settings Imported.

Row headers and Column headers

 

See Column Headers and Row Headers in this table of Column and Row Settings Imported.

Selections

IsBlockSelected

SelectionBackColor

SelectionForeColor

SelectionCount

Spread imports these settings from Excel.

Sheet name

SheetName

Spread imports these settings from Excel.

Starting column and row

StartingColumnNumber

StartingRowNumber

Spread imports these settings from Excel.

Zoom factor

ZoomFactor

Spread imports these settings from Excel.