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.

Syntax

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

Members

MemberDescription
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

Example

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))
    s.Close()
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");
        s.Close();
    }    
}

Inheritance Hierarchy

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

Requirements

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.