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

Re^3: Error reading Excel Cell Value

by sandeep78 (Novice)
on Oct 03, 2008 at 22:17 UTC ( [id://715291]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Error reading Excel Cell Value
in thread Error reading Excel Cell Value

I tried this option. I am doing a sanity check on my excel in the actual program. The script pasted is just a part of it. Interesting thing here is...when I copied data from a cell that is returning me right results to that particular cell. And ran the script. It is giving good result. For ex: Cell (12,11) has 1.29 and the script returns 1.29. So, I copied the 1.29 into my 33,13 cell which is causing the error. And ran the script...it returned 1.29. I am not able to understand the issue here. Please advise.

Replies are listed 'Best First'.
Re^4: Error reading Excel Cell Value
by ggvaidya (Pilgrim) on Oct 06, 2008 at 04:02 UTC
    Was cell (12, 11) also formatted to "Accounting"? Maybe the dump is Excel's internal representation of an "accounting" field. Also, it might be helpful if you tell us exactly what value '4.10' is being translated to.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (8)
As of 2024-06-14 19:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.