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
Hi,

Attached y'll find a modified version of the XLS2CSV example written by Nick
Burch.
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
basis.

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

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

Cheers,

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)

Mime
View raw message