LoadTextFileRange(String,CellRange,TextFileFlags,String,String,String) Method
In This Topic
Loads delimited text from a specified file into the sheet, with or without headers, with 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 _
)
'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
instance.LoadTextFileRange(fileName, cellRange, textFileFlags, rowDelimiter, columnDelimiter, cellDelimiter)
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
Exceptions
See Also