LoadTextFile(Stream,TextFileFlags) Method

Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub LoadTextFile( _
   ByVal stream As Stream, _
   ByVal textFileFlags As TextFileFlags _
)

'Usage
 
Dim instance As SheetView
Dim stream As Stream
Dim textFileFlags As TextFileFlags
 
instance.LoadTextFile(stream, textFileFlags)

public void LoadTextFile( 
   Stream stream,
   TextFileFlags 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.

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

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

Reference

SheetView Class
SheetView Members
Overload List