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