No such thing as a small change | |
PerlMonks |
Re: CSV to Excel (where I keep the excel formula)by strat (Canon) |
on Sep 02, 2007 at 10:08 UTC ( [id://636591]=note: print w/replies, xml ) | Need Help?? |
if you want to do it with a one-liner (or look at the code to do it in a program), get excelPerl from ExcelPerl 0.12 released and try something like Update: Sorry, I misread you. The code for ExcelPerl would be (if your col is number 2):
If you have got a headline in the first row, just skip it with the additional parameter -h=1 Code to convert excel to csv with formulas (doesn't match the question):
which produces something like
Best regards,
In Section
Seekers of Perl Wisdom
|
|