Tilted Forum Project Discussion Community

Tilted Forum Project Discussion Community (https://thetfp.com/tfp/)
-   Tilted Technology (https://thetfp.com/tfp/tilted-technology/)
-   -   Importing data from an ASP page to an excel spreadsheet. (https://thetfp.com/tfp/tilted-technology/73898-importing-data-asp-page-excel-spreadsheet.html)

John Henry 10-26-2004 07:53 AM

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?

blandarfleck 10-28-2004 02:29 AM

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 02:12 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2026, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2
© 2002-2012 Tilted Forum Project


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57