Peter,
The Xls2CsvMra that is provided in POI examples only converts
old-fashioned "XLS" files. It also suffers from a significant bug that
I am hoping the developers will fix before 3.5 final is released. The
report is here: https://issues.apache.org/bugzilla/show_bug.cgi?id=45672
I posted a version of Xlsx2Csv which converts new-fangled "XLSX"
documents to CSV. It works pretty well, and doesn't suffer from the bug.
Look here: http://chris-lott.org/software/
You say you are "not a java nut". If that means you have never compiled
a java program before than you may wish to start with some tutorials.
If you are working without benefit of any development tools, I recommend
you download and install Eclipse before doing anything else. Getting a
classpath established properly so the java compiler can find all the
necessary dependencies is a basic issue. In this case it should be
relatively straightforward: download POI, put every single Jar you find
there on the path, and go. After it starts working you can pare back
the jars until you have just the required set.
HTH
chris...
[email protected] wrote:
All I want is a class that will convert an xls or xlsx document to a csv file
which I can then easily process. My googling found a copy of xls2csvmra which I
downloaded but can't get compiled but at last I've found a list that might save
my sanity.
I'm not a java nut so is there a clear intruction that a greenhorn can follow to download the correct xls2csvmra source and relevant jar files to get a clean compile.
I've downloaded the lastet POI FINAL build but the compiler can't find the
BoundSheetRecord.orderByBofPosition method which I noticed is not in some code
versions I've seen.
Using the lastest POI beta 3.5 does not seem any better or specifying java 1.5.
Does xls2csvmra convert xlsx docs or is it necessary to rehash the code to use
other POI classes.
The xls or xlsx documents I will be converting will all be straight forward Aged Trial Balances forwarded each month by company accountants.
Help would be much appreciated.
Cheers, Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
