Version

Add(String) Method

Creates a new Worksheet and adds it to the collection.
Syntax
'Declaration
 
Public Function Add( _
   ByVal name As String _
) As Worksheet
public Worksheet Add( 
   string name
)

Parameters

name
The name to give the new Worksheet.

Return Value

The Worksheet created with the specified name.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionname is null or empty.
System.ArgumentExceptionname contains the invalid characters: ':', '\', '/', '?', '*', '[', or ']'.
System.ArgumentExceptionname exceeds 31 characters in length.
System.ArgumentExceptionname is being used as the name of another worksheet (worksheet names are case-insensitively compared).
Remarks

If the workbook originally had no worksheets, the newly added worksheet will become the selected worksheet of the workbook. This can be changed after more worksheets are added by setting the WindowOptions.SelectedWorksheet of the Workbook.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also