I am creating an XLSX file in VB.Net with two sheets - each created from a DataTable.
When I open the file in Excel 2010, I get the following error - any suggestions on how to resolve this issue would be greatly appreciated.
Excel found unreadable content in 'C:\temp\test.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.
When I click 'Yes', the workbook opens and contains all of the expected rows and columns, however, a second popup appears titled "Repairs to 'test.xlsx'" with the message "Excel was able to open the file by repairing or removing the unreadable
content." The detail area of this popup contains the following:
Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Repaired Records: Table from /xl/tables/table.xml part (Table)
Below the detail area is a link to "view log file listing repairs". The contents of that log file are as follows:
<?xml version="1.0" encoding="UTF-8" standalone="yes"
<summary>Errors were detected in file 'C:\temp\S210_OrderPriceOverrides.xlsx'</summary>
<repairedRecords summary="Following is a list of repairs:">
<repairedRecord>Repaired Records: Table from /xl/tables/table.xml part (Table)</repairedRecord>