T. J. Frazier wrote:
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".
Thanks, T.J. That helps, as a starting point. I think I'm going to cheat
by reading stuff (esp. examples for the uninitiated) on Excel's WebQuery
and try to relate that to OOo, until it makes more sense to me.
--Jean