Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^5: Get Cell Value while Reading Excel file and not the formula (docs)

by Anonymous Monk
on Apr 14, 2013 at 08:57 UTC ( #1028612=note: print w/ replies, xml ) Need Help??


in reply to Re^4: Get Cell Value while Reading Excel file and not the formula
in thread Get Cell Value while Reading Excel file and not the formula

What I think is happening is the following:

Could be :)

perldoc Spreadsheet::ParseExcel |grep -i formula

This module cannot read the values of formulas from files created with Spreadsheet::WriteExcel unless the user specified the values when creating the file (which is generally not the case). The reason for this is that Spreadsheet::WriteExcel writes the formula but not the formula result since it isn't in a position to calculate arbitrary Excel formulas without access to Excel's formula engine.


Comment on Re^5: Get Cell Value while Reading Excel file and not the formula (docs)
Re^6: Get Cell Value while Reading Excel file and not the formula (docs)
by hdb (Parson) on Apr 14, 2013 at 09:15 UTC

    Thanks for this. I was only scanning the documentation of WriteExcel...

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (11)
As of 2014-07-23 22:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (154 votes), past polls