Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Spreadsheet::WriteExcel formulas in multi-row output

by duckyd (Hermit)
on Dec 06, 2008 at 23:01 UTC ( [id://728610]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    $worksheet->write_formula($row+2, 12, '=1-(K.($row+2)/J.($row+2))',$al
    +ignPerc);
    
  2. or download this
    $worksheet->write_formula($row+2, 12, '=1-(K'.($row+2).'/J'.($row+2).'
    +)',$alignPerc);
    
  3. or download this
    my $row_two_right = $row + 2;
    $worksheet->write_formula($row_two_right, 12, "=1-(K$row_two_right/J$r
    +ow_two_right)",$alignPerc);
    

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (5)
As of 2024-04-23 19:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found