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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also