I have what might be an advanced problem I need to solve. To you maybe it's not advanced, to me, it is : ).
By way of example, here's what I'm after. On popular blogs, you'll often see a blog article and on the left side of the article will be the Social share icons/chicklets (such as an icon to share the article on Twitter, one to share on Facebook etc). Those share icons normally also show the number of times this article has been shared on that social network.
I want to have an xls file with 5 columns that will load the RSS feed of a particular blog site, plus the social share count, and come out with the following columns:
Column 1: Name of the blog
Column 2: Title of the blog article
Column 3: Date of the blog article
Column 4: URL to the blog article
Column 5: Number of Twitter shares that that article has had
It's Column #5 that is the tough one.
I'm sure someone could easily whip up an xls with columns 1-4 for me, but does someone have an xls file that they can share with me that can pull in the number of Twitter shares as well?
Image of the Twitter shares data I'm talking about:
twittershares.jpg
Image of what the final xls file would look like:
xls.png
(Note: I have Excel 2003 now, but can upgrade to 2007 if necessary)
Bookmarks