wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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

POI and issues reading xlsx files

Alex Philippi

Joined: Oct 05, 2007
Posts: 13
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.


I decided to use the POI mailing list for this question -> therefore resolved here
It is sorta covered in the JavaRanch Style Guide.
subject: POI and issues reading xlsx files
Similar Threads
Read the particular row/record from Excel and output as HTML table
struts dojo + displaytags clashing
POI apache Reading Excel (strange case)
Anyone know how to get out of Debug mode in Eclipse?
Creating Workbook with .xlsx file