The excel file is generated automatically and come from a source. I
do not want
to modify it or manually open it.
Of course not. We all must automate, that's why we use POI.
The data I need exists in the Pivot Tables and that can change.
I want to do the equivalent of opening an test.xlsx file in Excel
2007 and
Saving AS a test.xml file but programatically so I can use the data
on the
server for further use.
Understood.
Let me know if that can be done using the Apache POI API.
To do so would require modifying the code that Roberto donated to
perform Excel's default behavior.
If you would like to try that would be great, otherwise you can file a
bugzilla report and include an example xlsx and xml files and code
that you have tried. That way this issue won't get lost, and has a
chance of being eventually resolved.
Now if you know where in the xlsx the cells are then I'm sure you can
extract those and then output in xml from your program. Not a general
solution, and not nearly as elegant, but you could get that done with
POI as it is now.
These links to examples might be a starting point for you:
http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api
These examples are HSSF, but SS combined versions can be done.
http://poi.apache.org/spreadsheet/converting.html
http://poi.apache.org/spreadsheet/quick-guide.html#Iterator
http://poi.apache.org/spreadsheet/quick-guide.html#CellContents
http://poi.apache.org/spreadsheet/quick-guide.html#TextExtraction
Thanks for all the help.
You're welcome
Regards,
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
