The Worksheet class represents a single Excel worksheet.

[DefaultMember("Item")]
 public class Worksheet
<DefaultMember("Item")> _
	Public Class Worksheet

To add a Worksheet to a Workbook, call Workbook.Worksheets.CreateWorksheet(). To get an existing Worksheet call Workbook.Worksheets[index or name].

          //--- Create a new Worksheet
          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets.CreateWorksheet("Sheet2");

          //--- Get an existing Worksheet by index
          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets[0];

          //--- Get an existing Worksheet by name
          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets["Sheet1"];
          '--- Create a new Worksheet
          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ws As Worksheet = wb.Worksheets.CreateWorksheet("Sheet2")

          '--- Get an existing Worksheet by index
          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ws As Worksheet = wb.Worksheets(0)

          '--- Get an existing Worksheet by name
          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ws As Worksheet = wb.Worksheets("Sheet2")
        

Name

Description

Cells

Charts

Comments

FirstShownColumn

FirstShownRow

FreezePanes

GridlinesColor

Hyperlinks

IsProtected

IsSelected

Name

NamedRanges

PageSetup

Pictures

PopulatedCells

Position

ProtectPasswordHash

ShapeGroups

Shapes

SheetProtection

ShowFormulas

ShowGridlines

ShowRowColHeaders

ShowZeroValues

StandardHeight

StandardWidth

StandardWidthInChars

SummaryColumns

SummaryRows

TabColor

Workbook

ViewState

Visibility

ZoomPercentage

Name

Description

Item(Int32, Int32)

Item(String)

Name

Description

CopyPaste(Cell, Area)

CopyPaste(Cell, Area, CopyPasteProperties)

CopyPaste(Int32, Int32, Area)

CopyPaste(Int32, Int32, Area, CopyPasteProperties)

CopyPaste(String, Area, CopyPasteProperties)

CopyPaste(String, Area)

CreateAnchor(Int32, Int32, Double, Double)

CreateArea(Int32, Int32, Int32, Int32)

CreateArea(String)

CreateAreaOfColumns(Int32, Int32)

CreateAreaOfRows(Int32, Int32)

CreateNamedRange(Int32, Int32, Int32, Int32, String)

CreateNamedRange(String, String)

CreateRange(String)

DeleteColumn(Int32)

DeleteColumns(Int32, Int32)

DeleteRow(Int32)

DeleteRows(Int32, Int32)

GetColumnProperties(Int32)

GetNamedObject(String)

GetNamedRange(String)

GetRowProperties(Int32)

GroupColumns(Int32, Int32, Boolean)

GroupRows(Int32, Int32, Boolean)

ImportData(Object()(), Cell)

ImportData(Object()(), String(), Cell, DataImportProperties)

ImportData(System.Data.DataTable, Cell)

ImportData(System.Data.DataTable, Cell, DataImportProperties)

ImportData(System.Data.DataView, Cell)

ImportData(System.Data.DataView, Cell, DataImportProperties)

ImportData(Object(,), Cell)

ImportData(Object(,), String(), Cell, DataImportProperties)

ImportData(System.Data.IDataReader, Cell)

ImportData(System.Data.IDataReader, Cell, DataImportProperties)

InsertColumn(Int32)

InsertColumn(Int32, ColumnInsertBehavior)

InsertColumn(Int32, ColumnInsertBehavior, ColumnInsertBehavior)

InsertColumns(Int32, Int32)

InsertColumns(Int32, Int32, ColumnInsertBehavior)

InsertColumns(Int32, Int32, ColumnInsertBehavior, ColumnInsertBehavior)

InsertHorizontalPageBreak(Cell)

InsertRow(Int32)

InsertRow(Int32, RowInsertBehavior)

InsertRow(Int32, RowInsertBehavior, RowInsertBehavior)

InsertRows(Int32, Int32)

InsertRows(Int32, Int32, RowInsertBehavior)

InsertRows(Int32, Int32, RowInsertBehavior, RowInsertBehavior)

InsertVerticalPageBreak(Cell)

Protect(String)

Select()

UngroupColumns(Int32, Int32)

UngroupRows(Int32, Int32)

Unprotect()

Overload

Description

ImportData(Cell, Microsoft.SharePoint.SPList, DataImportProperties)

ImportData(Cell, Microsoft.SharePoint.SPList)

ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)

ImportData(Cell, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)

Name

Description

Constants

SheetViewState

SheetVisibility

SummaryColumnsLocation

SummaryRowsLocation