Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Can Spreadsheet::ParseExcel extract formulas?

by dasgar (Priest)
on Oct 07, 2010 at 21:11 UTC ( [id://864092]=note: print w/replies, xml ) Need Help??


in reply to Can Spreadsheet::ParseExcel extract formulas?

If you're on a Windows box with Excel installed, you do have another route available to: Win32::OLE. With this module, you can get the following items from a cell: value, formatted value, and formula. However, if you're on a *nix or Mac, I'm not sure what to suggest as an alternative.

You'll definitely have a steeper learning with Win32::OLE, but it's advantage is that you can do more in an Excel file than you can with Spreadsheet::ParseExcel. However, Spreadsheet::ParseExcel has the advantage when you don't have Excel for Perl to manipulate through Win32::OLE, such as working in a *nix environment. Overall, which one is better depends on the programmer, his/her environment and what he/she needs to do.

  • Comment on Re: Can Spreadsheet::ParseExcel extract formulas?

Replies are listed 'Best First'.
Re^2: Can Spreadsheet::ParseExcel extract formulas?
by petecm99 (Pilgrim) on Oct 08, 2010 at 12:15 UTC
    Much appreciated, I'll dig further...

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (2)
As of 2026-01-14 10:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What's your view on AI coding assistants?





    Results (118 votes). Check out past polls.

    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.