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

FarPoint.Win.Spread.SheetView.LoadTextFileRange

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