.xlsx files exported by JasperSoft not recognised by various tools including Vibe

  • 7014815
  • 28-Mar-2014
  • 28-Mar-2014

Environment

Novell ZENworks Configuration Management 11.3 Reporting Server
JasperSoft
ZRS 5

Situation

  • Vibe unable to read .xlsx files exported from ZCM ZRS - Error: stellent converter timeout
  • .xlsx files exported from ZCM ZRS unreadable/corrupt/unrecognized by various utilities (see Additional Information, below)

Resolution

Workarounds
  • Export the file in some other format such as .csv or .xls
  • Open the file in Excel and resave

Status

Reported to Engineering

Additional Information

Although both Excel and Libre/OpenOffice do open them, Vibe would not process .xlsx files exported from JasperSoft (JS).

Investigation shows that the file format created by JS is also unreadable by other utilities such as

 - The Linux file command
 - ssconvert (from gnumeric package)
 - filetype-identifierhttp://code.google.com/p/filetype-identifier (for example)

Hence, if these tools do not recognise the file then Vibe cannot reasonably be expected to.

If a file is opened in Excel and immediately re-saved then it is recognised by all of the above utilities.

Examples of exported file (failing):

# file Test_Report.xlsx
Test_Report.xlsx: Zip archive data, at least v2.0 to extract Zip archive data, at least v2.0 to extract

# ssconvert Test_Report.xlsx output.xls
Using exporter Gnumeric_Excel:excel_biff8
Unknown theme color 1
Invalid color '333333' for attribute rgb
Invalid color '666666' for attribute rgb
Invalid color '666666' for attribute rgb
Invalid color 'FFFFFF' for attribute rgb
Invalid color 'FFFFFF' for attribute rgb
Invalid color 'FFFFFF' for attribute rgb
Invalid color 'D5DEE8' for attribute rgb
Invalid color 'D5DEE8' for attribute rgb
Invalid color 'E3E9EF' for attribute rgb
Invalid color 'E3E9EF' for attribute rgb
Invalid color 'FFFFFF' for attribute rgb
Invalid color 'FFFFFF' for attribute rgb
Undefined style record '0'
Undefined style record '1'
Undefined style record '2'
Undefined style record '3'
Undefined style record '4'
Undefined style record '5'
Undefined style record '6'
Undefined style record '7'
Undefined style record '8'
Unexpected element 'is' in state :
        worksheet -> sheetData -> row -> c
[snip 100s more]


Examples of exported file opened in Excel and resaved (working):

# file Test_Report_resaved.xlsx
Test_Report_resaved.xlsx: Microsoft Excel 2007+

# ssconvert Test_Report_resaved.xlsx output.xls
Using exporter Gnumeric_Excel:excel_biff8