public IVTWorksheet CopySheetToBefore(IVTWorksheet worksheet, int index)
{
NativeExcel.IWorksheet sheet = Workbook.Worksheets.AddBefore(index);
IVTWorksheet vtSheet = new VTWorksheet(sheet);
vtSheet.CopySheet(worksheet);
return(vtSheet);
}
public IVTWorksheet CopySheetToBefore(IVTRange worksheetRange, int index, string sheetname = "")
{
NativeExcel.IWorksheet sheet = Workbook.Worksheets.AddBefore(index);
IVTWorksheet vtSheet = new VTWorksheet(sheet);
vtSheet.CopyPasteSameSize(worksheetRange, 1, 1);
vtSheet.Name = sheetname;
return(vtSheet);
}
public IVTWorksheet CopySheetToBeforeLast(IVTWorksheet worksheet)
{
NativeExcel.IWorksheet templateSheet = worksheet.Worksheet;
NativeExcel.IWorksheet sheet = Workbook.Worksheets.AddBefore(Workbook.Worksheets.Count);
IVTWorksheet vtSheet = new VTWorksheet(sheet);
vtSheet.CopySheet(worksheet);
return(vtSheet);
}
public IVTWorksheet CopySheetToLast(IVTWorksheet worksheet, string lastCell = null)
{
NativeExcel.IWorksheet templateSheet = worksheet.Worksheet;
NativeExcel.IWorksheet sheet = Workbook.Worksheets.AddAfter(Workbook.Worksheets.Count);
IVTWorksheet vtSheet = new VTWorksheet(sheet);
if (lastCell == null)
{
vtSheet.CopySheet(worksheet);
}
else
{
vtSheet.CopySheet(worksheet, lastCell);
}
return(vtSheet);
}
public IVTWorksheet CopySheetToLastClearColor(IVTWorksheet worksheet, string lastCell = null, object Color = null)
{
NativeExcel.IWorksheet templateSheet = worksheet.Worksheet;
NativeExcel.IWorksheet sheet = Workbook.Worksheets.AddAfter(Workbook.Worksheets.Count);
if (Color != null)
{
sheet.Cells.Interior.Color = (Color)Color;
}
IVTWorksheet vtSheet = new VTWorksheet(sheet);
if (lastCell == null)
{
vtSheet.CopySheet(worksheet);
}
else
{
vtSheet.CopySheet(worksheet, lastCell);
}
return(vtSheet);
}
