Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim fileName As String
Dim textFileFlags As TextFileFlags
Dim includeHeaders As IncludeHeaders
Dim rowDelimiter As String
Dim columnDelimiter As String
Dim cellDelimiter As String
instance.LoadTextFile(fileName, textFileFlags, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter) |
Parameters
- fileName
- Path and name of the file to load
- textFileFlags
- Specifies how to process the data when loading from a text file
- includeHeaders
- Whether to export headers as data
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
Exceptions
Example
This example loads a text file.
C# | Copy Code |
---|
fpSpread1.ActiveSheet.LoadTextFile("c:\\test.txt", FarPoint.Win.Spread.TextFileFlags.Unformatted, FarPoint.Win.Spread.Model.IncludeHeaders.None, "\n", ",", ""); |
Visual Basic | Copy Code |
---|
FpSpread1.ActiveSheet.LoadTextFile("c:\test.txt", FarPoint.Win.Spread.TextFileFlags.Unformatted, FarPoint.Win.Spread.Model.IncludeHeaders.None, Chr(10), ",", "") |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also