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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
