WebQueryConnection class

WebQueryConnection class

Specifies the properties for a web query source. A web query will retrieve data from HTML tables, and can also supply HTTP “Get” parameters to be processed by the web server in generating the HTML by including the parameters and parameter elements.

Inheritance: WebQueryConnection

The WebQueryConnection type exposes the following members:

Properties

PropertyDescription
id
connection_id
class_typeGets the type of this ExternalConnection object.
power_query_formula
type
source_type
sso_id
save_password
save_data
refresh_on_load
reconnection_method_type
reconnection_method
only_use_connection_file
odc_file
source_file
connection_fileGets the connection file.
is_new
name
keep_alive
refresh_internal
connection_description
is_deleted
credentials_method_type
credentials
background_refresh
parameters
command
command_type
connection_string
second_command
is_xmltrue if the web query source is XML (versus HTML), otherwise false.
is_xl97This flag exists for backward compatibility with older existing spreadsheet files, and is set
to true if this web query was created in Microsoft Excel 97.
This is an optional attribute that can be ignored.
is_xl2000This flag exists for backward compatibility with older existing spreadsheet files, and is set
to true if this web query was refreshed in a spreadsheet application newer than or equal
to Microsoft Excel 2000.
This is an optional attribute that can be ignored.
urlURL to use to refresh external data.
is_text_datesFlag indicating whether dates should be imported into cells in the worksheet as text rather than dates.
is_xml_source_dataFlag indicating that XML source data should be imported instead of the HTML table itself.
postReturns or sets the string used with the post method of inputting data into a web server
to return data from a web query.
is_parse_preFlag indicating whether data contained within HTML PRE tags in the web page is
parsed into columns when you import the page into a query table.
is_html_tablesFlag indicating whether web queries should only work on HTML tables.
html_formatHow to handle formatting from the HTML source when bringing web query data into the
worksheet. Relevant when sourceData is True.
is_same_settingsFlag indicating whether to parse all tables inside a PRE block with the same width settings
as the first row.
edit_web_pageThe URL of the user-facing web page showing the web query data. This URL is persisted
in the case that sourceData=“true” and url has been redirected to reference an XML file.
Then the user-facing page can be shown in the UI, and the XML data can be retrieved
behind the scenes.
edit_pageThe URL of the user-facing web page showing the web query data. This URL is persisted
in the case that sourceData=“true” and url has been redirected to reference an XML file.
Then the user-facing page can be shown in the UI, and the XML data can be retrieved
behind the scenes.
is_consecutiveFlag indicating whether consecutive delimiters should be treated as just one delimiter.

See Also