AddCopy Problem

Aspose.Cells Product Family
1

I am using your Cells product and creating a workbook from a template we have created. I have 4 sheets which are populated with data and then I have one sheet which I use Addcopy to dynamically create many new sheets. If I do not create new sheets I have no problem. If I create a new sheet then I cannot open the xls file without getting file errors. her is the code that executes to add new sheets. Any ideas?

wb.Worksheets.AddCopy("Facility")

wb.Worksheets.ActiveSheetIndex = x + 4

ws = wb.Worksheets.Item(x + 4)

If Len(ProcessLevel(x).ToString & " - " & ProcessLevelDisplayName(x).ToString) > 31 Then

ws.Name = (ProcessLevel(x).ToString)

Else

ws.Name = (ProcessLevel(x).ToString & " - " & ProcessLevelDisplayName(x).ToString.Replace("/", " "))

End If

2

Hi,

Thanks for considering Aspose.

Could you try the attached version. I tested and tried the following sample code using a template file and it works fine. I opened the output file into MS Excel and it opened fine.

[C#]
Workbook wb = new Workbook();
wb.Open("d:\\test\\Template_book .xls");
for (int i = 0;i<5;i++)
{
wb.Worksheets.AddCopy("Module_Detail");
}
wb.Save("d:\\test\\TestNewAddCopy1.xls")
[VB]
Dim wb As Workbook = New Workbook()
wb.Open("d:\test\Template_book .xls")
Dim i As Integer
For i = 0 To 4
wb.Worksheets.AddCopy("Module_Detail")
Next
wb.Save("d:\test\TestNewAddCopy1.xls")
If you still find the issue, kindly post your template file here.
Thank you.
3

How do I post the template so that you may use it.

4

Hi,

If you reply the post, you will see "File attachment " below edit box. Click "Add/Update",then.....

5

This is the file. The sheet I copy is the one named “Facility”. When I open the xls file I get a message that file is damaged and it does a recover. If I save the file and reopen everything looks fine. Could it be that I am running the trial version? I am using VB in VS2005 with a Web Project. Thanks for the help.

6

Hi,

Thanks for the template file.

We found the issue and will figure it out soon.

Thank you.

7

Hi,

Please try the attached version.

Thank you.

8

The correction did not fix the issue. Any ideas?

9
Hi,

Well, I have no problem at all. I utilized your template file and implement AddCopy() method, the output file (attached) is fine. Please make sure that your are using the lastest fix which I posted in my previous post in this thread.

Following is my sample code and attached the output file.

Workbook wb = new Workbook();
wb.Open("d:\\test\\ScoreCard_Template.xls");
for (int i = 0;i<5;i++)
{
wb.Worksheets.AddCopy("Facility");
}
wb.Save("d:\\test\\Test_AddCopy_2.xls");

If you still find the problem, please create a sample console app with your template file, zip it and post it here. We will check it soon.

Thank you.

10

I tried it again and it worked but I lost some of the formatting with your new dll. I received my license file this morning and I uninstalled cells and reinstalled the orginal version and everything is now working fine. I guess the fact that it was the trial version was the culprit. Thank You for your help.

11

We have the same problem with Aspose.Cell v4.4.0.0.

Replacing DLL with your (4.4.0.23) helps to fix the problem.

Thx!