Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re: Reading wrong value from excel sheet

by runrig (Abbot)
on May 20, 2013 at 17:35 UTC ( #1034379=note: print w/replies, xml ) Need Help??

in reply to Reading wrong value from excel sheet

You don't say what you use to get the value from the cell. Is it $cell->value() or $cell->unformatted()? Try both ('value()' is the formatted value and might be rounded). If neither help, you'll have to round it yourself. Note that the value you see in Excel is probably rounded also.

Replies are listed 'Best First'.
Re^2: Reading wrong value from excel sheet
by sandeep_car (Novice) on May 20, 2013 at 17:45 UTC

    Hi runrig,

    I am printing $cell from below

     my $cell = $sheet -> {Cells} [$row] [$col];

    this itself give me incorrect result.

    I have used

    $cell_value=sprintf("%s", $cell -> {Val});

    to get the values


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1034379]
[Corion]: marto: Redoing something on new infrastructure sounds fun. At least you can reuse your previous experience :)
[marto]: I'm looking forwads to it. The video sources are dying, and they don't have the hardware to play them back (old tape formats, not just VHS + Laserdisc etc)
[marto]: I'll be interested to see what difference in terms of file size/quality the new codecs make. I enjoy working on things like this, so that's a bonus
[Corion]: Ah, cool! So it's not an inhouse youtube but for a wider consumption
[marto]: last time it was IE6 clients, now they're on 11, so more scope there also, in terms of UI and playback
[marto]: in house as in Company network, not internet connected (power stations and the corporate HQs)

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (8)
As of 2017-07-28 09:17 GMT
Find Nodes?
    Voting Booth?
    I came, I saw, I ...

    Results (425 votes). Check out past polls.