InsertSheet Method

Inserts a sheet at the specified index.

Syntax

[VB.NET]
Public Sub InsertSheet(ByVal SheetIndex As Integer)

[C#]
public void InsertSheet(int sheetIndex);

Remarks

This method inserts a sheet at the specified SheetIndex. The SheetIndex parameter is 0-based. Valid values for SheetIndex are from 0 to SheetCount. When inserting a sheet, the existing sheets will be shifted to the right. For instance to insert a sheet after the first sheet:

Exceldoc1.InsertSheet(1);