This is a long shot I'm sure but i'm writing a query for a website that places the table content via javascript. so if i go the page the data isnt there until you fill out the form.
Anyway. I got the url that will work with the parameters i need but excel will not import the javascript table. even though when i past the created URL in the browser it pulls it up fine.
The project:
I have a list of cities with their latitudes and longitudes. I am using these as parameters to search the website:
for example:
<tbody>
</tbody>
I am using the following URL for the query:
This works when i sent the proper parameters and post it in the browser but when i use it in a query in excel it wont import the javascript created data.
Is there a way to tell excel to import the javascript created table as well?
Anyway. I got the url that will work with the parameters i need but excel will not import the javascript table. even though when i past the created URL in the browser it pulls it up fine.
The project:
I have a list of cities with their latitudes and longitudes. I am using these as parameters to search the website:
Code:
[URL]http://windspeed.atcouncil.org/[/URL]
City, State | Zip | Latitude | Longitude |
Abingdon, MD | 21010 | 39.4622357 | -76.2772223 |
<tbody>
</tbody>
I am using the following URL for the query:
Code:
http://windspeed.atcouncil.org/domains/atcwindspeed/process/index.php?option=com_content&view=article&id=10&dec=1&latt=[B][][/B]&longt=[B][][/B]&risk_category_i=rc1&risk_category_ii=rc2&risk_category_iii=rc3&mir10&mri25&mri50&mri100&asce705&asce793&zoom=4&maptype=none
This works when i sent the proper parameters and post it in the browser but when i use it in a query in excel it wont import the javascript created data.
Is there a way to tell excel to import the javascript created table as well?
Last edited: