Class ExcelWebProperties¶

Namespace: OfficeOpenXml.Data.Connection
Assembly: EPPlus.dll

Connection properties for web queries.

public class ExcelWebProperties

Inheritance¶

object ← ExcelWebProperties

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelWebProperties()¶

public ExcelWebProperties()

Properties¶

Consecutive¶

If consecutive delimiters should be treated as just one delimiter

public bool Consecutive { get; set; }

Property Value¶

bool

EditPage¶

The URL of the user-facing web page showing the web query data. This URL is persisted in the case that IsXmlSourceData = "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 EditPage { get; set; }

Property Value¶

string

FirstRow¶

Whether to parse all tables inside a PRE block with the same width settings as the first row.

public bool FirstRow { get; set; }

Property Value¶

bool

HtmlFormat¶

How to handle formatting from the HTML source when bringing web query data into the worksheet.Relevant when IsXmlSourceDatais True

public eHtmlFormatingHandling HtmlFormat { get; set; }

Property Value¶

eHtmlFormatingHandling

HtmlTables¶

If web queries should only work on HTML tables.

public bool HtmlTables { get; set; }

Property Value¶

bool

IsExcel2000¶

If the web query is created or refreshed in Excel 2000 or later.

public bool IsExcel2000 { get; set; }

Property Value¶

bool

IsExcel97¶

If the web query is created in Excel 97

public bool IsExcel97 { get; set; }

Property Value¶

bool

IsXml¶

True if the web query source is XML (versus HTML), otherwise false.

public bool IsXml { get; set; }

Property Value¶

bool

IsXmlSourceData¶

If XML source data should be imported instead of the HTML table itself. Used when a web query exists to an HTML table with the following attribute. <TABLE … o:WebQuerySourceHRef=”http://…” … > … </TABLE>

public bool IsXmlSourceData { get; set; }

Property Value¶

bool

ParsePRE¶

If 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 ParsePRE { get; set; }

Property Value¶

bool

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¶

string

Tables¶

A list of all tables in the HTML document that can be imported using the web query.

public List<ExcelHtmlTableReference> Tables { get; }

Property Value¶

List<ExcelHtmlTableReference>

TextDates¶

If dates should be imported into cells in the worksheet as text rather than dates.

public bool TextDates { get; set; }

Property Value¶

bool

Url¶

The URL to use to refresh external data

public string Url { get; set; }

Property Value¶

string