Spread for ASP.NET 9.0 Product Documentation
ExcelSaveFlags Enumeration


Specifies what part of the spreadsheet to export to an Excel-compatible file.
Syntax
'Declaration
 
Public Enum ExcelSaveFlags 
   Inherits System.Enum
'Usage
 
Dim instance As ExcelSaveFlags
public enum ExcelSaveFlags : System.Enum 
Members
MemberDescription
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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FarPoint.Excel Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.