LoadTextFileRange(String,CellRange,TextFileFlags,String,String,String,Encoding) Method
In This Topic
Loads delimited text from a specified file into the sheetwith the specified encoding.
Syntax
'Declaration
Public Overloads Sub LoadTextFileRange( _
ByVal As String, _
ByVal As CellRange, _
ByVal As TextFileFlags, _
ByVal As String, _
ByVal columnDelimiter As String, _
ByVal As String, _
ByVal As Encoding _
)
'Usage
Dim instance As SheetView
Dim fileName As String
Dim cellRange As CellRange
Dim textFileFlags As TextFileFlags
Dim rowDelimiter As String
Dim columnDelimiter As String
Dim cellDelimiter As String
Dim encoding As Encoding
instance.LoadTextFileRange(fileName, cellRange, textFileFlags, rowDelimiter, columnDelimiter, cellDelimiter, encoding)
Parameters
- fileName
- Path and name of the file to load
- cellRange
- Specifies range process the data when loading from a text file
- textFileFlags
- Specifies how to process the data when loading from a text file
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
- encoding
- Encoding
Exceptions
See Also