Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / LoadTextFile Method / LoadTextFile(Stream,Boolean,IncludeHeaders,Boolean,String,String,String) Method
Stream from which to load the sheet
Whether to load the data unformatted
Which header cells to load data from
Whether to load the data from the footer cells
Row delimiter string
Column delimiter string
Cell delimiter string

In This Topic
    LoadTextFile(Stream,Boolean,IncludeHeaders,Boolean,String,String,String) Method
    In This Topic
    Loads a stream that contains delimited data (and perhaps headers and footer) into the sheet with the specified delimiters.
    Public Overloads Sub LoadTextFile( _
       ByVal stream As Stream, _
       ByVal unformatted As Boolean, _
       ByVal includeHeaders As IncludeHeaders, _
       ByVal includeFooter As Boolean, _
       ByVal rowDelimiter As String, _
       ByVal columnDelimiter As String, _
       ByVal cellDelimiter As String _
    Dim instance As SheetView
    Dim stream As Stream
    Dim unformatted As Boolean
    Dim includeHeaders As IncludeHeaders
    Dim includeFooter As Boolean
    Dim rowDelimiter As String
    Dim columnDelimiter As String
    Dim cellDelimiter As String
    instance.LoadTextFile(stream, unformatted, includeHeaders, includeFooter, rowDelimiter, columnDelimiter, cellDelimiter)
    public void LoadTextFile( 
       Stream stream,
       bool unformatted,
       IncludeHeaders includeHeaders,
       bool includeFooter,
       string rowDelimiter,
       string columnDelimiter,
       string cellDelimiter


    Stream from which to load the sheet
    Whether to load the data unformatted
    Which header cells to load data from
    Whether to load the data from the footer cells
    Row delimiter string
    Column delimiter string
    Cell delimiter string
    This example uses the LoadTextFile method.
    System.IO.Stream s;
    s = System.IO.File.Open("C:\\controls\\textfile1.txt", System.IO.FileMode.Open);
    FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^");
    //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "%", "^");
    //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^", System.Text.Encoding.ASCII);
    //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "%", "^", System.Text.Encoding.ASCII);
    //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^", System.Text.Encoding.ASCII, false);
    //FpSpread1.Sheets[0].LoadTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "%", "^", System.Text.Encoding.ASCII, false);
    Dim s As System.IO.Stream
    s = System.IO.File.Open("C:\\controls\\textfile1.txt", System.IO.FileMode.Open)
    FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^")
    'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "%", "^")
    'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^", System.Text.Encoding.ASCII)
    'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "%", "^", System.Text.Encoding.ASCII)
    'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^", System.Text.Encoding.ASCII, False)
    'FpSpread1.Sheets(0).LoadTextFile(s, True, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "%", "^", System.Text.Encoding.ASCII, False)
    See Also