Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / LoadTextFile Method / LoadTextFile(Stream,TextFileFlags) Method
Stream to which to load the text
Specifies how to process the data when loading from a text file
Example


In This Topic
    LoadTextFile(Stream,TextFileFlags) Method
    In This Topic
    Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.
    Syntax
    '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();
    }
    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
    See Also