Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

Returns the worksheet with the specified name. This property is an indexer for the Workbook class.

Signature
C#C#
Wiki Markup
{description}
{excerpt}Returns the worksheet with the specified name. This property is an indexer for the [Workbook|Workbook] class.{excerpt}
{signature:C#}
 public Worksheet this[System.String sheetName] { get; }
Signature
{signature}{signature:vb.net
vb.net
}
Public Default ReadOnly Property Item(ByVal sheetName As String) As Worksheet
Parameters

...

The name of the worksheet.

Returns

The worksheet with the specified name.

{signature}
{parameters}
{param:name}The name of the worksheet.{param}
{returns}The worksheet with the specified name.{returns}
{example}{code:csharp|title=C#}

          //--- Get the worksheet titled "Sheet1"
          Worksheet ws = wb["Sheet1"];
        
{code}
{code:vb.net
|title=vb.net
}

          '--- Get the worksheet titled "Sheet1"
          Dim ws As Worksheet = wb("Sheet1")
        {code}

{example}
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle