Visual Basic (Declaration) | |
---|---|
Public Overloads Sub LoadTextFile( _ ByVal fileName As String, _ ByVal textFileFlags As TextFileFlags, _ ByVal includeHeaders As IncludeHeaders, _ ByVal rowDelimiter As String, _ ByVal columnDelimiter As String, _ ByVal cellDelimiter As String, _ ByVal encoding As Encoding _ ) |
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 Dim encoding As Encoding instance.LoadTextFile(fileName, textFileFlags, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, encoding) |
C# | |
---|---|
public void LoadTextFile( string fileName, TextFileFlags textFileFlags, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding ) |
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
- encoding
- Encoding
Exception | Description |
---|---|
System.ArgumentException | Cell delimiter cannot be contained in a row or column delimiter |
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", ",", "", System.Text.Encoding.ASCII); |
Visual Basic | Copy Code |
---|---|
FpSpread1.ActiveSheet.LoadTextFile("c:\test.txt", FarPoint.Win.Spread.TextFileFlags.Unformatted, FarPoint.Win.Spread.Model.IncludeHeaders.None, Chr(10), ",", "", System.Text.Encoding.ASCII) |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8