Oxygen XML Forum

Hello,

I encountered a problem when importing an excel file, the sheet name wasn't recognized and I had to add a new sheet in the file (rename it also works) to have it recognized by Oxygen 7.1.

Doing some others imports, I had a java error after renaming the last excel file I imported :

[ AWT-EventQueue-0 ] - org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null
org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null
at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:237)
at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:160)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130)
at ro.sync.V.C.B.G(Unknown Source)
at ro.sync.V.C.B.z(Unknown Source)
at ro.sync.V.A.G(Unknown Source)
at ro.sync.exml.A.F.ô(Unknown Source)
at ro.sync.exml.A.F.access$500(Unknown Source)
at ro.sync.exml.A.F$4.run(Unknown Source)
at ro.sync.ui.E$1.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Close and re-open Oxygen is necessary to import new excel files after this error.

regards,
Krantz

Hello,

We never obtained this error for an Excel sheet imported in <oXygen/>. What is the version number of the MS Excel in which the sheet was created / saved last time ? Please send the sheet to support at oxygenxml dot com in order to reproduce and investigate the error.

Regards,
Sorin

Hello,

Thank you for sending the file. You don't know the Excel version used to save the sheet. If it was created with a version of MS Excel later than Excel 2002 then the file format may not be handled correctly. I loaded the sheet in Excel 2000, saved it in the Excel 2000 format and then I could import it without problems in <oXygen/>.

Regards,
Sorin