OpenTextFile(Stream,TextFileOpenFlags,String,String,String,Encoding) Method
In This Topic
Loads delimited text from a specified stream into the sheet, with or without headers, with the specified encoding.
Syntax
'Declaration
Public Overloads Sub OpenTextFile( _
ByVal As Stream, _
ByVal As TextFileOpenFlags, _
ByVal As String, _
ByVal columnDelimiter As String, _
ByVal As String, _
ByVal As Encoding _
)
'Usage
Dim instance As Worksheet
Dim stream As Stream
Dim flags As TextFileOpenFlags
Dim rowDelimiter As String
Dim columnDelimiter As String
Dim cellDelimiter As String
Dim encoding As Encoding
instance.OpenTextFile(stream, flags, rowDelimiter, columnDelimiter, cellDelimiter, encoding)
Parameters
- stream
- The stream from which to load data.
- flags
- The import flags.
- rowDelimiter
- The row delimiter string.
- columnDelimiter
- The column delimiter string.
- cellDelimiter
- The cell delimiter string.
- encoding
- The encoding.
See Also