Novell Home

My Favorites

Close

Please to see your favorites.

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

This document (7014815) is provided subject to the disclaimer at the end of this document.

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

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7014815
  • Creation Date:28-MAR-14
  • Modified Date:28-MAR-14
    • NovellZENworks Configuration Management

Did this document solve your problem? Provide Feedback