SaveTextFile(Stream,Boolean) Method

Saves the sheet as delimited text to a stream as specified.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function SaveTextFile( _
   ByVal stream As Stream, _
   ByVal unformatted As Boolean _
) As Boolean

'Usage
 
Dim instance As SheetView
Dim stream As Stream
Dim unformatted As Boolean
Dim value As Boolean
 
value = instance.SaveTextFile(stream, unformatted)

public bool SaveTextFile( 
   Stream stream,
   bool unformatted
)

Parameters

stream: Stream to which to save the sheet
unformatted: Whether to save the data unformatted

Return Value

Boolean: true if successful; false otherwise

Remarks

Set the unformatted parameter to true to bypass the IFormatter in the StyleInfo for the cell and save the data as unformatted data or false to save it as formatted.

Example

This example saves the sheet to a text file.

private void Button1Click(object sender, System.EventArgs e)
{
FarPoint.Web.Spread.SheetView sv;
System.IO.Stream s;
string fileName;
sv = FpSpread1.ActiveSheetView;
fileName = "D:\\mine.txt";
s = System.IO.File.Open(fileName, System.IO.FileMode.OpenOrCreate);
sv.SaveTextFile(s, true);
s.Close();
}

Visual Basic

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sv As FarPoint.Web.Spread.SheetView
Dim s As System.IO.Stream
Dim fileName As String
sv = FpSpread1.ActiveSheetView
fileName = "D:\mine.txt"
s = System.IO.File.Open(fileName, System.IO.FileMode.OpenOrCreate)
sv.SaveTextFile(s, True)
s.Close()
End Sub

Reference

SheetView Class
SheetView Members
Overload List