[libreoffice-users] Re: QueryTables equivalent?

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 users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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