LoadTextFile(Stream,Boolean) Method

Loads a stream that contains delimited data into the sheet.

Syntax

Visual Basic
C#

'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);

Visual Basic

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)

Reference

SheetView Class
SheetView Members
Overload List
SaveTextFile Method
SaveTextFileRange Method

User-Task Documentation

Opening a Text File