openxls-develop

[openxls-develop] OpenXLS cannot read its own empty OOXML file

[Philip N. <prn...@us...>]

Subject says all.

Steps to reproduce:

- Create an OOXML along the lines of (Octave/Matlab script language):
wb = javaObject ("com.extentech.ExtenXLS.WorkBookHandle", true);

- Remove sheets #1 and #2 (keep Sheet #0). Note: all these sheets are empty.
Optionally rename Sheet1 to "EmptySheet"

- Write file to disk (using Octave/Matlab):
   xlsout = javaObject ("java.io.FileOutputStream", "io-test.xlsx");
   xls.workbook.write (xlsout);
   xlsout.close ();
   xls.workbook.close ();

Excel 2013 and LibreOffice read this file just fine.
Apache POI apparently parses it OK but spots an empty cell B4.
Inspecting it using 7-zip yields nothing special (admittedly I'm no 
OOXML guru). However there is indeed a cell B4 in the only worksheet:

(Expanded sheet 1 "EmptySheet":)

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet 
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" 
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><dimension 
ref="A1:B5"/>
   <sheetViews>
     <sheetView tabSelected="1" workbookViewId="0"></sheetView>
   </sheetViews>
   <sheetFormatPr defaultColWidth="8.0" defaultRowHeight="12.75"/>
   <sheetData>
     <row r="4">
       <c r="B4" s="15"></c>
     </row>
   </sheetData>
</worksheet>


Upon trying to read the file in Octave using OpenXLS, I get:

2013-12-30 21:20:02:0015 ERROR: XML Exception in OOXMLAdapter.parseRels. 
Input file is
  out of spec.: org.xmlpull.v1.XmlPullParserException: caused by: 
org.xmlpull.v1.XmlPul
lParserException: resource not found: 
/META-INF/services/org.xmlpull.v1.XmlPullParserF
actory make sure that parser implementing XmlPull API is available

and applying OpenXLS' <WorkBookHandle>.getStats method gives (from 
Octave prompt):

debug> wb.getStats
ans = -------------------------------------------
ExtenXLS Version:     11.0-${timestamp}-${scmVersi
Excel Version:        518
-------------------------------------------------
Statistics for: 
C:\Home\Philip\LOCALS~1\Temp\extentech\WBP2809737568889784884.tmp
Number of Worksheets: 0
Number of Cells:      0
Number of Formulas:   0
Number of Charts:     0
Number of Fonts:      4
Number of Formats:    8
Number of Xfs:        1
-------------------------------------------------

Clearly 'Number of Worksheets' and 'Number of Cells' are wrong, but that 
can be due to the previously occurring parse error.

Offending .xlsx file attached.

Best wishes for 2014!

Philip

Re: [openxls-develop] OpenXLS cannot read its own empty OOXML file

[Philip N. <prn...@us...>]

Philip Nienhuis wrote:
> Subject says all.
>
> Steps to reproduce:
>
> - Create an OOXML along the lines of (Octave/Matlab script language):
> wb = javaObject ("com.extentech.ExtenXLS.WorkBookHandle", true);
>
> - Remove sheets #1 and #2 (keep Sheet #0). Note: all these sheets are
> empty.
> Optionally rename Sheet1 to "EmptySheet"
>
> - Write file to disk (using Octave/Matlab):
>    xlsout = javaObject ("java.io.FileOutputStream", "io-test.xlsx");
>    xls.workbook.write (xlsout);
>    xlsout.close ();
>    xls.workbook.close ();
>
> Excel 2013 and LibreOffice read this file just fine.
> Apache POI apparently parses it OK but spots an empty cell B4.
> Inspecting it using 7-zip yields nothing special (admittedly I'm no
> OOXML guru). However there is indeed a cell B4 in the only worksheet:
>
> (Expanded sheet 1 "EmptySheet":)
>
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <worksheet
> xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
> xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><dimension
> ref="A1:B5"/>
>    <sheetViews>
>      <sheetView tabSelected="1" workbookViewId="0"></sheetView>
>    </sheetViews>
>    <sheetFormatPr defaultColWidth="8.0" defaultRowHeight="12.75"/>
>    <sheetData>
>      <row r="4">
>        <c r="B4" s="15"></c>
>      </row>
>    </sheetData>
> </worksheet>

FTR, I see that cell B4 is actually valid as the "empty" file was made 
along the lines of this Octave/Matlab call:

xlswrite ('io_test.xls', {''}, 'EmptySheet', 'b4')

where {''} is an empty string.

Philip