ExcelSaveFlags Enumeration

Specifies what part of the spreadsheet to export to an Excel-compatible file.

Syntax

Visual Basic
C#

'Declaration
 
<System.FlagsAttribute()>
Public Enum ExcelSaveFlags 
   Inherits System.Enum

'Usage
 
Dim instance As ExcelSaveFlags

[System.Flags()]
public enum ExcelSaveFlags : System.Enum

Members

Member	Description
AutoRowHeight	The default row height is not saved. Excel automatically determines row heights based on the largest font that is set in each row.
DataOnly	Saves only the data to the Excel-compatible file.
NoFlagsSet	Saves the spreadsheet to the Excel-compatible file with no special options.
NoFormulas	Saves the displayed data, but not the formulas, to the Excel-compatible file.
SaveAsFiltered	Saves the filtered row results to the Excel-compatible file.
SaveAsViewed	Saves the spreadsheet as viewed to the Excel-compatible file.
SaveBothCustomRowAndColumnHeaders	Saves both the custom row headers and the custom column headers to the Excel-compatible file.
SaveCustomColumnHeaders	Saves the custom column headers to the Excel-compatible file.
SaveCustomRowHeaders	Saves 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();
        }

VB.NET

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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace