Join
Sign in
Search Options
Search Everything
Search Formats
Home
Blog
Resources
Forums
About Open XML
More ...
Home
»
Forums
»
Formats
»
SpreadsheetML
»
Excel error - tricky (does not specify which XML file)
Excel error - tricky (does not specify which XML file)
Formats
Discussions about working with different Open XML Formats
Get this RSS feed
Details
2
Replies
1
Subscriber
Posted
over 2 years ago
Options
Subscribe via RSS
Share this
SpreadsheetML
Excel error - tricky (does not specify which XML file)
rated by 0 users
This post has
2 Replies |
1
Follower
Namratha
20
Posted by
Namratha
on
Fri, May 14 2010 5:55 PM
rated by 0 users
Post Points: 20
Excel error - tricky (does not specify which XML file)
Hi, I'm generating an excel file using php code. My whole spreadsheet looks fine and the formulas are working correctly. But, when I open the spreadsheet, I get "Excel found unreadble content error". When excel repairs the sheet - it just says "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded." - Here, it does not show which xml file it repaired because of which I'm not knowing where is the mistake. I tried opening the file using the "Open and Repair" option , then checked the differences between the xml files. BUT, I couldn't find any. Can someone help me about this ?
Intergen
2610
Posted by
Intergen
on
Mon, Jul 12 2010 6:59 PM
rated by 0 users
Post Points: 5
Re: Excel error - tricky (does not specify which XML file)
Have you tried using Open XML SDK v2.0's "Open XML SDK Productivity Tool"? This offers a
"Validate"
function that often provides much better detail of any incorrect formating of the document.
Intergen
2610
Posted by
Intergen
on
Mon, Jul 12 2010 8:07 PM
rated by 0 users
Post Points: 5
Re: Excel error - tricky (does not specify which XML file)
Another option is to use the Open XML SDK v2.0's
OpenXmlValidator
- this often provides even more detail
Page 1 of 1 (3 items)