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>