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 _
)
'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
instance.LoadTextFile(stream, unformatted, includeHeaders, includeFooter, rowDelimiter, columnDelimiter, cellDelimiter)
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
See Also