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.
    Public Enum IncludeHeaders 
       Inherits System.Enum
    Dim instance As IncludeHeaders
    public enum IncludeHeaders : System.Enum 
    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
    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))
    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");
    Inheritance Hierarchy


    See Also