Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / LoadTextFile Method / LoadTextFile(Stream,Boolean) Method
Stream from which to load the sheet
Whether to load the data unformatted
Example


In This Topic
    LoadTextFile(Stream,Boolean) Method
    In This Topic
    Loads a stream that contains delimited data into the sheet.
    Syntax
    'Declaration
     
    Public Overloads Sub LoadTextFile( _
       ByVal stream As Stream, _
       ByVal unformatted As Boolean _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim stream As Stream
    Dim unformatted As Boolean
     
    instance.LoadTextFile(stream, unformatted)
    public void LoadTextFile( 
       Stream stream,
       bool unformatted
    )

    Parameters

    stream
    Stream from which to load the sheet
    unformatted
    Whether to load the data unformatted
    Remarks
    Set the unformatted parameter to true to bypass the IFormatter in the StyleInfo for the cell and load the data as unformatted data or false to load it as formatted.
    Example
    This example loads a string containing delimited text into the sheet.
    FarPoint.Web.Spread.SheetView sv;
    System.IO.Stream s;
    string fileName;
    fileName = "D:\\nums.txt";
    sv = FpSpread1.ActiveSheetView;
    s = System.IO.File.Open(fileName, IO.FileMode.Open);
    sv.LoadTextFile(s, true);
    
    Dim sv As FarPoint.Web.Spread.SheetView
    Dim s As System.IO.Stream
    Dim fileName As String
    fileName = "D:\nums.txt"
    sv = FpSpread1.ActiveSheetView
    s = System.IO.File.Open(fileName, IO.FileMode.Open)
    sv.LoadTextFile(s, True)
    See Also