CSV to Excel

[raj8]

Hi Monks,

After receiving some data within a CSV file, how would I take CSV file with a few thousand lines of unique data and create an Excel file with the 31 fields such as F1, F2 etc. As always, any insight would be appreciated.

__DATA__

3,8,ADSM,08/03/2000,16:26:37,node1,,AIX,1,Tcp/Ip,0,254,1713,0,0,47,147
+6,0,0,3316,960,27,5,1,4,0,0,0,0,7,2

[toolic]

Maybe: CSV to Excel Converter

I found this using Super search where title contains all of "csv", "excel"

[Generoso]

Have you tried to open it directly on excel? Excel can open CVS files directly and save it as excel.

[raj8]

I would rather automate the process.

[Herkum]

I find it ironic that you say you want to automate the process but you haven't presented any code saying what you have tried. Perhaps you should make an effort to write something and I am sure someone would be willing to help from there.

[trwww]

You are asking how to convert a csv file to an excel file. The point that is being made is that a csv file is an excel file. MS Excel opens CSV files with no intermediate processing needed.

[Tux]

Text::CSV_XS comes with csv2xls in the examples folder. I use that in production code for customers on an almost daily basis.

Others suggest to open CSV with Excel directly. This might work, but more likely is very error-prone. Excel converts many "things" is the imported data based on various outside settings, like locale and local list-separator characters. That means that your numbers might turn into dates, and your (ISO)dates YYYYMMDD suddenly become dates in braindead US format (MM/DD/YY), even if the CSV data was quoted!

For that last problem, csv2xls has the -D option, in which you can specify what columns represent dates and a -d option to specify the required date format.

[bluescreen]

Hi, I'd use Spreadsheet::WriteExcel

I've used that and it rocks. The API can be overwhelming at first, but read the synopsis and you'll get it.