ssml:webPr
Web Query Properties
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-externalConnections.xsd
Type: ssml:CT_WebPr
Properties: Local, Qualified
Content
- ssml:tables [0..1] Tables
Attributes
Name | Occ | Type | Description | Notes |
---|---|---|---|---|
xml | [0..1] | xsd:boolean | XML Source | Default value is "false". |
sourceData | [0..1] | xsd:boolean | Import XML Source Data | Default value is "false". |
parsePre | [0..1] | xsd:boolean | Parse PRE | Default value is "false". |
consecutive | [0..1] | xsd:boolean | Consecutive Delimiters | Default value is "false". |
firstRow | [0..1] | xsd:boolean | Use First Row | Default value is "false". |
xl97 | [0..1] | xsd:boolean | Created in Excel 97 | Default value is "false". |
textDates | [0..1] | xsd:boolean | Dates as Text | Default value is "false". |
xl2000 | [0..1] | xsd:boolean | Refreshed in Excel 2000 | Default value is "false". |
url | [0..1] | ssml:ST_Xstring | URL | |
post | [0..1] | ssml:ST_Xstring | Web Post | |
htmlTables | [0..1] | xsd:boolean | HTML Tables Only | Default value is "false". |
htmlFormat | [0..1] | ssml:ST_HtmlFmt | HTML Formatting Handling | Default value is "none". |
editPage | [0..1] | ssml:ST_Xstring | Edit Query URL |
Used in
- Type ssml:CT_Connection (Element ssml:connection)
Sample instance
<ssml:webPr> <ssml:tables> <ssml:m/> </ssml:tables> </ssml:webPr>