Spread Silverlight Documentation
TextFileSaveFlags Enumeration
Example Example 


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)
{
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();
}
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

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.