Re: [libreoffice-users] QueryTables equivalent?

Hi :)
The old information from 2007 might still be reasonably valid.  Our 
documentation pages are at 

http://www.libreoffice.org/get-help/documentation/
It's only a starter guide but there is a chapter on Queries from about page 36 - 
43.  OPur documentation team haven't really got started with Base documentation 
yet but at least you don't have to write Queries as Sql statements!
Good luck and regards from
Tom :)



________________________________
From: nwchrisb <nwchrisb@gmail.com>
To: users@libreoffice.org
Sent: Thu, 2 June, 2011 1:29:17
Subject: [libreoffice-users] QueryTables equivalent?

Hi all,

I've searched this forum for "web query", "querytables", and "query tables",
as well as Googling, but most of the information I've found is pretty dated
(circa 2007).    I'm looking for some way to emulate the QueryTables "web
query" functionality that is present in Excel
(http://support.microsoft.com/kb/162080).  I've also found the OO developer
guide
(http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Spreadsheet_Documents),

but it's just not organized in a way I can easily use.

I am trying to collect multiple quarters of data from the ADVFN site (e.g.
http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=GLW&istart_date=0),

where the quarters change as the "istart_date" URL parameter changes, so it
doesn't seem like "Insert->Link to External Data" is going to work well for
me.

I was able to find a function that can pull in stock prices, but it uses
Yahoo! quote's CSV file output
(http://www.oooforum.org/forum/viewtopic.phtml?t=16741).  This would be
nice, but I need more than just stock prices, which is why I'm using the
ADVFN site.

If there's not a "baked-in" function that works like QueryTables, I could
probably write a scraper, but it seems like much of that is built-in
already; I just don't know what it's called.

Thanks for your time,

Chris

--
View this message in context: 
http://nabble.documentfoundation.org/QueryTables-equivalent-tp3013283p3013283.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