poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fermin Da Costa Gomez <dacostago...@dcgconsultancy.nl>
Subject Modified XSL2CSV example
Date Thu, 21 Jan 2010 20:35:45 GMT

Attached y'll find a modified version of the XLS2CSV example written by Nick
I required a version that was able to take the different sheet into
consideration instead of dumping all data in 1 file.

This version can take a sheetname as a input or a null.
In the latter case the whole sheet will be exported on a file per sheet

I call the class from a Utility class using the following two lines
            XLS2CSV xls2csv=new
XLS2CSV(fileOrDirectoryName.getCanonicalPath(), -1);

I hope it can save someone a few cycles .. ;-)


Fermin DCG

“The reasonable man adapts himself to the world; the unreasonable one
persists in trying to adapt the world to himself. Therefore all progress
depends on the unreasonable man.”
- George Bernard Shaw (1856 - 1950)

View raw message