Worksheet.Copy no longer works

Aspose.Cells Product Family
1

Good day,

I installed the latest version of Aspose.Excel, and noticed that the Worksheet.Copy function no longer works. Unfortunatly, I did not keep the preveious version of Aspose.Excel on my machine, so I cannot revert to it. Would it be possible for you to e-mail it to me please?

Thanks,

Eric P.

2

Hi Eric,

I didn’t make any changes on Worksheet.Copy function. But maybe the new added features don’t work well with it. I will check and fix it ASAP. Could you email your error message, your designer file and related code to excel@aspose.com? Thanks.

3

@EricP,
Aspose.Excel is no more available now and is discontinued. A new product Aspose.Cells has replaced it that is more efficient and feature-rich. It provides detailed features of copying/moving and managing worksheets. Following sample code demonstrates copying the worksheet.

// Create a Workbook.
// Open a file into the first book.
Workbook excelWorkbook0 = new Workbook(InputPath);

// Create another Workbook.
Workbook excelWorkbook1 = new Workbook();

// Copy the first sheet of the first book into second book.
excelWorkbook1.Worksheets[0].Copy(excelWorkbook0.Worksheets[0]);

// Save the file.
excelWorkbook1.Save(dataDir + "CopyWorksheetsBetweenWorkbooks_out.xls");

Here are the links that provide detailed information about managing the worksheets.
Copying and Moving Worksheets
Manage Worksheets

Here is a free trial version of this product:
Aspose.Cells for .NET (Latest Version)

A detailed solution is available here which can be used for testing different features of this product.