Class ExcelWorksheetCopyOptions¶
Namespace: OfficeOpenXml.Core.Worksheet
Assembly: EPPlus.dll
Used to specify options when copying a worksheet.
Inheritance¶
object ← ExcelWorksheetCopyOptions
Inherited Members¶
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()
Constructors¶
ExcelWorksheetCopyOptions()¶
Properties¶
PivotTableCopyHandler¶
A handler that is invoked for each pivot table that is copied to the new worksheet. Use this to assign a custom name to the copied pivot table. When a worksheet is copied within the same workbook, copied pivot tables are otherwise given a generated name (PivotTable1, PivotTable2, ...). Set NewName on the argument to rename the copied pivot table. The rename is applied through the same path as a normal Name assignment, so name uniqueness is validated.
Property Value¶
Action<ExcelPivotTableCopyEventArgs>
TableCopyHandler¶
A handler that is invoked for each table that is copied to the new worksheet. Use this to assign a custom name to the copied table. When a worksheet is copied within the same workbook, copied tables are otherwise given a generated name (Table1, Table2, ...). Set NewName on the argument to rename the copied table. The rename is applied through the same path as a normal Name assignment, so formula references are updated and name uniqueness is validated.