Excel document created using HSSF POI API not opening in Windows7 but opening in Win XP

[NarayanaRao Konakalla]

Hi

I have installed the same version of "MS Office 2007" in Windows 7 and Windows XP operating systems.
I have a Excel file generated by a non-microsoft program (a java program) with me.

HSSF POI jar version is 1.5.1 (name of jar is jakarta-poi-1.5.1-final-20020615.jar)

I tried opening the file in windows xp, using Excel 2007.. The file opened and I was able to see all the data.
But when I copied the same excel file to Windows7 OS, and tried to open with the same installation of Office 2007, I get the an alert box with following message.

"Excel found unreadable content in "xyz.xls".Do you want to recover the contents of the workbook.If you trust the source of this workbook, click Yes"..

Once I click yes, the file opens displaying a message as follows.

"Excel recovered your formulas and cell values, but some data may have been lost"...

Some data is lost when I open the same file in Windows 7 OS, Excel 2007...

Any clues about why I am losing the data in Windows 7 but the file opens correctly in WinXP..


Is there any problem with the way I created the workbook..? Please help..

[Vidyanand Sharma]

Hi Narayana,

Were you able to resolve this issue with HSSF POI jar version?
I am also facing the same problem and do not seem to find any workaround.

Please Let me know what did you do to overcome this.

Cheers,
Vidyanand

[Ulf Dittmer]

The first step should be to upgrade to a recent POI version; at this point, you shouldn't be using anything older than POI 3.5.

[Vidyanand Sharma]

I did that to 3.6 but got some exception. Did not work so right now I am trying to test by recoding for XSSF format.
If you need I'll do that again and post the error that I got.

[Ram Panuganti]

Hi Vidyanand,

I am also facing the same issue, did you find any luck with this issue?

[Martijn Verburg]

Hi Ram Panuganti and welcome to Javaranch! Perhaps you can post your exact problem details?

[Ram Panuganti]

We have an application using Java 1.4.2 and POI 1.5. When we create MS-Excel document using POI 1.5 we are able to open the file in Windows XP and MS-Office 2007 environment but it is showing error in Windows 7 and MS-Office 2007.

Option I am considering:
Migrate from POI 1.5 to POI 3.6 :
-------------------------------------
- In this case I need to migrate Java 1.4.2 to 1.5 or higher
- is there a POI version which works fine for my requirement without channging the Java version?

- As MS-Office version is same, why is it giving problem for Windows 7 but not in XP?

Please let me know if you guys have any solution.

[Martijn Verburg]

Hi Ram,

I'm not a POI user but my understanding is that yes you need to upgrade to the latest version to support the recent versions of Office, I believe that also means an upgrade of Java. I don't think there is another version of POI that will do the trick and Windows 7 Office uses different internal APIs than Windows XP Office.