ssml:textPr
Text Import Settings
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-externalConnections.xsd
Type: ssml:CT_TextPr
Properties: Local, Qualified
Content
- ssml:textFields [0..1] Fields
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| prompt | [0..1] | xsd:boolean | Prompt for File Name | Default value is "true". |
| fileType | [0..1] | ssml:ST_FileType | File Type | Default value is "win". |
| codePage | [0..1] | xsd:unsignedInt | Code Page | Default value is "1252". |
| firstRow | [0..1] | xsd:unsignedInt | First Row | Default value is "1". |
| sourceFile | [0..1] | ssml:ST_Xstring | Source File Name | Default value is "". |
| delimited | [0..1] | xsd:boolean | Delimited File | Default value is "true". |
| decimal | [0..1] | ssml:ST_Xstring | Decimal Separator | Default value is ".". |
| thousands | [0..1] | ssml:ST_Xstring | Thousands Separator | Default value is ",". |
| tab | [0..1] | xsd:boolean | Tab as Delimiter | Default value is "true". |
| space | [0..1] | xsd:boolean | Space is Delimiter | Default value is "false". |
| comma | [0..1] | xsd:boolean | Comma is Delimiter | Default value is "false". |
| semicolon | [0..1] | xsd:boolean | Semicolon is Delimiter | Default value is "false". |
| consecutive | [0..1] | xsd:boolean | Consecutive Delimiters | Default value is "false". |
| qualifier | [0..1] | ssml:ST_Qualifier | Qualifier | Default value is "doubleQuote". |
| delimiter | [0..1] | ssml:ST_Xstring | Custom Delimiter |
Used in
- Type ssml:CT_Connection (Element ssml:connection)
Sample instance
<ssml:textPr> <ssml:textFields> <ssml:textField/> </ssml:textFields> </ssml:textPr>