'excel found unreadable content' error is coming while opening xlsx file
I have an application which exports data into .xlsx format. The excel file of format .xlsx is created through OpenXML. While trying to open it it gives error "Excel found unreadable content in (filename). Do you want to recover the contents of this workbook? if you trust the source of this workbook, click Yes." On click of yes file opens with another message giving log file of the repair. Once its opened, I save the file under some other name and now if I try to open the second file, it opens fine.
This only happens with Office 2010, with MS office 2007 its works fine. I even tried to create a small application (just to be sure is not related to my code) exactly same as in this link small application link . The issue remained same I was able to open the excel file fine in 2007 but in MS office 2010 it gave same error. I googled a lot but no answer. I cant change the file to resolve the issue once its created. I only need to make changes in the code to solve the issue. Please help
This only happens with Office 2010, with MS office 2007 its works fine. I even tried to create a small application (just to be sure is not related to my code) exactly same as in this link small application link . The issue remained same I was able to open the excel file fine in 2007 but in MS office 2010 it gave same error. I googled a lot but no answer. I cant change the file to resolve the issue once its created. I only need to make changes in the code to solve the issue. Please help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Brina, I am not able to attach the file over here. it says
"The extension of one or more files in the archive is not in the list of allowed extensions: _rels/.rels"
but it allows to attach the file which I recovered and saved under another name. There is something wrong in the original file's _rels/.rels xml file. May be this is linked to file not opening properly. As _rels/.rels xml file is present in both recovered and original file. Can I mail you both the xlsx file somewhere else?
"The extension of one or more files in the archive is not in the list of allowed extensions: _rels/.rels"
but it allows to attach the file which I recovered and saved under another name. There is something wrong in the original file's _rels/.rels xml file. May be this is linked to file not opening properly. As _rels/.rels xml file is present in both recovered and original file. Can I mail you both the xlsx file somewhere else?
Thanks, sachitjain.
Brina
Oh dear, I can't even spell my own name - it's "Brian" (probably). :)
or more files in the archive is not in the list of allowed extensions: _rels/.rels"
These files are a normal component of xlsx and xlsm files, so apparently the file is being recognised as a zip file (which those files are) rather than a spreadsheet. Please check that the extension on the file is xlsx or xlsm, as appropriate (probably xlsx) and retry the post.
Thanks,
Brian.
Brina
Oh dear, I can't even spell my own name - it's "Brian" (probably). :)
or more files in the archive is not in the list of allowed extensions: _rels/.rels"
These files are a normal component of xlsx and xlsm files, so apparently the file is being recognised as a zip file (which those files are) rather than a spreadsheet. Please check that the extension on the file is xlsx or xlsm, as appropriate (probably xlsx) and retry the post.
Thanks,
Brian.
ASKER
Brian,
the file is right extension only .xlsx
the file is right extension only .xlsx
Thanks, sachitjain.
Very interesting! It appears that there's something "wrong" with the file so that EE is not recognising it as a spreadsheet.
I've shown my address below but please note that if you send it to me, EE will expect you to send it to any other expert who requests it. If that's OK then please send the file.
******************
Thanks,
Brian.
Very interesting! It appears that there's something "wrong" with the file so that EE is not recognising it as a spreadsheet.
I've shown my address below but please note that if you send it to me, EE will expect you to send it to any other expert who requests it. If that's OK then please send the file.
******************
Thanks,
Brian.
ASKER
I've requested that this question be deleted for the following reason:
no reason
no reason
Can you post for us a copy of a file with this problem, please? I appreciate that the data is probably sensitive, but perhaps you could create a dummy entry in your application and export that?
Thanks,
Brina.