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..
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?
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.