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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.