Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / TextFileSaveFlags Enumeration
Example Example


In This Topic
    TextFileSaveFlags Enumeration
    In This Topic
    Specifies the export flags.
    Syntax
    'Declaration
     
    <FlagsAttribute()>
    Public Enum TextFileSaveFlags 
       Inherits System.Enum
    'Usage
     
    Dim instance As TextFileSaveFlags
    [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