Saves the range of cells (and may include headers) as delimited text to a stream as specified.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim stream As Stream
Dim unformatted As Boolean
Dim includeHeaders As IncludeHeaders
Dim rowDelimiter As String
Dim columnDelimiter As String
Dim cellDelimiter As String
Dim value As Boolean
value = instance.SaveTextFile(stream, unformatted, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter) |
Parameters
- stream
- Stream to which to save the sheet
- unformatted
- Whether to save the data unformatted
- includeHeaders
- Which header cells from which to save data
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
Example
This example uses the SaveTextFile method.
C# | Copy Code |
---|
FpSpread1.Sheets[0].RowCount = 6;
FpSpread1.Sheets[0].ColumnCount = 6;
FpSpread1.Sheets[0].Cells[0, 0, 5, 5].Text = "test";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "Custom";
FpSpread1.Sheets[0].Cells[0, 0].BackColor = System.Drawing.Color.CadetBlue;
protected void Button1_Click(object sender, EventArgs e)
{
System.IO.Stream s;
string fileName;
fileName = "c:\\controls\\textfile1.txt";
s = System.IO.File.Open(fileName, System.IO.FileMode.OpenOrCreate);
FpSpread1.Sheets[0].SaveTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^");
//FpSpread1.Sheets[0].SaveTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, false, "#", "%", "^");
s.Close();
} |
VB.NET | Copy Code |
---|
FpSpread1.Sheets(0).RowCount = 6
FpSpread1.Sheets(0).ColumnCount = 6
FpSpread1.Sheets(0).Cells(0, 0, 5, 5).Text = "test"
FpSpread1.Sheets(0).ColumnHeader.Cells(0, 0).Text = "Custom"
FpSpread1.Sheets(0).Cells(0, 0).BackColor = Drawing.Color.CadetBlue
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim s As System.IO.Stream
Dim fileName As String
fileName = "c:\controls\textfile1.txt"
s = System.IO.File.Open(fileName, System.IO.FileMode.OpenOrCreate)
FpSpread1.Sheets(0).SaveTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "%", "^")
'FpSpread1.Sheets(0).SaveTextFile(s, true, FarPoint.Web.Spread.Model.IncludeHeaders.None, False, "#", "%", "^")
s.Close()
End Sub |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also