I need an OpenOffice Calc formula to fetch the Google PageRank for the top 5 listed results of a giv

Posted by Jeff on Stack Overflow See other posts from Stack Overflow or by Jeff
Published on 2010-03-28T15:44:12Z Indexed on 2010/03/28 15:53 UTC
Read the original article Hit count: 165

Filed under:

openoffice-calc

|

google

|

pagerank

I have a list of search terms:

        A                 |    B    |    C    |    D    |    E   |
   _______________________________________________________________
1 |  SEARCH TERM             PR #1     PR #2     PR #3     PR #4
2 |  lcd screens
3 |  mud
4 |  eurpoean sport cars
5 |  perfume

How can the search term in my spreadsheet fetch the Google PageRank of the top five domain/page results for each term?

I've seen similar "pagerank fetching" questions here, but those are based on known domains. In my scenario, the domain is unknown until results are fetched based on a search term.

© Stack Overflow or respective owner

Related posts about openoffice-calc

Ubuntu: Convert OpenOffice Calc to Excel workbook using CLI

as seen on Super User - Search for 'Super User'
I need to create an automated report in a spreadsheet format. Unfortunately, There seems to be an easy way to create these reports using OpenOffice Calc, but upper managements wants them in MS Excel format. As these reports are to be created and emailed automatically, is there a nice, command-line… >>> More
OpenOffice Calc: inserting image into a cell

as seen on Super User - Search for 'Super User'
I'm an Open Office Calc user. Is there a way to insert an image inside a cell? When I choose Insert - Picture it inserts it so it's floating over the cells, and that's now what I want. I want to be able to insert the image into cell A1, for instance. >>> More
Read data from separate CSV file in OpenOffice Calc

as seen on Super User - Search for 'Super User'
Hi, I have a very large CSV file (many thousands of rows) that I want to work with. Due to the size of the file, I don't want to import it into openoffice. Rather, I want to create a spreadsheet that contains formulas & graphs that read from this (or any other) CSV file I point it it. Ideally… >>> More
How to apply an Openoffice Calc template?

as seen on Super User - Search for 'Super User'
How I can easily apply a template to an existing OO Calc file? AFAIK it is possible only to make a new file from a template, copy the sheets in it, and save/overwrite the old file. But I don't like this way; there is a easier/better way to do this? Like a macro, or something like that. I just need… >>> More
Using a Script to automate data entry to an OpenOffice Calc Spreadsheet

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to be able to automate creating spreadsheets and adding data to an OpenOffice spreadsheet using a script (any scripting language is acceptable - PowerShell, Python, or even JavaScript). What is a suitable library or tutorial? >>> More

Related posts about google

Removing malware of a particular kind

as seen on Super User - Search for 'Super User'
I need to remove some malware from my computer. It is a trojan, and very annoying. It blocks access to Google and search sites. The trojan, with its name spelled out on each line cause it seems to block sites when i reference it in a url, is a r t (some text to mess it up) e m (more text i s First… >>> More
Trouble installing Matlab

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
So whenever I try to install Matlab, the first image appears, but then goes away and that's the end of it. Here's what I'm doing- user@host$> cd ~/mathworks_downloads user@host$> unzip matlab_R2012a_student_glnx86_installer.zip user@host$> ./install The Matlab logo and image pop up here… >>> More
Google chrome is always searching in local google domain instead of Google.com

as seen on Super User - Search for 'Super User'
I have changed in the searched preferences to google.com but still when I do search from the address bar (instant or non-instant) it will go to google.co.kr. Even though I change "Google.com in English", still same... The only way is to open google.com website first, then do search in it. So the… >>> More
Google I/O 2010: Google TV Keynote - Introducing Google TV

as seen on Google Code - Search for 'Google Code'
Google I/O 2010: Google TV Keynote - Introducing Google TV Due to licensing and permissions issues, we are unable to show the full Google TV demonstration from the Day 2 keynote at Google I/O. Until we are able to get these permissions, please check out these clips. For Google I/O session videos… >>> More
Google I/O 2010: Google TV Keynote - Android Apps On Google TV

as seen on Google Code - Search for 'Google Code'
Google I/O 2010: Google TV Keynote - Android Apps On Google TV Due to licensing and permissions issues, we are unable to show the full Google TV demonstration from the Day 2 keynote at Google I/O. Until we are able to get these permissions, please check out these clips. For Google I/O session videos… >>> More