perl to generate an excel file? 2

[PepperPepsi]

Hi,

anyone know how to use perl to generate an excel file?

thanks, Chiu Chan
WebMaster & Software Engineer
emagine solutions, inc

http://www.emagine-solutions.com

cchan@emagine-solutions.com

 

[tsdragon]

Check CPAN

http://www.cpan.org

and see if they have an excel module.
Tracy Dryden
tracy@bydisn.com

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.

 

[sophisticate]

Best way to do this is to create a comma delimited file (comma delimitation seperates columns, newlines seperate rows)... Then use Excel's import function to convert the data.

Exercise the join and/or format and write commands as well as the concatenation operator (.) to put this together.

Best of luck,

brendanc@icehouse.net

 

[PepperPepsi]

Hi,

thanks for the reply,

i found something very similar to what i want, unfortunately, it is for win32.

http://blazonry.com/perl/xl_oleauto.html

http://www.jndata.dk/faq/perl/perlwin32faq12.htm#changed_by_4xx

i'm looking for something work in Unix..

thanks Chiu Chan
WebMaster & Software Engineer
emagine solutions, inc

http://www.emagine-solutions.com

cchan@emagine-solutions.com

 

[raider2001]

What about Spreadsheet::WriteExcel? It claims to work on Unix systems.

http://search.cpan.org/search?mode=module&query=Spreadsheet::WriteExcel

 

[PepperPepsi]

thanks raider2001, it seems the right thing i'm looking for, i wll check that later..

thanks~~~ Chiu Chan
WebMaster & Software Engineer
emagine solutions, inc

http://www.emagine-solutions.com

cchan@emagine-solutions.com

 

[tsdragon]

I knew there had to be one on CPAN! Every time I need some code for some wierd purpose, I know I can probably find it on CPAN!
Tracy Dryden
tracy@bydisn.com

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.