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


In This Topic
    LoadTextFile(String,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 fileName As String, _
       ByVal textFileFlags As TextFileFlags _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim fileName As String
    Dim textFileFlags As TextFileFlags
     
    instance.LoadTextFile(fileName, textFileFlags)
    public void LoadTextFile( 
       string fileName,
       TextFileFlags 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.
    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);
    }
    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
    See Also