ExcelPackage: Office Open XML Format file creation

Topics: Developer Forum
Jan 15, 2007 at 5:30 AM
This is in reference to the following title "ExcelPackage: Office Open XML Format file creation".

We have downloaded the sample, source code and the related files including the template for generating the .xlsx file from the .xlsx template and have made appropriate changes for the database connectivity and also commented out calls to sample1 and sample2, we are simply making a call to sample3 class. The source code compiles and executes as expected generating the valid resultant .xlsx file. however when we include a chart object in the template, though the source code compiles and executes fine but the resultant .xlsx file fails to open and prompts with the following message.

"Excel found unreadable content in 'sample3.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

If we opt to recover the contents by clicking Yes, the chart object does not appear.

Can anyone please suggest a solution to this. I need to include a chart object within the template.

Thanks in advance,

Jan 25, 2007 at 12:21 AM
ExcelPackage does not currently provide support for charts. Your issue is a classic problem of missing or misplaced cross-references within the file. You will need to open the file with ZIP and take a look at it before and after ExcelPackage altered the data. I think you will find that a cross-ref is out of place, which is causing the problem.

Feb 27, 2010 at 4:43 AM


Are there any updates in ExcelPackage?

I need to create charts using ExcelPackage.

Is it possible now?