• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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..
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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.


 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Vidyanand,

I am also facing the same issue, did you find any luck with this issue?
 
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Ram Panuganti and welcome to Javaranch! Perhaps you can post your exact problem details?
 
Ram Panuganti
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic