all!
I am starting a fantasy football league with some friends, and we will be operating it in the offseason (dynasty/keeper). I am building a Google Spreadsheet to help synchronize the activity on the Yahoo page with a Google Spreadsheet.
Mostly I have been using IMPORTHTML to bring tables of information from my league into the Google Spreadsheet, and then processing the data there. I recently discovered the IMPORTXML function and I have been trying to figure out how I can use it to grab data from various pages of our league.
Here is an example of one of our team pages: http://ift.tt/1sdkoNX
I watched a few videos and read a few blogs that basically said you put the copy the XPATH information into the IMPORTXML...but that keeps giving me an error.
For example, I tried =IMPORTXML("http://ift.tt/1sdkoNX", //*[@id="yui_3_10_3_1_1407351196962_1052"]) to try and grab the position/name/stats for Matt Stafford.
I have tried all kinds of tweaks suggested on this forum and others, including changing " to ', and putting [@ in the blank after div...
...but nothing seems to be working. Any helpful hints? I have never tried to do any kind of coding before, but it has been thrilling to build my spreadsheet in the last few weeks and learn. I would love it if someone could point me in the right direction. Thanks!
Dan
No comments:
Post a Comment