There's more than one way to do things | |
PerlMonks |
Combining Excel Parser with Google Scholar Scraperby ochez (Initiate) |
on Apr 14, 2009 at 14:57 UTC ( [id://757408]=perlquestion: print w/replies, xml ) | Need Help?? |
ochez has asked for the wisdom of the Perl Monks concerning the following question:
Hello,
For a task at work, I am trying to write a program that 1.) parses a list of paper titles from an excel spreadsheet, 2.) scrapes google scholar to get/return the "cited by:" numbers for each title, and 3.) puts these numbers in the spreadsheet column next to the titles. Basically I am trying to combine a simple spreadsheet parser with a nested for loop that I wrote with fetch.pl found at this site: http://davide.eynard.it/cgi-bin/perlcode.pl?file=scholar.pl It all seems simple enough, but I just can't get them to work together. At this point I'm just trying to have the fetch.pl program return the "cited by:" numbers, but I also found a script that would probably benefit more in my case: Spreadsheet::ParseExcel::SaveParser If anyone could help me out real quick, I'd be very grateful. I feel like an experienced programmer could do this in five minutes if they wanted. My Excel Parser looks like this:
The spreadsheet just has titles of papers in the first column...I'd like to eventually have the program write in "cited by" results in the column next to it. My apologies for the bad formatting, I'm a little rusty with my HTML
Back to
Seekers of Perl Wisdom
|
|