[]
DEMOS DOCS API SAMPLES DOWNLOAD
(Showing Draft Content)

C1.WPF.Grid.LoadExcelOptions

LoadExcelOptions Class

Represents options for loading data from an Excel file.

Inheritance
object
LoadExcelOptions
Namespace: C1.WPF.Grid
Assembly: C1.WPF.Grid.Excel.dll
Syntax
public class LoadExcelOptions
Remarks

These options allow for customization of the import process, such as including only visible rows and columns.

Constructors

Name Description
LoadExcelOptions()

Properties

Name Description
ColumnMaxWidth

Gets or sets the maximum allowable width for the columns.
ColumnMinWidth

Gets or sets the minimum allowable width for the columns.
FreezeRowsAndColumns

Specifies whether to freeze rows and columns in the grid after importing. The default value is true.
OnLoadedCallback

Gets or sets a callback that is invoked after the Excel data has been parsed.
OverriddenColumnDefaultWidth

Gets or sets the width that overrides the default Excel column width.
OverriddenRowDefaultHeight

Gets or sets the height that overrides the default Excel row height.
RowMaxHeight

Gets or sets the maximum allowable height for the rows.
RowMinHeight

Gets or sets the minimum allowable height for the rows.
SheetCellRange

Represents the range of cells to be processed and loaded into the grid.
SheetColumnHeaderRowIndex

Specifies the Excel sheet's row index for the column headers. The default value is 0, which means the loaded Excel sheet's first row represents the column headers.
SheetRowHeaderColumnIndex

Specifies the Excel sheet's column index for the row headers. The default value is -1, which means the loaded Excel sheet does not have row headers.
Transpose

Specifies whether the content should be transposed during the import operation. The default value is false.
UseDefaultRowColumnSizes

Set to true to use the default row height and column width from the Excel sheet when row or column sizes are not specified. The default value is false, and the grid will automatically size rows/columns with undefined dimensions.
VisibleOnly

Specifies whether only visible rows and columns should be loaded.
The default value is false.