This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes POI and issues reading xlsx files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "POI and issues reading xlsx files" Watch "POI and issues reading xlsx files" New topic
Author

POI and issues reading xlsx files

Alex Philippi
Greenhorn

Joined: Oct 05, 2007
Posts: 13
Hi,
i created a workbook out of a given Excel 2007 file (the file was created with Excel 2010; but this shouldnt matter).

The given file looks like this:


I have to add some informations to this excel file, but if I run this test case, the "Spalte 1 - X" are removed ( I know the asserts are ugly but its only to show my issue):


I got no issues when I run the test with an Excel 2003 file. Does anybody know why these columns were removed?

The written workbook looks like this:


I hope anyone could give me a hint why the written workbook doesnt look like the original excel 2007 document.

Thanks
Alex


I decided to use the POI mailing list for this question -> therefore resolved here
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: POI and issues reading xlsx files