LoadTextFile Method

LoadTextFile(string, bool)

Loads a text file with the specified name into the sheet.

Declaration

public void LoadTextFile(string fileName, bool unformatted)

Public Sub LoadTextFile(fileName As String, unformatted As Boolean)

Parameters

Type	Name	Description
string	fileName	Path and name of the file from which to load the sheet
bool	unformatted	Whether to load the data unformatted

LoadTextFile(Stream, bool)

Loads a stream that contains delimited data into the sheet.

Declaration

public void LoadTextFile(Stream stream, bool unformatted)

Public Sub LoadTextFile(stream As Stream, unformatted As Boolean)

Parameters

Type	Name	Description
Stream	stream	Stream from which to load the sheet
bool	unformatted	Whether to load the data unformatted

LoadTextFile(string, bool, IncludeHeaders, string, string, string)

Loads a text file with data (and perhaps headers) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(string fileName, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter)

Public Sub LoadTextFile(fileName As String, unformatted As Boolean, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String)

Parameters

Type	Name	Description
string	fileName	Path and name of the file from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string

LoadTextFile(string, bool, IncludeHeaders, bool, string, string, string)

Loads a text file with data (and perhaps headers and footer) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(string fileName, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter)

Public Sub LoadTextFile(fileName As String, unformatted As Boolean, includeHeaders As IncludeHeaders, includeFooter As Boolean, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String)

Parameters

Type	Name	Description
string	fileName	Path and name of the file from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
bool	includeFooter	Whether to load the data from the footer cells
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string

LoadTextFile(string, bool, IncludeHeaders, string, string, string, Encoding)

Loads a text file with data (and perhaps headers) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(string fileName, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding)

Public Sub LoadTextFile(fileName As String, unformatted As Boolean, 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 from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding

LoadTextFile(string, bool, IncludeHeaders, bool, string, string, string, Encoding)

Loads a text file with data (and perhaps headers and footer) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(string fileName, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding)

Public Sub LoadTextFile(fileName As String, unformatted As Boolean, includeHeaders As IncludeHeaders, includeFooter As Boolean, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding)

Parameters

Type	Name	Description
string	fileName	Path and name of the file from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
bool	includeFooter	Whether to load the data from the footer cells
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding

LoadTextFile(string, bool, IncludeHeaders, string, string, string, Encoding, bool)

Loads a text file with data (and perhaps headers) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(string fileName, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding, bool loadFormulas)

Public Sub LoadTextFile(fileName As String, unformatted As Boolean, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding, loadFormulas As Boolean)

Parameters

Type	Name	Description
string	fileName	Path and name of the file from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding
bool	loadFormulas	Whether to load formulas

LoadTextFile(string, bool, IncludeHeaders, bool, string, string, string, Encoding, bool)

Loads a text file with data (and perhaps headers and footer) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(string fileName, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding, bool loadFormulas)

Public Sub LoadTextFile(fileName As String, unformatted As Boolean, includeHeaders As IncludeHeaders, includeFooter As Boolean, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding, loadFormulas As Boolean)

Parameters

Type	Name	Description
string	fileName	Path and name of the file from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
bool	includeFooter	Whether to load the data from the footer cells
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding
bool	loadFormulas	Whether to load formulas

LoadTextFile(Stream, bool, IncludeHeaders, string, string, string)

Loads a stream that contains delimited data (and perhaps headers) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(Stream stream, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter)

Public Sub LoadTextFile(stream As Stream, unformatted As Boolean, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String)

Parameters

Type	Name	Description
Stream	stream	Stream from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string

LoadTextFile(Stream, bool, IncludeHeaders, bool, string, string, string)

Loads a stream that contains delimited data (and perhaps headers and footer) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(Stream stream, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter)

Public Sub LoadTextFile(stream As Stream, unformatted As Boolean, includeHeaders As IncludeHeaders, includeFooter As Boolean, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String)

Parameters

Type	Name	Description
Stream	stream	Stream from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
bool	includeFooter	Whether to load the data from the footer cells
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string

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

Loads a stream that contains delimited data (and perhaps headers) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(Stream stream, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding)

Public Sub LoadTextFile(stream As Stream, unformatted As Boolean, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding)

Parameters

Type	Name	Description
Stream	stream	Stream from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding

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

Loads a stream that contains delimited data (and perhaps headers and footer) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(Stream stream, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding)

Public Sub LoadTextFile(stream As Stream, unformatted As Boolean, includeHeaders As IncludeHeaders, includeFooter As Boolean, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding)

Parameters

Type	Name	Description
Stream	stream	Stream from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
bool	includeFooter	Whether to load the data from the footer cells
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding

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

Loads a stream that contains delimited data (and perhaps headers) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(Stream stream, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding, bool loadFormulas)

Public Sub LoadTextFile(stream As Stream, unformatted As Boolean, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding, loadFormulas As Boolean)

Parameters

Type	Name	Description
Stream	stream	Stream from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding
bool	loadFormulas	Whether to load formulas

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

Loads a stream that contains delimited data (and perhaps headers and footer) into the sheet with the specified delimiters.

Declaration

public void LoadTextFile(Stream stream, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding, bool loadFormulas)

Public Sub LoadTextFile(stream As Stream, unformatted As Boolean, includeHeaders As IncludeHeaders, includeFooter As Boolean, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, encoding As Encoding, loadFormulas As Boolean)

Parameters

Type	Name	Description
Stream	stream	Stream from which to load the sheet
bool	unformatted	Whether to load the data unformatted
IncludeHeaders	includeHeaders	Which header cells to load data from
bool	includeFooter	Whether to load the data from the footer cells
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding
bool	loadFormulas	Whether to load formulas