Spread WPF Documentation
TextFileSaveFlags Enumeration
Example Example 


GrapeCity.Windows.SpreadSheet.Data Namespace : TextFileSaveFlags Enumeration
Specifies the export flags.
Syntax
'Declaration
 
<System.FlagsAttribute()>
Public Enum TextFileSaveFlags 
   Inherits System.Enum
'Usage
 
Dim instance As TextFileSaveFlags
[System.Flags()]
public enum TextFileSaveFlags : System.Enum 
Members
MemberDescription
AsViewedExports the cell text area including the visible rows and columns of filtered-in rows.
ExportFormulaExports formulas.
IncludeColumnHeaderIncludes column headers.
IncludeRowHeaderIncludes row headers.
NoneExports with no special options.
UnFormattedExports without formatting.
Example
This example uses the TextFileSaveFlags enumeration.
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", ",", "");
}
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
Inheritance Hierarchy

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

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace