Excel question - importing data from a web app

[xoggoth]

This looks useful for my purposes so may have a bash. Just need to separate entire file from above into lines. Only prob is not all website source is formatted with line breaks and some tags can have minor content so could be messy.

Bored, if you want to mail content or give me url and tell me which bits you want to extract I can see if works with yours.

[bored]

Update, I decided not to bother and redid the spreadsheet in Mathematica as I would have to do that eventually anyway.

[NickFitz]

This looks useful for my purposes so may have a bash. Just need to separate entire file from above into lines. Only prob is not all website source is formatted with line breaks and some tags can have minor content so could be messy.

Bored, if you want to mail content or give me url and tell me which bits you want to extract I can see if works with yours.

If the page is well-formed XML (which includes XHTML) then the responseXML property of XHR will contain the document parsed into a DOM tree.

If the response is not well-formed, it won't. In that case, you may be better off reverting to the webbrowser control, which will allow you to traverse the HTML DOM via the document property.

[JenniC]

Excel question - importing data from a web app

To import a table from a web page and put it into a spreadsheet file, there is an excellent script posted at http://www.biterscripting.com/SS_WebPageToCSV.html . It imports n'th table from a web page (a web page may have more than one table) and puts it in a .csv file (Comma separated values). The good thing is that it strips off html and other tags, formatting, etc. along the way. Also, it will handle nested tables. So you don't have to do anything extra.

I use it all the time. To use, you can download biterscripting free at http://www.biterscripting.com . Install all the sample scripts including the WebPageToCSV script with the following command.

script "http://www.biterscripting.com/Download/SS_AllSamples.txt"

Should complete pretty fast. Call the WebPageToCSV script as below.

script "SS_WebPageToCSV.txt" page("http://www.xxx.yyy/mmm.nnn") number(5)

The above will import 5th table from page http://www.xxx.yyy/mmm.nnn .

One thing, if you add more functionality to their sample scripts, please post your improved scripts for the rest of us. Thanks in advance.

Jenni