In Excel, when you copy a worksheet from one workbook to another, the name of that worksheet is also copied.
Is it possible to have your worksheet.Copy function maintain this behavior?
Here is sample code.
Workbook excelWorkbook0 = new Workbook();
Workbook excelWorkbook1 = new Workbook();
excelWorkbook0.Worksheets[0].Name = "Worksheet 0";
excelWorkbook1.Worksheets[0].Copy(excelWorkbook0.Worksheets[0]);
excelWorkbook0.Save(@"C:\Final0.xls", FileFormatType.Default);
excelWorkbook1.Save(@"C:\Final1.xls", FileFormatType.Default);
It does not copy the worksheet name in all version that I have tried.
3.7.1.0
3.9.1.0
4.0.2.0
4.0.2.6
4.0.2.7
4.0.2.8