Spread Windows Forms 9.0 Product Documentation
IncludeHeaders Enumeration
Example Example 


Specifies which spreadsheet headers should be included.
Syntax
'Declaration
 
Public Enum IncludeHeaders 
   Inherits System.Enum
'Usage
 
Dim instance As IncludeHeaders
public enum IncludeHeaders : System.Enum 
Members
MemberDescription
BothCustomOnlyIncludes both custom column and custom row headers, custom headers only
ColumnHeadersCustomOnlyIncludes only custom column headers
NoneIncludes neither column nor row headers
RowHeadersCustomOnlyIncludes only custom row headers
Example
This example saves the active sheet to a text file and includes the column headers.
Dim sd As New SaveFileDialog()
Dim s As System.IO.Stream
sd.Filter = "text files (*.txt)|*.txt"
sd.FilterIndex = 2
sd.RestoreDirectory = True
If sd.ShowDialog() = DialogResult.OK Then
    s = sd.OpenFile
    FpSpread1.ActiveSheet.SaveTextFile(s, FarPoint.Win.Spread.TextFileFlags.None, FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, Chr(9), Chr(10), Chr(9))
    s.Close()
End If
private void menuItem2_Click(object sender, System.EventArgs e)
{
    SaveFileDialog sfd = new SaveFileDialog();
    System.IO.Stream s;
    sfd.Filter = "text files (*.txt)|*.txt";
    sfd.FilterIndex = 2;
    sfd.RestoreDirectory = true;
    if (sfd.ShowDialog() == DialogResult.OK) 
    {
        s = sfd.OpenFile();
        fpSpread1.ActiveSheet.SaveTextFile(s, FarPoint.Win.Spread.TextFileFlags.None, FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, "\t","\n", "\t");
        s.Close();
    }    
}
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.Model.IncludeHeaders

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FarPoint.Win.Spread.Model Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.