Class WebQueryConnection
Namespace: Aspose.Cells.ExternalConnections
Assembly: Aspose.Cells.dll (25.2.0)
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.
public class WebQueryConnection : ExternalConnectionInheritance
object ← ExternalConnection ← WebQueryConnection
Inherited Members
ExternalConnection.Id, ExternalConnection.ClassType, ExternalConnection.PowerQueryFormula, ExternalConnection.SourceType, ExternalConnection.SSOId, ExternalConnection.SavePassword, ExternalConnection.SaveData, ExternalConnection.RefreshOnLoad, ExternalConnection.ReconnectionMethodType, ExternalConnection.OnlyUseConnectionFile, ExternalConnection.OdcFile, ExternalConnection.SourceFile, ExternalConnection.ConnectionFile, ExternalConnection.IsNew, ExternalConnection.Name, ExternalConnection.KeepAlive, ExternalConnection.RefreshInternal, ExternalConnection.ConnectionDescription, ExternalConnection.IsDeleted, ExternalConnection.CredentialsMethodType, ExternalConnection.BackgroundRefresh, ExternalConnection.Parameters, ExternalConnection.Command, ExternalConnection.CommandType, ExternalConnection.ConnectionString, ExternalConnection.SecondCommand, object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Properties
ClassType
Gets the type of this Aspose.Cells.ExternalConnections.ExternalConnection object.
public override ExternalConnectionClassType ClassType { get; }Property Value
ConnectionFile
Gets the connection file.
public override string ConnectionFile { get; }Property Value
EditWebPage
The 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.
public string EditWebPage { get; set; }Property Value
HtmlFormat
How to handle formatting from the HTML source when bringing web query data into the worksheet. Relevant when sourceData is True.
public HtmlFormatHandlingType HtmlFormat { get; set; }Property Value
IsConsecutive
Flag indicating whether consecutive delimiters should be treated as just one delimiter.
public bool IsConsecutive { get; set; }Property Value
IsHtmlTables
Flag indicating whether web queries should only work on HTML tables.
public bool IsHtmlTables { get; set; }Property Value
IsParsePre
Flag 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.
public bool IsParsePre { get; set; }Property Value
IsSameSettings
Flag indicating whether to parse all tables inside a PRE block with the same width settings as the first row.
public bool IsSameSettings { get; set; }Property Value
IsTextDates
Flag indicating whether dates should be imported into cells in the worksheet as text rather than dates.
public bool IsTextDates { get; set; }Property Value
IsXl2000
This 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.
public bool IsXl2000 { get; set; }Property Value
IsXl97
This 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.
public bool IsXl97 { get; set; }Property Value
IsXml
true if the web query source is XML (versus HTML), otherwise false.
public bool IsXml { get; set; }Property Value
IsXmlSourceData
Flag indicating that XML source data should be imported instead of the HTML table itself.
public bool IsXmlSourceData { get; set; }Property Value
Post
Returns or sets the string used with the post method of inputting data into a web server to return data from a web query.
public string Post { get; set; }Property Value
Url
URL to use to refresh external data.
public string Url { get; set; }