Click or drag to resize
NanoXLSX

WorkbookAddWorksheet(Worksheet, Boolean) Method

Adding a new Worksheet. The new worksheet will be defined as current worksheet

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
Copy
public void AddWorksheet(
	Worksheet worksheet,
	bool sanitizeSheetName
)

Parameters

worksheet  Worksheet
Prepared worksheet object
sanitizeSheetName  Boolean
If true, the name of the worksheet will be sanitized automatically according to the specifications of Excel
Exceptions
ExceptionCondition
WorksheetExceptionWorksheetException is thrown if the name of the worksheet already exists, when sanitation is false
FormatExceptionFormatException is thrown if the worksheet name contains illegal characters or is out of range (length between 1 an 31) and sanitation is false
See Also