Thanks Karel but Luke and I have been doing a bit of work on this -
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java.
Lately, there is a pluggable version of the same where you simply create a
customised subclass of a handler to convert the Excel in
I know it is to XSL to XML and using perl, but it looks easier as the java
code shown below
http://www.perlmonks.org/?node_id=635459
Luke_Devon wrote:
>
> Hi
>
> I wanted to convert some XLS files into CSV. I found that apache.poi is
> the most perfect tool. Since I'm a beginner , i have
meant This value must be repeat from B17 to
> B25.( This is just like we copy a value along the column for more than one
> row )
>
> Like that , in this worksheet , there will be lot of values to be copied.
> Hence I think we can not do it dynamically and we needed hard code those
or more than one row )
Like that , in this worksheet , there will be lot of values to be copied. Hence
I think we can not do it dynamically and we needed hard code those values in
the code .
Thanks in advance
Luke
____________
From: MSB
To: user@poi.apache.org
Sent: Friday, Apri
all.
Many Thanks
Luke
From: MSB
To: user@poi.apache.org
Sent: Friday, April 23, 2010 3:27:38
Subject: Re: Convert XLS into CSV
Luke
As you have only limited experience with Java, I have uploaded a
distribution that you should be able to
run from the command
ve the problem.but no luck.
>
> Thanks in advance
> Luke
>
>
>
> From: MSB
> To: user@poi.apache.org
> Sent: Tuesday, April 13, 2010 22:04:55
> Subject: Re: Convert XLS into CSV
>
>
> The code I have pasted into this mess
to go through the code , if there is any thing that i can
> modified to solve the problem.but no luck.
>
> Thanks in advance
> Luke
>
>
>
> From: MSB
> To: user@poi.apache.org
> Sent: Tuesday, April 13, 2010 22:04:55
> Subject: Re: Convert
project "Inbox".
I tried to go through the code , if there is any thing that i can modified to
solve the problem.but no luck.
Thanks in advance
Luke
From: MSB
To: user@poi.apache.org
Sent: Tuesday, April 13, 2010 22:04:55
Subject: Re: Convert XLS i
hard coded.
>
> How it would be pointing to a single directory and convert all XLS into
> CSV stored in the folder ?
>
> In the RAW XLS file , there might be some unwanted data to be converted
> into CSV. or some times we need to complete the blank cells in the excel
> sheet.
>
n the excel
> sheet.
>
> How can we do it , before convert into CSV ?
>
> Sorry about all those simple questions.( Since I'm not a programmer)
>
> Thanks in advance
> Luke
>
>
>
>
>
>
> From: MSB
> To:
x27;m not a programmer)
Thanks in advance
Luke
From: MSB
To: user@poi.apache.org
Sent: Friday, April 9, 2010 22:18:43
Subject: Re: Convert XLS into CSV
Hello Luke,
As promised, a bit of code that uses the usermodel to create CSV files. I
have not ha
ations for the EXCEL file ,
> because I just wanted convert entire excel file into CSV.
> Is there any simple java code available for such a basic requirement ?
>
> anyway I'll try to use the code in the link which you have given to me .
>
> Thanks & Regards
>
>
h you have given to me .
>
> Thanks & Regards
>
> Luke.
>
>
>
>
>
> From: MSB
> To: user@poi.apache.org
> Sent: Thursday, April 8, 2010 23:47:07
> Subject: Re: Convert XLS into CSV
>
>
> Hello Luke,
>
> Which version of the Excel file format are you
7
Subject: Re: Convert XLS into CSV
Hello Luke,
Which version of the Excel file format are you targetting, the older binary
or newer xml based version? I ask because Nick wrote and contributed some
code that can be used to convert the older binary files into csv. It uses
the eventmodel and will s
Hello Luke,
Which version of the Excel file format are you targetting, the older binary
or newer xml based version? I ask because Nick wrote and contributed some
code that can be used to convert the older binary files into csv. It uses
the eventmodel and will seem quite complex on first acquainta
15 matches
Mail list logo
