in reply to Excel-Error reading in formulae value

I'm not sure about the ability of the Perl modules to evaluate formulas in spreadsheets. You need the Excel program to do that.

See sprintf for rounding the number to 1 digit.

Dum Spiro Spero
  • Comment on Re: Excel-Error reading in formulae value

Replies are listed 'Best First'.
Re^2: Excel-Error reading in formulae value
by ravi45722 (Pilgrim) on Aug 19, 2015 at 04:28 UTC

    Updated

    Thanks for reply. In that sheet already D15 contains the formulae. The excel evaluates the formulae & keep the value as 19.95.The default value of that cell is 18.05. When u enter a value which is greater than 95 in C15 it changes the D15 value according to the formulae. I am trying to read that 19.95 through this command.

     $cell_data  = $worksheet->{cell}[$col_num][$row_num]; # same, unformatted

    But its returning 18.05 itself. Not 19.95 which i needed.

[reply]
[d/l]

      How does the formulae =IF(C15>C$13,IF(C15>C$12,C$8,((C15-C$13)*(C$8-C$9)/(C$12-C$13))+C$9),IF(C15<C$14,C$10,C$9-((C$13-C15)*(C$9-C$10)/(C$13-C$14)))) change with B15 when that cell doesn't appear in the formulae ?

      poj
[reply]
[d/l]

In Section Seekers of Perl Wisdom