Spread Windows Forms 14.0
Spread Windows Forms 14.0 Product Documentation / Import and Export Reference / Excel-Formatted Files Import / Row and Column Settings Imported
In This Topic
    Row and Column Settings Imported
    In This Topic

    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.

    See Also