TextFileSaveFlags Enumeration

Specifies the export flags.

Syntax

Visual Basic
C#

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

'Usage
 
Dim instance As TextFileSaveFlags

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

Members

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.

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)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Text File (.txt)|*.txt";
bool? useClick = saveFileDialog.ShowDialog();
if (useClick == true)
{
var stream = saveFileDialog.OpenFile();
gcSpreadSheet1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.AsViewed , "\r", ",", "", System.Text.Encoding.UTF8);
//gcSpreadSheet1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.AsViewed , "\r", ",", "");
stream.Dispose();
}

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 saveFileDialog = New SaveFileDialog()
saveFileDialog.Filter = "Text File(.txt)|*.txt"
Dim useClick As Boolean = saveFileDialog.ShowDialog()
If (useClick = True) Then
    Dim stream = saveFileDialog.OpenFile()
GcSpreadSheet1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.AsViewed, ChrW(13), ",", "", System.Text.Encoding.UTF8)
'GcSpreadSheet1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.AsViewed, ChrW(13), ",", "")
GcSpreadSheet1.Invalidate()
End If
End Sub

Inheritance Hierarchy

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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace