Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^3: CSV to Excel

by trwww (Priest)
on Jun 09, 2010 at 01:45 UTC ( #843783=note: print w/replies, xml ) Need Help??


in reply to Re^2: CSV to Excel
in thread CSV to Excel

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.

Replies are listed 'Best First'.
Re^4: CSV to Excel
by aquarium (Curate) on Jun 09, 2010 at 05:47 UTC
    Like has been said you can open csv native in excel, or if you actually want to do anything else with the data, better off not converting into .xls...a quote comes to mind: "this is a dead end". Keeping the data in text or at least database format allows for transformations/munging. Excel can provide..uhm..pie chart. Avoid Excel (especially) for any number work where dollar amounts (or jobs) are at stake, as it's the only (supposedly serious) spreadsheet that uses floating point math for calculations.
    the hardest line to type correctly is: stty erase ^H

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://843783]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2019-03-26 01:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How do you Carpe diem?





    Results (122 votes). Check out past polls.

    Notices?