[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

FarPoint.Win.Spread.SheetView.LoadTextFile

LoadTextFile Method

LoadTextFile(string, TextFileFlags)

Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.

Declaration
public void LoadTextFile(string fileName, TextFileFlags textFileFlags)
Public Sub LoadTextFile(fileName As String, textFileFlags As TextFileFlags)
Parameters
Type Name Description
string fileName

Path and name of the file to load
TextFileFlags textFileFlags

Specifies how to process the data when loading from a text file

LoadTextFile(Stream, TextFileFlags)

Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.

Declaration
public void LoadTextFile(Stream stream, TextFileFlags textFileFlags)
Public Sub LoadTextFile(stream As Stream, textFileFlags As TextFileFlags)
Parameters
Type Name Description
Stream stream

Stream to which to load the text
TextFileFlags textFileFlags

Specifies how to process the data when loading from a text file

LoadTextFile(string, TextFileFlags, IncludeHeaders, string, string, string)

Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.

Declaration
public void LoadTextFile(string fileName, TextFileFlags textFileFlags, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter)
Public Sub LoadTextFile(fileName As String, textFileFlags As TextFileFlags, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String)
Parameters
Type Name Description
string fileName

Path and name of the file to load
TextFileFlags textFileFlags

Specifies how to process the data when loading from a text file
IncludeHeaders includeHeaders

Whether to export headers as data
string rowDelimiter

Row delimiter string
string columnDelimiter

Column delimiter string
string cellDelimiter

Cell delimiter string
Exceptions
Type Condition
ArgumentException

Cell delimiter cannot be contained in a row or column delimiter

LoadTextFile(string, TextFileFlags, IncludeHeaders, string, string, string, Encoding)

Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.

Declaration
public void LoadTextFile(string fileName, TextFileFlags textFileFlags, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding)
Public Sub LoadTextFile(fileName As String, textFileFlags As TextFileFlags, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding)
Parameters
Type Name Description
string fileName

Path and name of the file to load
TextFileFlags textFileFlags

Specifies how to process the data when loading from a text file
IncludeHeaders includeHeaders

Whether to export headers as data
string rowDelimiter

Row delimiter string
string columnDelimiter

Column delimiter string
string cellDelimiter

Cell delimiter string
Encoding encoding

Encoding
Exceptions
Type Condition
ArgumentException

Cell delimiter cannot be contained in a row or column delimiter

LoadTextFile(Stream, TextFileFlags, IncludeHeaders, string, string, string)

Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.

Declaration
public void LoadTextFile(Stream stream, TextFileFlags textFileFlags, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter)
Public Sub LoadTextFile(stream As Stream, textFileFlags As TextFileFlags, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String)
Parameters
Type Name Description
Stream stream

Stream to which to save the text of the sheet
TextFileFlags textFileFlags

Specifies how to process the data when loading from a text file
IncludeHeaders includeHeaders

Whether to export headers as data
string rowDelimiter

Row delimiter string
string columnDelimiter

Column delimiter string
string cellDelimiter

Cell delimiter string
Exceptions
Type Condition
ArgumentException

Cell delimiter cannot be contained in a row or column delimiter

LoadTextFile(Stream, TextFileFlags, IncludeHeaders, string, string, string, Encoding)

Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.

Declaration
public void LoadTextFile(Stream stream, TextFileFlags textFileFlags, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding)
Public Sub LoadTextFile(stream As Stream, textFileFlags As TextFileFlags, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding)
Parameters
Type Name Description
Stream stream

Stream to which to load the text of the sheet
TextFileFlags textFileFlags

Specifies how to process the data when loading from a text file
IncludeHeaders includeHeaders

Whether to export headers as data
string rowDelimiter

Row delimiter string
string columnDelimiter

Column delimiter string
string cellDelimiter

Cell delimiter string
Encoding encoding

Encoding
Exceptions
Type Condition
ArgumentException

Cell delimiter cannot be contained in a row or column delimiter