Page History

{description}
{excerpt}Inserts a new worksheet into the workbook at a specified position.{excerpt}
{signature:C#}
 public Worksheet InsertSheet(System.String name, int position)

{signature}{signature:vb.net

}
Public Function InsertSheet(ByVal name As String, ByVal position As Integer) As Worksheet

...

The name of the sheet to create and insert.

...

The 0-based position at which to insert the worksheet. If position is less than 0, it is inserted before the first sheet in the workbook. If position is equal to or greater than Worksheets.Count, it is inserted after the last worksheet.

{signature}
{parameters}
{param:name}The name of the sheet to create and insert.{param}
{param:position}The 0\-based position at which to insert the worksheet. If {{position}} is less than 0, it is inserted before the first sheet in the workbook. If {{position}} is equal to or greater than [Worksheets.Count|Worksheets.Count], it is inserted after the last worksheet.{param}
{returns}A [Worksheet|Worksheet] object representing the inserted worksheet.{returns}
{example}{code:csharp|title=C#}
sheets.InsertSheet("NewSheet", 1);

{code}
{code:vb.net

|title=vb.net

}
sheets.InsertSheet("NewSheet", 1){code}

{example}