How to create a working XLS2CSVmra

[pe...@vedaadvantage.com]

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




--
This message was sent on behalf of peter.connell@vedaadvantage.com at openSubscriber.com
http://www.opensubscriber.com/messages/user@poi.apache.org/topic.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: How to create a working XLS2CSVmra

[Chris Lott <ma...@invest-faq.com>]

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...

peter.connell@vedaadvantage.com 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org