WorkbookCopyWorksheetIntoThis(Int32, String, Boolean) Method

Copies a worksheet of the current workbook by its index

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

Syntax

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

sourceWorksheetIndex Int32: Index of the worksheet to copy, originated in this workbook
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