Class ExcelWebProperties
Connection properties for web queries.
Inherited Members
Namespace: OfficeOpenXml.Data.Connection
Assembly: EPPlus.dll
Syntax
public class ExcelWebPropertiesProperties
Consecutive
If consecutive delimiters should be treated as just one delimiter
Declaration
public bool Consecutive { get; set; }Property Value
| Type | Description |
|---|---|
| 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.
Declaration
public string EditPage { get; set; }Property Value
| Type | Description |
|---|---|
| string |
FirstRow
Whether to parse all tables inside a PRE block with the same width settings as the first row.
Declaration
public bool FirstRow { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
HtmlFormat
How to handle formatting from the HTML source when bringing web query data into the worksheet.Relevant when IsXmlSourceDatais True
Declaration
public eHtmlFormatingHandling HtmlFormat { get; set; }Property Value
| Type | Description |
|---|---|
| eHtmlFormatingHandling |
HtmlTables
If web queries should only work on HTML tables.
Declaration
public bool HtmlTables { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
IsExcel2000
If the web query is created or refreshed in Excel 2000 or later.
Declaration
public bool IsExcel2000 { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
IsExcel97
If the web query is created in Excel 97
Declaration
public bool IsExcel97 { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
IsXml
True if the web query source is XML (versus HTML), otherwise false.
Declaration
public bool IsXml { get; set; }Property Value
| Type | Description |
|---|---|
| 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>
Declaration
public bool IsXmlSourceData { get; set; }Property Value
| Type | Description |
|---|---|
| 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.
Declaration
public bool ParsePRE { get; set; }Property Value
| Type | Description |
|---|---|
| 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.
Declaration
public string Post { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Tables
A list of all tables in the HTML document that can be imported using the web query.
Declaration
public List<ExcelHtmlTableReference> Tables { get; }Property Value
| Type | Description |
|---|---|
| List<ExcelHtmlTableReference> |
TextDates
If dates should be imported into cells in the worksheet as text rather than dates.
Declaration
public bool TextDates { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Url
The URL to use to refresh external data
Declaration
public string Url { get; set; }Property Value
| Type | Description |
|---|---|
| string |