Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Seeking Perl help

by not_monk_yet (Initiate)
on Sep 16, 2012 at 06:21 UTC ( #993894=perlquestion: print w/replies, xml ) Need Help??
not_monk_yet has asked for the wisdom of the Perl Monks concerning the following question:

Hey, a newbie to Perl here (even to programming to certain extent). My current project is to extract certain cell values from an excel file and based on these values query using WWW::Mechanise. Then I need to follow some links and save the pdfs at the end of those links. Right now I am stuck at the 1st stage (getting values out of excel files). I have tried spreadsheet::parseexcel, but I am perhaps not getting something right. I hope to find some help here.

Replies are listed 'Best First'.
Re: Seeking Perl help
by davido (Archbishop) on Sep 16, 2012 at 06:32 UTC

    Post the portion of your code using Spreadsheet::ParseExcel that seems to be giving you difficulty so that we can help you with it.


Re: Seeking Perl help
by CountZero (Bishop) on Sep 16, 2012 at 07:12 UTC
    Have a look at Spreadsheet::ParseExcel::Simple. For most of my applications I only need the more limited but easier functionality of this module.


    A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

    My blog: Imperial Deltronics
Re: Seeking Perl help
by kcott (Chancellor) on Sep 16, 2012 at 13:23 UTC

    G'day not_monk_yet,

    Welcome to the monastery.

    If you're using the newer *.xlsx Excel format, Spreadsheet::XLSX would probably be a better choice.

    As already requested by davido, please post some code so we can help you further. These guidelines should help you in deciding what information will get you a better answer: How do I post a question effectively?.

    -- Ken

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://993894]
Approved by davido
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (5)
As of 2018-02-21 06:24 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (275 votes). Check out past polls.