Spread Windows Forms 6.0 Product Documentation
IncludeHeaders Enumeration
Example  See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace : IncludeHeaders Enumeration

Glossary Item Box

Specifies which spreadsheet headers should be included.


Visual Basic (Declaration) 
Public Enum IncludeHeaders 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As IncludeHeaders
public enum IncludeHeaders : System.Enum 


BothCustomOnlyIncludes both column and row headers, custom headers only
ColumnHeadersCustomOnlyIncludes only column headers, custom headers only
NoneIncludes neither column nor row headers
RowHeadersCustomOnlyIncludes only row headers, custom headers only


This example saves the active sheet to a text file and includes the column headers.
Visual BasicCopy Code
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))
End If
C#Copy Code
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");

Inheritance Hierarchy



Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.