THOMAS,ANN (Non-HP-Singapore,ex1) wrote:
> Hi,
> I am quite new to Perl.
>
> I am running my perl program on a Unix machine..and the project requires
> me to create an Excel file from the contents of a text file. Is this
> possible? Is there any special open command for this? And how do I
> identify the columns in the spreadsheet?
I believe it's possible. Do a search of CPAN or AS site (depending on where
you get your modules from). There should be some Excel modules there.
This link shows several - not sure which are appropriate:
http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?search=excel&new=Search&filetype=+module+name+or+description&join=and&arrange=file&download=auto&stem=no&case=clike&site=ftp.funet.fi&age=
Maybe Spreadsheet::WriteExcel or Text::CSV or even just tab separators
should work.
> This Excel spreadsheet is to be later used in a windows machine; is
> there any option other than importing the text file to Excel?
Excel can read a CSV file. There are CSV modules out there or you can
just write a CSV file yourself if there aren't a lot of commas or apostrophes
in your data. I export my Excel files in tab delimited text files, but I
know you can also import/export comma-delimited files. Each tab or comma
will cause the next column to fill and each newline will take you to the next
row.
--
,-/- __ _ _ $Bill Luebkert ICQ=162126130
(_/ / ) // // DBE Collectibles Mailto:[EMAIL PROTECTED]
/ ) /--< o // // http://dbecoll.tripod.com/ (Free site for Perl)
-/-' /___/_<_</_</_ Castle of Medieval Myth & Magic http://www.todbe.com/
_______________________________________________
Perl-Unix-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
