2.4.71 BrtBeginECWebProps

  • Article

The BrtBeginECWebProps record specifies the properties of a Web connection (section 2.2.8.5) and specifies the beginning of a collection of records as defined by the External Data Connections (section 2.1.7.24) part ABNF. The collection of records specifies the properties of a Web connection.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

wHTMLFmt

A

B

C

D

E

F

G

H

I

reserved1

J

K

L

reserved2

stURL (variable)

...

stWebPost (variable)

...

stEditWebPage (variable)

...

wHTMLFmt (8 bits):  An unsigned integer that specifies how to handle formatting from the HTML source when bringing Web connection (section 2.2.8.5) data into the sheet. This value MUST be one of the values in the following table.

Value

Meaning

0x00

None. There is no formatting.

0x01

RTF. Handle the formatting as rich text formatting.

0x02

All. Handle the formatting as all HTML formatting.

A - fSrcIsXML (1 bit): A bit that specifies whether the Web connection (section 2.2.8.5) source is XML. The following table specifies the meaning of each value.

Value

Meaning

0

The Web connection source is HTML.

1

The Web connection source is XML.

B - fImportSourceData (1 bit): A bit that specifies whether the source data is imported from a specified Uniform Resource Locator (URL) instead of the HTML table itself. This value is used when a Web connection (section 2.2.8.5) connects to an HTML table with the following attribute.

<TABLE ... o:WebQuerySourceHRef="http://..." ... > ... </TABLE>

The value of the WebQuerySourceHRef attribute specifies the URL to obtain the source data from. The following table specifies the meaning of each value.

Value

Meaning

0

Specifies that source data is not imported.

1

Specifies that source data is imported.

C - fParsePreFormatted (1 bit): A bit that specifies whether the data contained within HTML <PRE> tags in the web page is parsed into columns (1) when the page is imported into a query table. The following table specifies the meaning of each value.

Value

Meaning

0

Specifies that <PRE> tags are not parsed.

1

Specifies that <PRE> tags are parsed.

D - fConsecDelim (1 bit): A bit that specifies whether consecutive delimiters are treated as just one delimiter. The following table specifies the meaning of each value.

Value

Meaning

0

Each delimiter is treated as a separate delimiter.

1

Consecutive delimiters are treated as just one delimiter.

E - fSameSettings (1 bit): A bit that specifies whether all tables inside a <PRE> block are parsed with the same width settings as the first row.

F - fXL97Format (1 bit): A bit that specifies whether this Web connection (section 2.2.8.5) was created using a specific version of the application<9>.

G - fNoDateRecog (1 bit): A bit that specifies whether dates are imported into cells in the sheet as text rather than dates. The following table specifies the meaning of each value.

Value

Meaning

0

Dates are imported as date values.

1

Dates are imported as text.

H - fRefreshedInXL9 (1 bit): A bit that specifies whether this Web connection (section 2.2.8.5) was refreshed using a version of the application newer than a specific version<10>.

I - fTablesOnlyHTML (1 bit): A bit that specifies whether this Web connection (section 2.2.8.5) only works on HTML tables. The following table specifies the meaning of each value.

Value

Meaning

0

The Web connection only works on the whole Web page.

1

The Web connection only works on HTML tables.

reserved1 (15 bits): This value MUST be 0, and MUST be ignored.

J - fLoadWebPost (1 bit): A bit that specifies whether the stWebPost field exists after the fixed size portion of this record.

K - fLoadEditWebPage (1 bit): A bit that specifies whether the stEditWebPage field exists after the fixed size portion of this record.

L - fLoadURL (1 bit): A bit that specifies whether the stURL field exists after the fixed size portion of the record. If the fDeleted field in the preceding BrtBeginExtConnection (section 2.4.80) record is 0, this value MUST be 1. If the fDeleted field in the preceding BrtBeginExtConnection record is 1 and the fSrcIsXML field is 0, this value MUST be 0.

reserved2 (5 bits): This value MUST be 0, and MUST be ignored.

stURL (variable): An optional XLWideString (section 2.5.169) that specifies the URL to use to refresh external data. The length of this string MUST be greater than 0. This field MUST exist if and only if fLoadURL is 1.

stWebPost (variable): An optional XLWideString (section 2.5.169) that specifies the string used with the HTTP post method of sending data to a Web server. This field MUST exist if and only if fLoadWebPost is 1.

stEditWebPage (variable): An optional XLWideString (section 2.5.169) that specifies the URL of the user-facing Web page displaying the Web connection (section 2.2.8.5) data. This URL is persisted if fImportSourceData is 1 and stURL contains the URL specified by the o:WebQuerySourceHRef attribute in the selected HTML table. This field MUST exist if and only if fLoadEditWebPage is 1.