![]() |
Importing data from an ASP page to an excel spreadsheet.
I'm trying to make a spreadsheet to automatically monitor the results of a query on espotting.com. I tried using the "Import Web Data" feature, but where I should get result of a search, I get a "Sorry your search returned no results" message.
I think this is happening because it's an asp page: Presumably, Excel only imports according to the URL you give it, rather than taking the data from the page as I had browsed to it. As such, it wouldn't submit a form with the appropriate search query and the page it actually imported from would be as though no search text had been entered, giving the results described above. Any ideas how I can make it import from the actual search results page? |
I don't know much about excel, but this should be easy to do in most other languages (Java, Perl etc..). Basically, they would just monitor for changes, then output into a CSV format, or if you were using say VB you could likely write to Excel. Using Java, you could use POI (jakarta.apache.org/poi) to write to an excell document too.
|
All times are GMT -8. The time now is 11:52 PM. |
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2
© 2002-2012 Tilted Forum Project