public static ExcelWorksheet CopyWithoutContent(this ExcelWorksheets sheets, string name, string newName)
{
var sheet = sheets.Copy(name, newName);
var dimension = sheet.Dimension;
sheet.Cells[dimension.Start.Row, dimension.Start.Column, dimension.End.Row, dimension.End.Column].Value = null;
return(sheet);
}
public ExcelWorksheetInstance Copy(string name, string newName)
{
var result = m_excelWorksheets.Copy(name, newName);
return(new ExcelWorksheetInstance(this.Engine.Object.InstancePrototype, result));
}
public IWorksheet Copy(string existingWorksheet, string newWorksheet)
{
return(new EPPlusWorksheet(_worksheets.Copy(existingWorksheet, newWorksheet)));
}