Output Excel file can not be opened by EXCEL.EXE

Aspose.Cells Product Family
1

Hi,

I'm using Aspose.Cells for .NET v4.4.0.0 in a .NET 2.0 web application.

The output excel file which is generated by the web application can not be opened by Excel.exe.

Please check the attachment.

Actually, we encountered some problems with V4.3.x related to formula and got the same result.

refer <A href="</A> </P> <P> </P> <P>Charles</P> <P> </P> <P> </P>

2

Hi Charles,

Thanks for considering Aspose.

How do you create this file, Do you create this file from the scratch or from a template file. Could you paste you complete sample code here. So that we may check and figure out the issue soon.

Thank you.

3

Here are my codes....

Thanks for your help

Charles

4

Hi,

Do you use template file to generate output file (bad_excel.xls)? Your code files involve your database so it does not make much sense and cannot be implemented. Could you give us more details about the problem with steps involved and create a simple console application (using your template file(if you use)) to show the issue and post us here. It will help us to sort out the things soon.

Thank you.

5

Hi

I am experiencing the same problem. I am using a template file as the master file with some VBA inside it.

The file generation works when I create the work book from scratch, however when I open the workbook up using the master(with VBA), add my data in, and then save it appears to be corrupt when opening it up in Excel(2003 SP2).

I have tried a number of methods to get around this, including the Copy() and Combine() methods on the Workbook object, although the API states that the Combine() method can only be used for Data and probably does not work for VBA macros. When using Copy() I get the same corrupted output.

I have posted the version of ASPOSE I am using.

~ pho3nixx

6

Hi,

Thanks for considering Aspose.

Well, I tested your scenario a bit: I used a template file with some vba macros attached, opened it (workbook.Open), input some data and finally saved it to disk. I found no problem, I can open the output file in MS Excel 2000 - Excel 2007 without any problem. I also tested the template file in web Asp.Net application (VS.Net 2005 with .Net Framework 2.0 ) to open the generated file in OpenInExcel or save to disk and I found no issue.

Could you post your template file here, So that we may check and figure out the issue soon.

Thank you.

7

Thank for your reply.

We do not use template file, and no VBA. We are trying to figure which statements cause the error or/and make a console application to help you to find out the problem.

Here are some clues that may be helpful:

This application is OK when we use ASPOSE.Cells V4.1.0.0./4.3.X except the Excel formula features and AutoFitRow(). Those 2 features are also on the fixed list of V4.4.0.0..

Charles

8

Hi,

According to my test, the error is generated by the name.RefersTo. I have no idea what the format I should use for this property. Please give me a sample to show how to use it.

The format I used was:

name.RefersTo = "='" + sheet.Name + "'!$A$1:$C$3";

It works with V4.1.0.0...

Thanks

Charles

9

Hi Charles,

Please try this fix.

10

Hi pho3nixx,

Could you post your simple codes and templatea file? It will help us to find the problem.

11

Thanks

It works..

Charles