TextFileSaveFlags Enumeration

Visual Basic
C#

'Declaration
 
<System.FlagsAttribute()>
Public Enum TextFileSaveFlags 
   Inherits System.Enum

'Usage
 
Dim instance As TextFileSaveFlags

[System.Flags()]
public enum TextFileSaveFlags : System.Enum

Member	Description
AsViewed	Exports the cell text area including the visible rows and columns of filtered-in rows.
ExportFormula	Exports formulas.
IncludeColumnHeader	Includes column headers.
IncludeRowHeader	Includes row headers.
None	Exports with no special options.
UnFormatted	Exports without formatting.

This example uses the TextFileSaveFlags enumeration.

C#

gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = "test";
gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = "test1";
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = "test2";
       
private void button1_Click(object sender, RoutedEventArgs e)
{
string fileName;
fileName = "c:\\zipfile\\savespreadstream.csv";
System.IO.Stream stream;
stream = System.IO.File.Create(fileName);
gcSpreadSheet1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.AsViewed , "\r", ",", "", System.Text.Encoding.ASCII);
//gcSpreadSheet1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.AsViewed , "\r", ",", "");
}

VB.NET

GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = "test"
GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = "test1"
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = "test2"

Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
Dim fileName As String
fileName = "c:\zipfile\savespreadstream.csv"
Dim stream As System.IO.Stream
stream = System.IO.File.Create(fileName, System.IO.FileMode.Create)
GcSpreadSheet1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.AsViewed, Chr(13), ",", "", System.Text.Encoding.ASCII)
'GcSpreadSheet1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.AsViewed, Chr(13), ",", "")
GcSpreadSheet1.Invalidate()
End Sub

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace