The ExcelWorksheet type exposes the following members.
Back to Top
Back to Top
Back to Top
Methods
| Name | Description | |
|---|---|---|
 | CalculateMaxUsedColumns |
Iterates all rows and finds maximum number of used columns.
|
| Clear |
Clears this worksheet.
|
| CreateDataTable(ColumnTypeResolution) | Obsolete.
Extracts data from used cells of this worksheet to a new DataTable.
DataTable column type is determined by the ColumnTypeResolution.
|
| CreateDataTable(CreateDataTableOptions) |
Creates a DataTable and fills it with data from this ExcelWorksheet in a manner specified by
create options, see CreateDataTableOptions.
|
| CreateDataTable(CellRange, ColumnTypeResolution, ExtractDataOptions, Boolean) | Obsolete.
Extracts data from specified range of cells to a new DataTable.
|
| CreateDataTable(ColumnTypeResolution, ExcelRow, Int32, ExtractDataOptions, ExcelColumn ) | Obsolete.
Extracts data from specified cells to a new DataTable.
|
| CreateDataTable(ColumnTypeResolution, ExcelRow, Int32, ExtractDataOptions, IEnumerable ExcelColumn ) | Obsolete.
Extracts data from specified cells to a new DataTable.
|
| CreateDataTable(ColumnTypeResolution, ExcelRow, Int32, ExtractDataOptions, Boolean, ExcelColumn ) | Obsolete.
Extracts data from specified cells to a new DataTable.
|
| CreateDataTable(ColumnTypeResolution, ExcelRow, Int32, ExtractDataOptions, Boolean, IEnumerable ExcelColumn ) | Obsolete.
Extracts data from specified cells to a new DataTable.
|
| Delete |
Deletes this worksheet from the workbook.
|
| ExtractToDataTable(DataTable, ExtractToDataTableOptions) |
Extracts data to DataTable with specified extract options, see ExtractToDataTableOptions.
|
| ExtractToDataTable(DataTable, Int32, ExtractDataOptions, ExcelRow, ExcelColumn) | Obsolete.
Extracts data to DataTable with the same column order as it is in ExcelWorksheet.
|
| ExtractToDataTable(DataTable, Int32, ExtractDataOptions, DataColumnMappingCollection, ExcelRow) | Obsolete.
Extracts data to DataTable with column mapping.
|
| ExtractUsedRangeToDataTable | Obsolete.
Extracts data from used cells of this worksheet to a new DataTable with columns of type object.
|
| GetUsedCellRange | Obsolete.
Calculates cell range that is used in the worksheet (every allocated cell is considered used).
|
| GetUsedCellRange(Boolean) |
Calculates cell range that is used in the worksheet.
|
| InsertCopy |
Inserts a copy of an existing worksheet before the current worksheet.
|
| InsertDataTable(DataTable) |
Inserts a DataTable into the current worksheet.
|
| InsertDataTable(DataTable, InsertDataTableOptions) |
Inserts a DataTable into the current worksheet.
|
| InsertDataTable(DataTable, String, Boolean) | Obsolete.
Inserts a DataTable at the specified position in
the current worksheet.
|
| InsertDataTable(DataTable, Int32, Int32, Boolean) | Obsolete.
Inserts a DataTable at the specified row and column in
the current worksheet.
|
| InsertEmpty |
Inserts an empty worksheet before the current worksheet.
|
Properties
| Name | Description | |
|---|---|---|
 | Cells | |
| Columns |
Gets collection of all columns (ExcelColumn) in the worksheet.
|
| DataValidations |
Gets the collection that expresses all data validation information for cells in a sheet which have data validation features applied.
Supported in XLSX only.
|
| DefaultColumnWidth |
Gets or sets default column width.
|
| HasHeadersFooters |
Returns true if worksheet has headers/footers.
|
| HasSplitOrFreezePanes |
Returns true if worksheet has split or freeze panes.
|
| HeadersFooters |
Gets or sets headers/footers for the sheet.
|
| HorizontalPageBreaks |
Gets collection of all horizontal page breaks
(HorizontalPageBreak) in the worksheet.
|
| Hyperlinks |
Gets hyperlinks in this sheet.
|
| Name |
Gets or sets worksheet name.
|
| NamedRanges |
Gets NamedRangeCollection
containing descriptive names which are used to represent cells, ranges of cells,
formulas, or constant values.
|
| Panes |
Gets or sets the panes in the worksheet.
|
| PasswordHash | Obsolete.
Gets or sets the password hash for protected sheet.
|
| Pictures |
Gets ExcelPictureCollection containing images.
|
| PrintOptions |
Contains MS Excel print and print related options.
|
| Protected |
Gets or sets the worksheet protection flag.
|
| ProtectionSettings |
Gets or sets worksheet protection properties. This settings will be used only if Protected is set to ;
Otherwise it will be ignored.
Supported in XLSX only.
|
| Rows |
Gets collection of all rows (ExcelRow) in the worksheet.
|
| VerticalPageBreaks |
Gets collection of all vertical page breaks
(VerticalPageBreak) in the worksheet.
|
| ViewOptions |
Contains MS Excel display and view related options.
|
| Visibility |
Gets or sets the worksheet visible property.
|
Events
| Name | Description | |
|---|---|---|
 | ExtractDataEvent | Obsolete.
Event that fires when specific error occurs while extracting data to DataTable.
|
See Also