Excel XLSX Archive

Post here questions and problems related to oXygen frameworks/document types.
Posts: 1
Joined: Fri Aug 14, 2015 6:06 am

Excel XLSX Archive

Post by FoxcodeBob » Fri Aug 14, 2015 6:39 am

Greetings all - newbie question here related to editing Excel XLSX archive files.

When opening the archive in the editor, the ZIP file is correctly unpacked, and I see the expected Office file structure.

In the xl/worksheets folder, the expected sheet files are displayed. However double-clicking one of the files (e.g. sheet1.xml) displays a two line document. Line one contains the typical <?xml version="1.0" encoding="UTF-8" standalone="yes"?>, but line two is the entire rest of the sheet's markup on a single line.

The structure displays correctly in, e.g., a browser. And I downloaded and added the various .jar files to allow me to File->Import the sheets one at a time into the editor, but I'm sure there's a way that I'm missing to just open the archive normally and see the content properly formatted into a multi-line, indented view.

Any help is mech appreciated - cheers for now!

Posts: 6147
Joined: Fri Jul 09, 2004 5:18 pm

Re: Excel XLSX Archive

Post by Radu » Fri Aug 14, 2015 8:38 am

Dear Bob,

You are seeing the sheet content on two lines because this is precisely how Excel saves it.
Web browsers are not designed for editing so they can afford to present an XML in slightly different forms than it actually is saved on disk.
But you also have in Oxygen the option to use the Format and indent toolbar button or as an alternative in the Preferences->Editor / Edit modes / Text page to enable the line wrap.

Radu Coravu
<oXygen/> XML Editor

Post Reply