Seeking Perl 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.

Comment on Seeking Perl help

Replies are listed 'Best First'.
Re: Seeking Perl help by davido (Cardinal) 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. Dave	[reply]
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. CountZero 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	[reply]
Re: Seeking Perl help by kcott (Archbishop) 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	[reply] [d/l]