sheet not recognized in an excel file (v. 7.1)

[Krantz]

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

[sorin_ristache]

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

[sorin_ristache]

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