Excel Issue: We found a problem with some content in excel
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-06-20 04:18 PM
Hello All,
I am using a large excel workbook (10K Records) for my automation. I run around 1K records daily and update the original spreadsheet after the day's run using "Data OLEDB Object" . Some how the Excel file get corrupted and I am unable to use it after that.
The error which I get is "We found a problem with some content in x.xlsx. Do you want us to recover"
If I recover it, I still loose the data. In the logs I found this error.
"/xl/worksheets/sheet1.xml part with XML error. A document must contain exactly one root element. Line 1, column 0"
Any work around this. How to fix this issue. Would really appreciate your help?
------------------------------
Rahul Narang
------------------------------
I am using a large excel workbook (10K Records) for my automation. I run around 1K records daily and update the original spreadsheet after the day's run using "Data OLEDB Object" . Some how the Excel file get corrupted and I am unable to use it after that.
The error which I get is "We found a problem with some content in x.xlsx. Do you want us to recover"
If I recover it, I still loose the data. In the logs I found this error.
"/xl/worksheets/sheet1.xml part with XML error. A document must contain exactly one root element. Line 1, column 0"
Any work around this. How to fix this issue. Would really appreciate your help?
------------------------------
Rahul Narang
------------------------------
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-06-20 02:36 PM
Hi Rahul,
It looks like the issue related to the Excel application and transfers to the Blue Prism. Please look at this web site; It may help with the issue.
https://www.systoolsgroup.com/updates/fix-we-found-a-problem-with-some-content-in-excel-error/
http://www.repairmsexcel.com/blog/resolve-excel-2013-content-error
Regards
------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------
It looks like the issue related to the Excel application and transfers to the Blue Prism. Please look at this web site; It may help with the issue.
https://www.systoolsgroup.com/updates/fix-we-found-a-problem-with-some-content-in-excel-error/
http://www.repairmsexcel.com/blog/resolve-excel-2013-content-error
Regards
------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------
