How to properly assemble a valid xlsx file from its internal sub-components?

Question

I'm trying to create an xlsx file programmatically on iOS. Since the internal data of xlsx files is basically stored in separate xml files, I tried to recreate xlsx structure with all its files and subdirectories, compress them into a zip file and set its extension to xlsx. I use GDataXML parser/writer for creating all the necessary xml files. However, the file I get can't be opened as xlsx file. Even if I rip all the data from a valid xlsx file, create all the xml files manually by copying data from the original xml files and compress them manually, I can't recreate a valid xlsx file.

The questions are:

• is xlsx really just an archive containing xml files?
• how do I create a valid xlsx file programmatically if I can't just compress xml files into zip file and set its extension to xlsx?

Solution 1

In answer to your questions:

1. XLSX is just a collection of XML files in a zip container. There is no other magic.
2. If you decompress/unzip a valid XLSX files and then recompress/zip it and you can't read the resulting output then the problem is with the zipping software or the files your rezipped. Try a different library/utility or check the default compression type and levels that it uses and try match it to whatever Excel uses. Or check the zip file to make sure the directory structure was maintained.

Example of the contents of an xlsx file:

unzip -l example.xlsx
Archive:  example.xlsx
  Length     Date   Time    Name
 --------    ----   ----    ----
      769  10-15-14 09:23   xl/worksheets/sheet1.xml
      550  10-15-14 09:22   xl/workbook.xml
      201  10-15-14 09:22   xl/sharedStrings.xml
      ...

I regularly unzip XLSX files, make minor changes for testing and re-zip them without any issue.

Update: The important thing is to avoid zipping the parent directory. Here is an example using the zip system utility on Linux or the OS X:

# Unzip an xlsx file into a directory.
unzip example.xlsx -d newdir

# Make some valid changes to the files.
cd newdir/
vi xl/worksheets/sheet1.xml

# Rezip the files *FROM* the unzipped directory.
# Note: you could also re-zip to the original file if required.
find . -type f | xargs zip ../newfile.xlsx

# Check the file looks okay.
cd ..
unzip -l newfile.xlsx
xdg-open newfile.xlsx

Solution 2

If I decompress an xlsx file into a folder and then I recompress it again, the xlsx becomes corrupt / not recognized. In my case, the cause is that my zip tool is using the folder name as the first level for the relative path of each file inside the zip.

I have solved the problem by creating an empty zip file INSIDE the folder with the xlsx contents and then adding all the files and folders to it.

Actually, if you try to zip the folder itself, the file is not a valid xlsx. You should rather go inside the folder, select all the contents and then right-click & zip.

Solution 3

I was using WinZip 15.5 to rezip xlsx xml files. Different compression types produced different results.

Note: The original file size was 555KB.

• .Zip: New filesize 3,279KB (!). Excel can open.
• .Zipx: New filesize 341KB. Excel couldn't open.
• Zip SuperFast: New filesize 606KB. Excel can open.
• Zip Enh. Deflate: New filesize 429KB. Excel couldn't open.
• Zipx bzip2: New filesize 333KB. Excel couldn't open.
• Zipx LZMA: New filesize 328KB. Excel couldn't open.
• Zipx PPMd: New filesize 317KB. Excel couldn't open.

Conclusion: Zip SuperFast is the only effective compression format.

Solution 4

I was having issues and found that was zipping on the wrong folder level. You need to navigate into folder created when you unziped the xlsx and zip the actual files, not the container folder. Dummy me, shared my story, maybe it can help others save time...

View more solutions