Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / LoadTextFile Method / LoadTextFile(Stream,TextFileFlags,IncludeHeaders,String,String,String,Encoding) Method
Stream to which to load the text of the sheet
Specifies how to process the data when loading from a text file
Whether to export headers as data
Row delimiter string
Column delimiter string
Cell delimiter string
Encoding
Example


In This Topic
    LoadTextFile(Stream,TextFileFlags,IncludeHeaders,String,String,String,Encoding) 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, _
       ByVal includeHeaders As IncludeHeaders, _
       ByVal rowDelimiter As String, _
       ByVal columnDelimiter As String, _
       ByVal cellDelimiter As String, _
       ByVal encoding As Encoding _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim stream As Stream
    Dim textFileFlags As TextFileFlags
    Dim includeHeaders As IncludeHeaders
    Dim rowDelimiter As String
    Dim columnDelimiter As String
    Dim cellDelimiter As String
    Dim encoding As Encoding
     
    instance.LoadTextFile(stream, textFileFlags, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, encoding)

    Parameters

    stream
    Stream to which to load the text of the sheet
    textFileFlags
    Specifies how to process the data when loading from a text file
    includeHeaders
    Whether to export headers as data
    rowDelimiter
    Row delimiter string
    columnDelimiter
    Column delimiter string
    cellDelimiter
    Cell delimiter string
    encoding
    Encoding
    Exceptions
    ExceptionDescription
    Cell delimiter cannot be contained in a row or column delimiter
    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, FarPoint.Win.Spread.Model.IncludeHeaders.None, "\n", ",", "", System.Text.Encoding.ASCII);
    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, FarPoint.Win.Spread.Model.IncludeHeaders.None, Chr(10), ",", "", System.Text.Encoding.ASCII)
    s.Close()
    End If
    See Also