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.2+7f12a949130e0be1e987e553d2d08c083176cdca

Syntax

public void AddWorksheet(
	Worksheet worksheet,
	bool sanitizeSheetName
)

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

Exception	Condition
WorksheetException	WorksheetException is thrown if the name of the worksheet already exists, when sanitation is false
FormatException	FormatException is thrown if the worksheet name contains illegal characters or is out of range (length between 1 an 31) and sanitation is false