Problem with opening an xlsx made with openXML

Category: open xml format sdk

Question

Asterakin on Mon, 08 Oct 2018 15:14:01


Hi everyone, 

I have a problem with a file genered with OpenXML SDK 2.8.1, when I open it, I get the error "Excel was able to open the file by repairing or removing the unreadable content" and below : "Removed Part: Print options."

Log file : 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error085080_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\mij.ATTICPLUS\Documents\Attic\WinDesc-2016-A\AFF726\phase_001\WExport\Excel\nhfnhf - Lot N°06 METALLERIE.xlsx'</summary><removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: Print options.</removedPart></removedParts></recoveryLog>

I try to search the problem using the openXML SDK productivity tool but cannot find it.

Thank you by advance for your help

Replies

Bruce Dai -MSFT on Tue, 09 Oct 2018 12:10:27


Hi Asterakin,

According to my research, don't set the formula in excel cells when generating XLSX file. If that's not the problem, you could manually create a new workbook with inserting data from "data", then use Open XML SDK Productivity Tool to compare the "before" and "after" versions of the file. After that, you will find the difference between these two files. That is the issue.

Please refer to the following link:

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

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

Best Regards,
Bruce


MSDN Community Support Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread.


Bruce Dai -MSFT on Wed, 31 Oct 2018 08:28:21


Hi Asterakin,

I can see that this thread is still open and you did not posted on this thread since last 22 days.

is your issue is solved now?

Best Regards,

Bruce