ExcelSaveFlags Enumeration

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

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ExcelSaveFlags 
   Inherits System.Enum

'Usage
 
Dim instance As ExcelSaveFlags

public enum ExcelSaveFlags : System.Enum

Members

Member	Description
AutoRowHeight	[4096] The default row height is not saved. Excel will automatically determine row heights based on the largest font that is set in each row.
ComboDataOnly	[8192] Saves the displayed data in the combobox celltype, does not save the items in the combo box.
DataOnly	[32] Saves only the data to the Excel-compatible file.
DocumentCaching	[2048] Keeps Excel data that was previously loaded from the files (e.g. VBA, Macro).
NoFlagsSet	[0] Saves the spreadsheet to the Excel-compatible file with no special options.
NoFormulas	[1] Saves the displayed data but not the formulas to the Excel-compatible file.
NoNotes	[1024] Saves the displayed data and formatting, but not the notes.
SaveAlternatingRowStyles	[64] Saves the appearance settings of alternating rows to the Excel-compatible file.
SaveAsFiltered	[8] Saves the results of rows after filtering them to the Excel-compatible file.
SaveAsViewed	[136] Saves the spreadsheet as viewed to the Excel-compatible file.
SaveBothCustomRowAndColumnHeaders	[6] Saves both the custom row headers and the custom column headers to the Excel-compatible file.
SaveCustomColumnHeaders	[4] Saves the custom column headers to the Excel-compatible file.
SaveCustomRowHeaders	[2] Saves the custom row headers to the Excel-compatible file.
UseCustomPaletteForColorApproximations	[256] Uses a custom color palette, and uses it for color approximations if there are more than 56 colors set into Spread.
UseDefaultColorPalette	[512] Uses the default color palette.
UseOOXMLFormat	[16] Saves the spreadsheet to an Excel 2007 (OfficeOpen XML) format.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Excel.ExcelSaveFlags

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

FarPoint.Excel Namespace