ExcelWorksheet Members

Cells	Gets CellRange with all the cells (ExcelCell) in the worksheet.
Columns	Gets collection of all columns (ExcelColumn) in the worksheet.
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.
Pictures	Gets ExcelPictureCollection containing images.
PrintOptions	Contains MS Excel print and print related options.
Protected	Gets or sets the worksheet protection flag.
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.

Delete	Deletes this worksheet from the workbook.
ExtractToDataTable	Overloaded. Extracts data to DataTable.
GetUsedCellRange	Calculates cell range that is used in the worksheet.
InsertCopy	Inserts a copy of an existing worksheet before the current worksheet.
InsertDataTable	Overloaded. Inserts a DataTable at the specified position in the current worksheet.
InsertEmpty	Inserts an empty worksheet before the current worksheet.

Event that fires when specific error occurs while extracting data to DataTable.