LoadTextFile(Stream,Boolean,IncludeHeaders,String,String,String,Encoding) Method
In This Topic
Loads a stream that contains delimited data (and perhaps headers) into the sheet with the specified delimiters.
Syntax
'Declaration
Public Overloads Sub LoadTextFile( _
ByVal As Stream, _
ByVal As Boolean, _
ByVal As IncludeHeaders, _
ByVal As String, _
ByVal columnDelimiter As String, _
ByVal As String, _
ByVal As Encoding _
)
'Usage
Dim instance As SheetView
Dim stream As Stream
Dim unformatted As Boolean
Dim includeHeaders As IncludeHeaders
Dim rowDelimiter As String
Dim columnDelimiter As String
Dim cellDelimiter As String
Dim encoding As Encoding
instance.LoadTextFile(stream, unformatted, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, encoding)
Parameters
- stream
- Stream from which to load the sheet
- unformatted
- Whether to load the data unformatted
- includeHeaders
- Which header cells to load data from
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
- encoding
- Encoding
Example
This example uses the LoadTextFile method.
See Also