Re: [libreoffice-users] Re: QueryTables equivalent?

Hi :)
I was pointing you to the Getting Started with Base documentation because i 
thought you were just asking about migrating from MS Office Access to Base and 
needed to know about Queries in Base.  


Your question seems to have become much more complicated so it might be better 
on the devs mailing list because i doubt any on the users list know how to do 
this sort of thing.  

Good luck and regards from
Tom :)




________________________________
From: nwchrisb <nwchrisb@gmail.com>
To: users@libreoffice.org
Sent: Fri, 3 June, 2011 5:43:07
Subject: [libreoffice-users] Re: QueryTables equivalent?

Hi Tom,

Thanks for your response.  Which specific document on that page are you
referring to?  Page 36 in the overall starter guide
(http://wiki.documentfoundation.org/cgi_img_auth.php/f/f7/0100GS3-GettingStartedLibO.odt)

is about fonts (the PDF page 36 is similar).

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.

Thanks

Chris

--
View this message in context: 
http://nabble.documentfoundation.org/QueryTables-equivalent-tp3013283p3018551.html

Sent from the Users mailing list archive at Nabble.com.

-- 
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
-- 
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