Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Sep 12, 2017 10:22 pm

We have a function that has worked for years where we create multiple charts in excel and then save the file.

We also grab the charts as images and paste into word and then convert to PDF. The PDF has the charts, the word doc has the charts but when we open the excel file it gives an error:

"Excel cannot open <workbook name> because some content is unreadable. Do you want to open and repair this workbook?"

When i click yes all the charts are gone. The data to create them is all there.

We are on the latest version of Spire.

The charts create ok as they are in Word and PDF so must be the save.

I have tried
wb.SaveToFile(filename), SaveToFile(filename, ExcelVersion2013) and SaveToFile(filename, FileFormat.Excel2013) but none work

Any ideas as we need this urgently

ppdevs
 
Posts: 20
Joined: Sat Jan 09, 2016 7:23 pm

Wed Sep 13, 2017 1:58 am

Hi ppdevs,

Thanks for your inquiry.
To help us with a better investigation, could you please share your code together with the sample files?

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS