Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: CSV to Excel (where I keep the excel formula)

by strat (Canon)
on Sep 02, 2007 at 10:08 UTC ( #636591=note: print w/ replies, xml ) Need Help??


in reply to CSV to Excel (where I keep the excel formula)

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):

excelPerl.pl -ane "$C->[2]->{FormulaLocal} .= '+99'" -f test.xls

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):

perl excelPerl.pl -begin "use Text::CSV_XS; $csv = Text::CSV_XS->new( +{ binary => 1 } )" -ane "$csv->combine( map { $_->{FormulaLocal} } @C +); print $csv->string, $/" -f test.xls

which produces something like

a,b,a+b 1,4,=A2+B2 2,5,=A3+B3 3,2,=A4+B4 4,1,=A5+B5 5,5,=A6+B6

Best regards,
perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8.8.8.32.11.32"


Comment on Re: CSV to Excel (where I keep the excel formula)
Select or Download Code
Replies are listed 'Best First'.
Re^2: CSV to Excel (where I keep the excel formula)
by rogueFalcon (Beadle) on Sep 11, 2007 at 01:39 UTC
    I never said thanks but seriously... thank you. That made my life so much easier :-) I really appreciate it.

    -- rogueFalcon
    Why do you people insist on doing things sdrawkcab?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (7)
As of 2015-07-08 02:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls