Description
Excel worksheet is a table with additional properties, identified by an unique name.

Namespace: Docs.Excel
Assembly: Excel (in Excel.dll) Version: 3.1.0.0 (3.1)

Syntax

         
 C#  Visual Basic  Visual C++ 
public class ExcelWorksheet
Public Class ExcelWorksheet
public ref class ExcelWorksheet

Members

         
 All Members  Properties   Methods  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
Cells
Gets collection of all ExcelCell (ExcelCell) in the ExcelWorksheet.
Columns
Gets collection of all ExcelColumn (ExcelColumn) in the ExcelWorksheet.
DefaultColumnWidth
Gets or sets a default ExcelColumn width.
Footer
Gets or sets default Footer.
Header
Gets or sets default Header.
HorizontalPageBreaks
Gets collection of all horizontal page breaks (HorizontalPageBreak) in the worksheet.
Name
Gets or sets ExcelWorksheet name.
Pictures
Collection of pictures.
Protection
This collection expresses the sheet protection options to enforce when the sheet is protected.
ReadFromDataTable(DataTable)
Reads a specified DataTable and create ExcelWorksheet.
ReadFromDataTable(Int32, Int32, DataTable, Boolean, Boolean, Boolean)
Reads entire DataTable and adds it as a worksheet starting on the Row and Column index selected. Allows you to select whether or not to use the DataTable.Column names as the first row Allows you to choose how the new sheet is named. Either via the current selected worksheet or by the datatable name
Rows
Gets collection of all ExcelRow (ExcelRow) in the ExcelWorksheet.
VerticalPageBreaks
Gets collection of all vertical page breaks (VerticalPageBreak) in the worksheet.
ViewOptions
Excel worksheet view related options.
WriteToDataTable()()()()
Allows to get data of ExcelWorksheet as a DataTable.
WriteToDataTable(Int32, Int32)
Allows to get data of ExcelWorksheet as a DataTable.
WriteToDataTable(Int32, Int32, Int32, Int32)
Allows to get data of ExcelWorksheet as a DataTable.

Inheritance Hierarchy

System..::..Object
  Docs.Excel..::..ExcelWorksheet

See Also