Excel XLSX Archive
Posted: 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!
Bob
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!
Bob