Re: Exporting .csv file to EXCEL

Hi.
I'm not sure I understand what you want to do. If you just want to open a CSV file, you can open it using Excel - it's one of Excel's recognised file types.
If you'd like to create a .xls format spreadsheet, you can save the csv file as a .xls file, also from within Excel.

Assuming that you want to do something more than this, I'd use Text::CSV and Spreadsheet::WriteExcel to convert csv file into .xls files. However, I'd only say this would be worth it if you *specifically* want .xls format files, and you have a lot of files to process - otherwise, I'd just use Excel.<br Hope this helps
davis

Comment on Re: Exporting .csv file to EXCEL

Replies are listed 'Best First'.
Re: Re: Exporting .csv file to EXCEL by tomhukins (Curate) on Jan 23, 2002 at 14:39 UTC
Before using the Text::CSV module, take a look at some of the warnings given in the Text::CSV node in Perl Monks. This module has its weaknesses!	[reply]
Re: Re: Exporting .csv file to EXCEL by naive (Novice) on Jan 23, 2002 at 14:30 UTC
HI,thks for all u reply. What i meant was to open the .csv file in excel directly from perl without actually going into excel and open the file manually i.e.( after running the perl program, the excel program will be loaded with the .csv file which is saved in the perl program.) The .csv was saved inside perl because i have used perl to extract some data and i want to load and display this data in EXCEL automatically using perl. Thks once again.	[reply]