WorkbookCopyWorksheetIntoThis(Worksheet, String, Boolean) Method

Copies a worksheet of any workbook into the current workbook

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc

Syntax

public Worksheet CopyWorksheetIntoThis(
	Worksheet sourceWorksheet,
	string newWorksheetName,
	bool sanitizeSheetName = true
)

sourceWorksheet Worksheet: Worksheet to copy
newWorksheetName String: Name of the new worksheet (copy)
sanitizeSheetName Boolean (Optional): If true, the new name will be automatically sanitized if a name collision occurs

Worksheet
Copied worksheet

Remarks

The copy is not set as current worksheet. The existing one is kept. The source worksheet can originate from any workbook