intoxicated_curveball
asked on
Excel data from web not able to select JSON table data
Excel has a nice data connection from web feature. It allows you to select a table from the URL that will load the data into Excel automatically. The problem I'm having is the following URL http://mlb.mlb.com/mlb/fantasy/injuries/ the data must be loading via JSON (or similar) as Excel is not able to view the table in order to select it with the From Web data connection feature.
Any ideas?
Any ideas?
ASKER
You're probably right, but of course just as you can copy and paste the data I am looking for a way to extra it into my Excel sheet.
Let's go back to this. If you're going to do this with automation, you need something that is susceptible to automation. Does the MLB site have an API that provides a formal interface to retrieve the data? If so, we might be able to help you use that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please be aware of this:
http://gdx.mlb.com/components/copyright.txt
http://gdx.mlb.com/components/copyright.txt
The accounts, descriptions, data and presentation in the referring page (the "Materials") are proprietary content of MLB Advanced Media, L.P ("MLBAM").
Only individual, non-commercial, non-bulk use of the Materials is permitted and any other use of the Materials is prohibited without prior written authorization from MLBAM.
Authorized users of the Materials are prohibited from using the Materials in any commercial manner other than as expressly authorized by MLBAM.
ASKER
I found a workable solution on my own.
Does the MLB site have an API that provides a formal interface to retrieve the data? If so, we might be able to help you use that.