C1.WPF.Grid.LoadExcelOptions

LoadExcelOptions Class

Represents options for loading data from an Excel file.

Inheritance

LoadExcelOptions

Namespace: C1.WPF.Grid

Assembly: C1.WPF.Grid.Excel.dll

Syntax

public class LoadExcelOptions

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`.