Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / IncludeHeaders Enumeration
Example Example


In This Topic
    IncludeHeaders Enumeration
    In This Topic
    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
    BothCustomOnly Includes both custom column and custom row headers, custom headers only
    ColumnHeadersCustomOnly Includes only custom column headers
    None Includes neither column nor row headers
    RowHeadersCustomOnly Includes 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

    See Also