Class ExcelTextProperties
Properties for text file connections.
Inherited Members
Namespace: OfficeOpenXml.Data.Connection
Assembly: EPPlus.dll
Syntax
public class ExcelTextPropertiesProperties
CharacterSet
The character set assosiated with the source file. Names are limited to the IANA charcter set, http://www.iana.org/assignments/character-sets.
Declaration
public string CharacterSet { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Comma
Indicates if comma is a delimiter. Defaults to false.
Declaration
public bool Comma { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Consecutive
Indicates if consecutive delimiters are treated as one. Defaults to false.
Declaration
public bool Consecutive { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Decimal
The decimal separator. Defaults to ".".
Declaration
public string Decimal { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Delimited
Indicates whether the file is delimited. Defaults to true.
Declaration
public bool Delimited { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Delimiter
The custom delimiter. Optional.
Declaration
public string Delimiter { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Fields
Fields describing the text fields data type and position.
Declaration
public List<ExcelConnectionTextField> Fields { get; }Property Value
| Type | Description |
|---|---|
| List<ExcelConnectionTextField> |
FileType
Specifies the file type. Defaults to "Win".
Declaration
public eConnectionTextFileType FileType { get; set; }Property Value
| Type | Description |
|---|---|
| eConnectionTextFileType |
FirstRow
The first row to read. Defaults to 1.
Declaration
public uint FirstRow { get; set; }Property Value
| Type | Description |
|---|---|
| uint |
Prompt
Indicates whether to prompt the user. Defaults to true.
Declaration
public bool Prompt { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Qualifier
The text qualifier used. Defaults to double quote.
Declaration
public eConnectionTextQualifier Qualifier { get; set; }Property Value
| Type | Description |
|---|---|
| eConnectionTextQualifier |
Semicolon
Indicates if semicolon is a delimiter. Defaults to false.
Declaration
public bool Semicolon { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
SourceFile
The source file path. Defaults to an empty string.
Declaration
public string SourceFile { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Space
Indicates if space is a delimiter. Defaults to false.
Declaration
public bool Space { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Tab
Indicates if tab is a delimiter. Defaults to true.
Declaration
public bool Tab { get; set; }Property Value
| Type | Description |
|---|---|
| bool |
Thousands
The thousands separator. Defaults to ",".
Declaration
public string Thousands { get; set; }Property Value
| Type | Description |
|---|---|
| string |