Re: CSV to XLS(x)

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Gad,

I like SQL2JXL by Giuseppe Costagliola, who also wrote SQL2XLS, SQL2XML 
and SQL2CSV. See

http://www.mcpressonline.com/tips-techniques/microsoft/techtip-excel-flies-higher-with-jexcelapi.html

and

http://www.mcpressonline.com/tips-techniques/sql/techtip-sql2csv-and-sql2xml.html

The jExcel api is a lot faster than the POI HSSF stuff.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx> /


On 10/14/2012 9:20 AM, Gad Miron wrote:
> Hello everyone
>
> We use extensively a home grown small utility (CPY2CSVF) that receives a
> file name,
> extracts it's columns headers and data and creates a .csv file in
> a specified directory,
> net or IFS.
> (it's done simply by calling CPYTOIMPF with some prior processing)
> the utility then either calls MS Excel to open the csv file on the user's
> PC using simple
> STRPCO or e-mails the .csv file using SNDDST. (in case of batch)
>
> Does any of you guys know of a tool (preferably free) to convert the A/M
> .csv
> file to Excel proper? and a AS400 native (PASE) tool at that?
> I would very much like to extend this tool and create xls(x) files.
>
> I know it's a tall order but it just may be my lucky day...
>
> Thanks
> Gad
>
> P.S
> a. POI is not my cup of tea.
> b. I found some command line Windows converters, wonder if there are
> linux/aix ones?