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
instance.LoadTextFile(fileName, textFileFlags) |
Parameters
- fileName
- Path and name of the file to load
- textFileFlags
- Specifies how to process the data when loading from a text file
Example
This example loads a text file.
C# | Copy Code |
---|
OpenFileDialog ofd = new OpenFileDialog();
string s;
ofd.Filter = "text files (*.txt)|*.txt";
ofd.FilterIndex = 2;
ofd.RestoreDirectory = true;
if (ofd.ShowDialog() == DialogResult.OK)
{
s = ofd.FileName;
fpSpread1.ActiveSheet.LoadTextFile(s, true);
} |
Visual Basic | Copy Code |
---|
Dim s As String
Dim ofd As New OpenFileDialog()
ofd.Filter = "text files (*.txt)|*.txt"
ofd.FilterIndex = 2
ofd.RestoreDirectory = True
If ofd.ShowDialog() = DialogResult.OK Then
s = ofd.FileName
FpSpread1.ActiveSheet.LoadTextFile(s, FarPoint.Win.Spread.TextFileFlags.Unformatted)
End If |
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