Loads the text from a stream with the specified formatting.
Syntax
'Declaration
Public Overloads Shared Sub LoadTextFile( _
ByVal As SheetView, _
ByVal As Stream, _
ByVal As Boolean, _
ByVal As IncludeHeaders, _
ByVal As String, _
ByVal columnDelimiter As String, _
ByVal As String, _
ByVal As Encoding, _
ByVal As Boolean _
)
'Usage
Dim sheetView 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
Dim loadFormulas As Boolean
SpreadSerializer.LoadTextFile(sheetView, stream, unformatted, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, encoding, loadFormulas)
Parameters
- sheetView
- Sheet into which to load the text data
- stream
- Stream from which to load text
- unformatted
- Whether to bypass formatting
- includeHeaders
- Whether headers are handled as data
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
- encoding
- Encoding of the file
- loadFormulas
- Whether to load formula values
See Also