in reply to Exporting .csv file to EXCEL


Excel can read and convert CSV automatically. In fact double-clicking on a .csv file in Windows will generally open it in Excel.

If you wish to convert the CSV file to an Excel format you can use the Spreadsheet::WriteExcel module. The distro comes with a program called csv2xls.pl which will do the conversion for you.

Alternatively you could use the Win32::OLE module and office automation. This requires a Windows platform and an installed copy of Excel. This is the most powerful and complete method for interfacing with Excel. See here and here for further information.

--
John.