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 stream As Stream
Dim textFileFlags As TextFileFlags
instance.LoadTextFile(stream, textFileFlags) |
Parameters
- stream
- Stream to which to load the text
- 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();
System.IO.Stream s;
ofd.Filter = "text files (*.txt)|*.txt";
ofd.FilterIndex = 2;
ofd.RestoreDirectory = true;
if (ofd.ShowDialog() == DialogResult.OK)
{
s = ofd.OpenFile();
fpSpread1.ActiveSheet.LoadTextFile(s, FarPoint.Win.Spread.TextFileFlags.Unformatted);
s.Close();
} |
| Visual Basic | Copy Code |
|---|
Dim s As System.IO.Stream
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.OpenFile
FpSpread1.ActiveSheet.LoadTextFile(s, FarPoint.Win.Spread.TextFileFlags.Unformatted)
s.Close()
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
