LoadTextFile(String,Boolean,IncludeHeaders,Boolean,String,String,String,Encoding,Boolean) Method
In This Topic
Loads a text file with data (and perhaps headers and footer) into the sheet with the specified delimiters.
Syntax
'Declaration
Public Overloads Sub LoadTextFile( _
ByVal As String, _
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 fileName As String
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(fileName, unformatted, includeHeaders, includeFooter, rowDelimiter, columnDelimiter, cellDelimiter, encoding, loadFormulas)
Parameters
- fileName
- Path and name of the file 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