Hai Guys.....

I have developed a code for writing and reading excel file in Open XML.

Downloading a .xlsx file gives "We found a problem with some content in 'FileName.xlsx'.Do you want us to try to recover as much as we can? If you trust the source of this workbook, Click Yes". On clicking "Yes" button, it displays content.  I am able to open the file after it is repaired and the data seems to be fine.Error shows for both Open and save options. But after repair data is still there.

I am using Windows 8  and Office 2013.

Please let me know if there is anything I need to do...

Any help appreciated.

Hi Cendav,

This workbook is generated by your code or it is just a regular shared workbook?
If it's generated by the Code you wrote, maybe there are some problems of your code, you can go to have a check. 
Also did you get any message when you click 'yes' button? Like 'removed part' ,'removed feature'...

In addition, you can save this excel file as zip file to check directly.

• Edited by zkandyModerator Thursday, February 20, 2014 7:56 AM

Thanks for reply......

When I click 'yes' button .. I am getting a popup like

'Excel was able to open the file by repairing or removing the unreachable content'

Below that .....

'Removed Records : Cell information from /xl/worksheets/sheet.xml part'.

'Repaired Records : worksheet properties from/xl/workbook.xml part (Workbook)'

when i close this popup,  data will display...

Any help appreciated.

Looks like similar pop-up messages mentioned in the following threads:
http://openxmldeveloper.org/discussions/formats/f/14/p/3210/80568.aspx

http://stackoverflow.com/questions/9401508/repaired-records-cell-information-from-worksheet-created-from-scratch

If you are adding a string to a cell rather than a number (or a string that can be converted to a number) then you should use an inline string or a shared string instead of the CellValue.  You can only use CellValue if the value is numeric.

Hope that helps.

• Marked as answer by zkandyModerator Thursday, February 27, 2014 1:21 AM

I had a similar issue on an xlsx report generated by SSRS.

The problem was resolved by converting numeric output (displayed as percentage) to SQL 'money' data type.

E.g.

= CONVERT(money,1.0*SUM([QTY_SHIP])/NULLIF(SUM([QTY_ORDER]),0))

which yields 0.00 instead of 0.00000000000000000

or 0.0808 instead of 0.08079334411103663

Jim

• Edited by TheChoffMan 11 hours 4 minutes ago

I had a similar issue on an xlsx report generated by SSRS.

The problem was resolved by converting numeric output (displayed as percentage) to SQL 'money' data type.

E.g.

= CONVERT(money,1.0*SUM([QTY_SHIP])/NULLIF(SUM([QTY_ORDER]),0))

which yields 0.00 instead of 0.00000000000000000

or 0.0808 instead of 0.08079334411103663

Jim

• Edited by TheChoffMan Friday, September 04, 2015 8:30 PM