Page tree

Versions Compared

Key

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

Excerpt

Creates a new worksheet at a specified position in the workbook.

Signature
C#C#
Wiki Markup
{description}
{excerpt}Creates a new worksheet at a specified position in the workbook.{excerpt}
{signature:C#}
 public Worksheet CreateWorksheet(System.String name, int position)
Signature
{signature}{signature:vb.net
vb.net
}
Public Function CreateWorksheet(ByVal name As String, ByVal position As Integer) As Worksheet
Parameters

...

Name for the new worksheet.

...

The 0-based position at which to insert the worksheet. If position is greater than Worksheets.Count, an exception will be thrown.

Returns

A Worksheet object representing the worksheet created.

{signature}
{parameters}
{param:name}Name for the new worksheet.{param}
{param:position}The 0\-based position at which to insert the worksheet. If {{position}} is greater than [Worksheets.Count|Worksheets.Count], an exception will be thrown.{param}
{returns}A [Worksheet|Worksheet] object representing the worksheet created.{returns}
{example}{code:csharp|title=C#}
Worksheet ws = sheets.CreateWorksheet("NewSheet", 0);
{code}
{code:vb.net
|title=vb.net
}
Dim ws As Worksheet = sheets.CreateWorksheet("NewSheet", 0){code}

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