LoadTextFile(String,TextFileFlags,IncludeHeaders,String,String,String,Encoding) 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 LoadTextFile( _
ByVal As String, _
ByVal As TextFileFlags, _
ByVal As IncludeHeaders, _
ByVal As String, _
ByVal columnDelimiter As String, _
ByVal As String, _
ByVal As Encoding _
)
'Usage
Dim instance As SheetView
Dim fileName As String
Dim textFileFlags As TextFileFlags
Dim includeHeaders As IncludeHeaders
Dim rowDelimiter As String
Dim columnDelimiter As String
Dim cellDelimiter As String
Dim encoding As Encoding
instance.LoadTextFile(fileName, textFileFlags, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, encoding)
Parameters
- fileName
- Path and name of the file to load
- textFileFlags
- Specifies how to process the data when loading from a text file
- includeHeaders
- Whether to export headers as data
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
- encoding
- Encoding
Exceptions
See Also