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