Hi, Jean,
Jean Hollis Weber wrote:
I'm writing a section for the Calc Guide about linking from a
spreadsheet to external data. I found a page in the help titled
"Inserting External Data in Table (WebQuery)" which explains what to do
but seems to assume some background knowledge that I don't have (and I
suspect many of the readers of the Calc Guide won't have) -- or perhaps
it's just a matter of using terms in ways that are not familiar to me.
So I hope someone here can help me understand better, so I can write
this up for the user guide.
I searched the forum and the wiki, and didn't find anything useful to
me. Haven't gone to the [users] list yet; thought I'm check with this
group first.
For example, here's part of a sentence from the help:
"If you have loaded an HTML document with the Web Page Query filter as
the source document..."
Er... how do I "load a doc with the WPQ filter"? Do I simply choose that
as a file type in the Open dialog?
Basically, yes. See below.
Or does something else need to be done?
"... you will find the tables in the Navigator, named continuously from
HTML_table1 onwards, and also two range names that have been created:
HTML_all – designates the entire document
HTML_tables – designates all HTML tables in the document"
I guess I need to somehow pick a table of data and avoid tables used for
layout... or does it matter?
An example, with illustrations or HTML samples, might help me get the
concept. I suspect it's quite easy and obvious once one understands it!
Thanks for any help you can give me.
--Jean
Every OO.o document is loaded "with" a filter, meaning "by use of". The
details (filter name and parameter settings) are recorded in the running
document, and are accessible through the API and Basic.
As you suspected, "available filter" might be defined, off-hand, as,
"what you find in the *File type* list box". WebQuery is there, far down
in the Calc section.
My personal expertise with tables is zero, so I can only suggest that
you try it. IIRC, Calc can handle text tables as well as numeric
tables, so it shouldn't matter what table you select, other than in the
sense of "what you want".
HTH, /tj/
--
T. J. Frazier
Melbourne, FL
(TJFrazier on OO.o)
