LoadTextFileRange Method

LoadTextFileRange(string, CellRange, TextFileFlags)

Loads delimited text from a specified file into the sheet.

Declaration

public void LoadTextFileRange(string fileName, CellRange cellRange, TextFileFlags textFileFlags)

Public Sub LoadTextFileRange(fileName As String, cellRange As CellRange, textFileFlags As TextFileFlags)

Parameters

Type	Name	Description
string	fileName	Path and name of the file to load
CellRange	cellRange	Specifies range process the data when loading from a text file
TextFileFlags	textFileFlags	Specifies how to process the data when loading from a text file

LoadTextFileRange(string, CellRange, TextFileFlags, string, string, string)

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

Declaration

public void LoadTextFileRange(string fileName, CellRange cellRange, TextFileFlags textFileFlags, string rowDelimiter, string columnDelimiter, string cellDelimiter)

Public Sub LoadTextFileRange(fileName As String, cellRange As CellRange, textFileFlags As TextFileFlags, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String)

Parameters

Type	Name	Description
string	fileName	Path and name of the file to load
CellRange	cellRange	Specifies range process the data when loading from a text file
TextFileFlags	textFileFlags	Specifies how to process the data when loading from a text file
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

LoadTextFileRange(string, CellRange, TextFileFlags, string, string, string, Encoding)

Loads delimited text from a specified file into the sheetwith the specified encoding.

Declaration

public void LoadTextFileRange(string fileName, CellRange cellRange, TextFileFlags textFileFlags, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding)

Public Sub LoadTextFileRange(fileName As String, cellRange As CellRange, textFileFlags As TextFileFlags, 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
CellRange	cellRange	Specifies range process the data when loading from a text file
TextFileFlags	textFileFlags	Specifies how to process the data when loading from a text file
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

LoadTextFileRange(Stream, CellRange, TextFileFlags)

Loads delimited text from a specified file into the sheet.

Declaration

public void LoadTextFileRange(Stream stream, CellRange cellRange, TextFileFlags textFileFlags)

Public Sub LoadTextFileRange(stream As Stream, cellRange As CellRange, textFileFlags As TextFileFlags)

Parameters

Type	Name	Description
Stream	stream	Stream to which to load the text of the sheet
CellRange	cellRange	Specifies range process the data when loading from a text file
TextFileFlags	textFileFlags	Specifies how to process the data when loading from a text file

LoadTextFileRange(Stream, CellRange, TextFileFlags, string, string, string, Encoding)

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

Declaration

public void LoadTextFileRange(Stream stream, CellRange cellRange, TextFileFlags textFileFlags, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding)

Public Sub LoadTextFileRange(stream As Stream, cellRange As CellRange, textFileFlags As TextFileFlags, 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
CellRange	cellRange	Specifies range process the data when loading from a text file
TextFileFlags	textFileFlags	Specifies how to process the data when loading from a text file
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

LoadTextFileRange(Stream, CellRange, TextFileFlags, string, string, string)

Loads delimited text from a specified file into the sheet.

Declaration

public void LoadTextFileRange(Stream stream, CellRange cellRange, TextFileFlags textFileFlags, string rowDelimiter, string columnDelimiter, string cellDelimiter)

Public Sub LoadTextFileRange(stream As Stream, cellRange As CellRange, textFileFlags As TextFileFlags, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String)

Parameters

Type	Name	Description
Stream	stream	Stream to which to load the text of the sheet
CellRange	cellRange	Specifies range process the data when loading from a text file
TextFileFlags	textFileFlags	Specifies how to process the data when loading from a text file
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