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

FarPoint.Web.Spread.SheetView.LoadTextFile

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