LoadTextFile Method

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

Loads the text file with the specified formatting.

Declaration

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

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

Parameters

Type	Name	Description
SheetView	sheetView	Sheet into which to load the text data
string	fileName	Path and name of file from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string

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

Loads the text file with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
string	fileName	Path and name of file from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
bool	includeFooter	Whether the footer is handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string

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

Loads the text file with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
string	fileName	Path and name of file from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding

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

Loads the text file with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
string	fileName	Path and name of file from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
bool	includeFooter	Whether the footer is handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding

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

Loads the text file with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
string	fileName	Path and name of file from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
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(SheetView, string, bool, IncludeHeaders, bool, string, string, string, Encoding, bool)

Loads the text file with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
string	fileName	Path and name of file from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
bool	includeFooter	Whether the footer is handled as data
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(SheetView, Stream, bool, IncludeHeaders, string, string, string)

Loads the text from a stream with the specified formatting.

Declaration

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

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

Parameters

Type	Name	Description
SheetView	sheetView	Sheet into which to load the text data
Stream	stream	Stream from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string

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

Loads the text from a stream with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
Stream	stream	Stream from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
bool	includeFooter	Whether footer is handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string

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

Loads the text from a stream with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
Stream	stream	Stream from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding of the file

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

Loads the text from a stream with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
Stream	stream	Stream from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
bool	includeFooter	Whether the footer is handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding of the file

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

Loads the text from a stream with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
Stream	stream	Stream from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding of the file
bool	loadFormulas	Whether to load formula values

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

Loads the text from a stream with the specified formatting.

Declaration

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

Public Shared Sub LoadTextFile(sheetView As SheetView, 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
SheetView	sheetView	Sheet into which to load the text data
Stream	stream	Stream from which to load text
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
bool	includeFooter	Whether the footer is handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
Encoding	encoding	Encoding of the file
bool	loadFormulas	Whether to load formula values

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

Loads the text (string) data with the specified formatting.

Declaration

public static void LoadTextFile(SheetView sheetView, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, string data)

Public Shared Sub LoadTextFile(sheetView As SheetView, unformatted As Boolean, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, data As String)

Parameters

Type	Name	Description
SheetView	sheetView	Sheet into which to load the text data
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
string	data	String that contains data to load

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

Loads the text (string) data with the specified formatting.

Declaration

public static void LoadTextFile(SheetView sheetView, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter, string data)

Public Shared Sub LoadTextFile(sheetView As SheetView, unformatted As Boolean, includeHeaders As IncludeHeaders, includeFooter As Boolean, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, data As String)

Parameters

Type	Name	Description
SheetView	sheetView	Sheet into which to load the text data
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
bool	includeFooter	Whether the footer is handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
string	data	String that contains data to load

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

Loads the text (string) data with the specified formatting.

Declaration

public static void LoadTextFile(SheetView sheetView, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, string data, bool loadFormulas)

Public Shared Sub LoadTextFile(sheetView As SheetView, unformatted As Boolean, includeHeaders As IncludeHeaders, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, data As String, loadFormulas As Boolean)

Parameters

Type	Name	Description
SheetView	sheetView	Sheet into which to load the text data
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
string	data	String that contains data to load
bool	loadFormulas	Whether to load formulas

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

Loads the text (string) data with the specified formatting.

Declaration

public static void LoadTextFile(SheetView sheetView, bool unformatted, IncludeHeaders includeHeaders, bool includeFooter, string rowDelimiter, string columnDelimiter, string cellDelimiter, string data, bool loadFormulas)

Public Shared Sub LoadTextFile(sheetView As SheetView, unformatted As Boolean, includeHeaders As IncludeHeaders, includeFooter As Boolean, rowDelimiter As String, columnDelimiter As String, cellDelimiter As String, data As String, loadFormulas As Boolean)

Parameters

Type	Name	Description
SheetView	sheetView	Sheet into which to load the text data
bool	unformatted	Whether to bypass formatting
IncludeHeaders	includeHeaders	Whether headers are handled as data
bool	includeFooter	Whether the footer is handled as data
string	rowDelimiter	Row delimiter string
string	columnDelimiter	Column delimiter string
string	cellDelimiter	Cell delimiter string
string	data	String that contains data to load
bool	loadFormulas	Whether to load formulas