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
{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}