Help for this page

Select Code to Download


  1. or download this
    excelPerl.pl -ane "$C->[2]->{FormulaLocal} .= '+99'" -f test.xls
    
  2. or download this
    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
    
  3. or download this
    a,b,a+b
    1,4,=A2+B2
    ...
    3,2,=A4+B4
    4,1,=A5+B5
    5,5,=A6+B6