Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / ExcelSaveFlags Enumeration
Example Example


In This Topic
    ExcelSaveFlags Enumeration
    In This Topic
    Specifies what part of the spreadsheet to export to an Excel-compatible file.
    Syntax
    'Declaration
     
    <FlagsAttribute()>
    Public Enum ExcelSaveFlags 
       Inherits System.Enum
    'Usage
     
    Dim instance As ExcelSaveFlags
    [Flags()]
    public enum ExcelSaveFlags : System.Enum 
    Members
    MemberDescription
    AutoRowHeightThe default row height is not saved. Excel automatically determines row heights based on the largest font that is set in each row.
    DataOnlySaves only the data to the Excel-compatible file.
    NoFlagsSetSaves the spreadsheet to the Excel-compatible file with no special options.
    NoFormulasSaves the displayed data, but not the formulas, to the Excel-compatible file.
    SaveAsFilteredSaves the filtered row results to the Excel-compatible file.
    SaveAsViewedSaves the spreadsheet as viewed to the Excel-compatible file.
    SaveBothCustomRowAndColumnHeadersSaves both the custom row headers and the custom column headers to the Excel-compatible file.
    SaveCustomColumnHeadersSaves the custom column headers to the Excel-compatible file.
    SaveCustomRowHeadersSaves the custom row headers to the Excel-compatible file.
    Example
    This example uses the ExcelSaveFlags enumeration.
    gcSpreadSheet1.Sheets[0].ColumnHeader.Columns[0].Label = "Label";
    gcSpreadSheet1.Sheets[0].Cells[0, 0, 2, 2].Text = "test";           
    gcSpreadSheet1.Invalidate();
    
     private void button1_Click(object sender, RoutedEventArgs e)
            {
    //gcSpreadSheet1.SaveExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX);
    //gcSpreadSheet1.SaveExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "1NaMe5");
    //gcSpreadSheet1.SaveExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders);
    gcSpreadSheet1.SaveExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders, "1NaMe5");
    gcSpreadSheet1.Invalidate();
            }
    GcSpreadSheet1.Sheets(0).ColumnHeader.Columns(0).Label = "Label"
    GcSpreadSheet1.Sheets(0).Cells(0, 0, 2, 2).Text = "test"           
    GcSpreadSheet1.Invalidate()
    
    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
    GcSpreadSheet1.SaveExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX)
    'GcSpreadSheet1.SaveExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "1NaMe5")
    'GcSpreadSheet1.SaveExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders)
    'GcSpreadSheet1.SaveExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders, "1NaMe5")
    'GcSpreadSheet1.Invalidate()
    End Sub
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags

    See Also