Le 03/06/11 06:43, nwchrisb a écrit : Hi Chris,
> Just to clarify: I'm not trying to use a relational database. I really just > want to parse a web page which has a lot of data. I need to do it > programmatically because the number of quarters of historical data will vary > by company. That is, I need to call > > http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=0 > http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=1 > http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=2 > > etc. until I get no more data. In addition, I need to easily get the data > onto one sheet. I was hoping to do it without writing the scraper myself, > since opening a calc sheet as a "web query" works quite nicely. I was > unable to figure out if this GUI functionality would allow me to collate > multiple queries, however. Well the GUI allows you to "Insert Data from an External Link" and using the internet link you posted I was able to change the istart_date variable manually to insert the data onto a sheet. I didn't try copying onto the same sheet in different cells though, rather I copied the data into separate sheets. The dialog for inserting the link is a bit quirky though, you have to activate the update checkbox, and then deactivate it for the import wizard to start (and it is a bit slow on my system). Then you get a list of the the HTML data to select that you want to import. Alex -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
