Problem With Content

Created originally on Bitbucket by Dan K (Dan Kanefsky)

I have an excel file exported from File Maker Pro and even if I load the workbook and save without reading or writing anything:

wb = openpyxl.load_workbook(&#39;Original.xlsx&#39;)
wb.save(&#39;Original.xlsx&#39;)

it gives me this error when I open it up after running it through openpyxl.

‌

If I click Yes, it give me an option to view the error xml file:

&lt;?xml version=&#34;1.0&#34; encoding=&#34;UTF-8&#34; standalone=&#34;yes&#34;?&gt;
&lt;recoveryLog xmlns=&#34;http://schemas.openxmlformats.org/spreadsheetml/2006/main&#34;&gt;
&lt;logFileName&gt;Repair Result to new1.xml&lt;/logFileName&gt;
&lt;summary&gt;Errors were detected in file &#39;/Volumes/post/new.xlsx&#39;&lt;/summary&gt;
&lt;removedParts summary=&#34;Following is a list of removed parts:&#34;&gt;
&lt;removedPart&gt;Removed Part: /xl/styles.xml part with XML error.  (Styles) HRESULT 0x8000ffff&lt;/removedPart&gt;
&lt;/removedParts&gt;&lt;repairedRecords summary=&#34;Following is a list of repairs:&#34;&gt;
&lt;repairedRecord&gt;Repaired Records: Cell information from /xl/worksheets/sheet1.xml part&lt;/repairedRecord&gt;
&lt;/repairedRecords&gt;
&lt;/recoveryLog&gt;

Once I repair the file, everything is fine except there is no styling throughout the workbook (bold headers, fonts, etc).

HOWEVER, if I simply open and then save the excel file before running it through openpyxl, it does not throw that error and everything is fine.

I would really like to avoid this alert without having to manually open up each excel file.

It might have to do with the excel file out of File Maker missing a line in the XML and a “themes” file. I’ve compared all three XML’s by opening up with excel file with textwrangler.

For reference:

“Original” – the XML of the original excel file straight out of File Maker

“Saved” – is the XML of the original file simply opened up in excel and saved, no changes were made.

“Original RAN” and “Saved RAN” – is the xml after I loaded and saved with openpyxl

“Original RAN Recovered” – is the xml after the Original was run through openpyxl then opened up in excel, repaired and then saved.

‌

&lt;!--Original--&gt;

&lt;?xml version=&#34;1.0&#34; encoding=&#34;UTF-8&#34; standalone=&#34;yes&#34;?&gt;
&lt;Types xmlns=&#34;http://schemas.openxmlformats.org/package/2006/content-types&#34;&gt;
&lt;Default ContentType=&#34;application/vnd.openxmlformats-package.relationships+xml&#34; Extension=&#34;rels&#34;/&gt;
&lt;Default ContentType=&#34;application/xml&#34; Extension=&#34;xml&#34;/&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml&#34; PartName=&#34;/xl/workbook.xml&#34;/&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.extended-properties+xml&#34; PartName=&#34;/docProps/app.xml&#34;/&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml&#34; PartName=&#34;/xl/worksheets/sheet1.xml&#34;/&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml&#34; PartName=&#34;/xl/sharedStrings.xml&#34;/&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-package.core-properties+xml&#34; PartName=&#34;/docProps/core.xml&#34;/&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml&#34; PartName=&#34;/xl/styles.xml&#34;/&gt;&lt;/Types&gt;

&lt;!-- Saved --&gt;

&lt;?xml version=&#34;1.0&#34; encoding=&#34;UTF-8&#34; standalone=&#34;yes&#34;?&gt;
&lt;Types xmlns=&#34;http://schemas.openxmlformats.org/package/2006/content-types&#34;&gt;
&lt;Default Extension=&#34;rels&#34; ContentType=&#34;application/vnd.openxmlformats-package.relationships+xml&#34;/&gt;
&lt;Default Extension=&#34;xml&#34; ContentType=&#34;application/xml&#34;/&gt;
&lt;Override PartName=&#34;/xl/workbook.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml&#34;/&gt;
&lt;Override PartName=&#34;/xl/worksheets/sheet1.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml&#34;/&gt;
&lt;Override PartName=&#34;/xl/theme/theme1.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.theme+xml&#34;/&gt; 
&lt;Override PartName=&#34;/xl/styles.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml&#34;/&gt;
&lt;Override PartName=&#34;/xl/sharedStrings.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml&#34;/&gt;
&lt;Override PartName=&#34;/docProps/core.xml&#34; ContentType=&#34;application/vnd.openxmlformats-package.core-properties+xml&#34;/&gt;
&lt;Override PartName=&#34;/docProps/app.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.extended-properties+xml&#34;/&gt;&lt;/Types&gt;

&lt;!-- Original RAN --&gt;

&lt;Types xmlns=&#34;http://schemas.openxmlformats.org/package/2006/content-types&#34;&gt;
&lt;Default ContentType=&#34;application/vnd.openxmlformats-package.relationships+xml&#34; Extension=&#34;rels&#34; /&gt;
&lt;Default ContentType=&#34;application/xml&#34; Extension=&#34;xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml&#34; PartName=&#34;/xl/styles.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.theme+xml&#34; PartName=&#34;/xl/theme/theme1.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-package.core-properties+xml&#34; PartName=&#34;/docProps/core.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.extended-properties+xml&#34; PartName=&#34;/docProps/app.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml&#34; PartName=&#34;/xl/worksheets/sheet1.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml&#34; PartName=&#34;/xl/workbook.xml&#34; /&gt;
&lt;/Types&gt;


&lt;!-- Saved RAN --&gt;

&lt;Types xmlns=&#34;http://schemas.openxmlformats.org/package/2006/content-types&#34;&gt;
&lt;Default ContentType=&#34;application/vnd.openxmlformats-package.relationships+xml&#34; Extension=&#34;rels&#34; /&gt;
&lt;Default ContentType=&#34;application/xml&#34; Extension=&#34;xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml&#34; PartName=&#34;/xl/styles.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.theme+xml&#34; PartName=&#34;/xl/theme/theme1.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-package.core-properties+xml&#34; PartName=&#34;/docProps/core.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.extended-properties+xml&#34; PartName=&#34;/docProps/app.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml&#34; PartName=&#34;/xl/worksheets/sheet1.xml&#34; /&gt;
&lt;Override ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml&#34; PartName=&#34;/xl/workbook.xml&#34; /&gt;
&lt;/Types&gt;

&lt;!-- Original Ran Revoered (SAVED) --&gt;

&lt;?xml version=&#34;1.0&#34; encoding=&#34;UTF-8&#34; standalone=&#34;yes&#34;?&gt;
&lt;Types xmlns=&#34;http://schemas.openxmlformats.org/package/2006/content-types&#34;&gt;
&lt;Default Extension=&#34;rels&#34; ContentType=&#34;application/vnd.openxmlformats-package.relationships+xml&#34;/&gt;
&lt;Default Extension=&#34;xml&#34; ContentType=&#34;application/xml&#34;/&gt;&lt;Override PartName=&#34;/xl/workbook.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml&#34;/&gt;
&lt;Override PartName=&#34;/xl/worksheets/sheet1.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml&#34;/&gt;
&lt;Override PartName=&#34;/xl/theme/theme1.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.theme+xml&#34;/&gt;
&lt;Override PartName=&#34;/xl/styles.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml&#34;/&gt;
&lt;Override PartName=&#34;/xl/sharedStrings.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml&#34;/&gt;
&lt;Override PartName=&#34;/docProps/core.xml&#34; ContentType=&#34;application/vnd.openxmlformats-package.core-properties+xml&#34;/&gt;
&lt;Override PartName=&#34;/docProps/app.xml&#34; ContentType=&#34;application/vnd.openxmlformats-officedocument.extended-properties+xml&#34;/&gt;&lt;/Types&gt;

‌

Line 22 is the one discrepancy between the Original excel XML and the Saved XML. However, I’m not sure what this actually means.

Unfortunately I cannot provide the original.xlsx file because it has private information and as soon as I open up and save the file, there are no issues.

Appreciate any insight! I hope I provided enough info.

Attachments: Original.xml saved.xml Original_2.xml Saved_2.xml Original_style.xml Saved_style.xml

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information