Aspose::Cells Namespace Reference

Namespaces

 Drawing
 
 
 Pivot
 
 Properties
 
 Tables
 

Classes

class  CellsException
 
class  Factory
 If you need new an object in Client-Side code, you can call the following static method to create related object. More...
 
class  IAboveAverage
 Describe the AboveAverage conditional formatting rule. This conditional formatting rule highlights cells that are above or below the average for all values in the range. More...
 
class  IAutoFilter
 Represents auto filtering for the specified worksheet. More...
 
class  IBorder
 Encapsulates the object that represents the cell border. More...
 
class  IBorderCollection
 Encapsulates a collection of IBorder objects. More...
 
class  ICalculationOptions
 Represents options for calculation. More...
 
class  ICell
 Encapsulates the object that represents a single Workbook cell. More...
 
class  ICellArea
 Represent an area of cells. More...
 
class  ICells
 Encapsulates a collection of ICell objects. More...
 
class  ICellsColor
 Represents all types of color. More...
 
class  ICellsHelper
 Provides helper functions. More...
 
class  IColorScale
 Describe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells. More...
 
class  IColumn
 Represents a single column in a worksheet. More...
 
class  IColumnCollection
 Collects the IColumn objects that represent the individual columns in a worksheet. More...
 
class  IConditionalFormattingCollection
 Encapsulates a collection of FormatCondition objects. More...
 
class  IConditionalFormattingIcon
 Represents the custom icon of conditional formatting rule. More...
 
class  IConditionalFormattingIconCollection
 Represents a collection of IConditionalFormattingIcon objects. More...
 
class  IConditionalFormattingResult
 Represents the result of conditional formatting which applies to a cell. More...
 
class  IConditionalFormattingValue
 Describes the values of the interpolation points in a gradient scale, dataBar or iconSet. More...
 
class  IConditionalFormattingValueCollection
 Describes a collection of CFValueObject. Use only for icon sets. More...
 
class  ICopyOptions
 Represents the copy options. More...
 
class  ICustomFunction
 
class  IDataBar
 Describe the DataBar conditional formatting rule. This conditional formatting rule displays a gradated data bar in the range of cells. More...
 
class  IDataBarBorder
 Represents the border of the data bars specified by a conditional formatting rule. More...
 
class  IDataSorter
 Summary description for DataSorter. More...
 
class  IErrorCheckOption
 Error check setting applied on certain ranges. More...
 
class  IErrorCheckOptionCollection
 Represents all error check option. More...
 
class  IExternalLink
 Represents an external link in a workbook. More...
 
class  IExternalLinkCollection
 Represents external links collection in a workbook. More...
 
class  IFileFormatInfo
 Contains data returned by IFileFormatUtil file format detection methods. More...
 
class  IFileFormatUtil
 Provides utility methods for working with file formats, such as detecting file format or converting file extensions to/from file format enums. More...
 
class  IFindOptions
 Represents find options. More...
 
class  IFont
 Encapsulates the font object used in a spreadsheet. More...
 
class  IFontSetting
 Represents a range of characters within the cell text. More...
 
class  IFormatCondition
 Represents conditional formatting condition. More...
 
class  IFormatConditionCollection
 Represents conditional formatting. The FormatConditions can contain up to three conditional formats. More...
 
class  IHorizontalPageBreak
 Encapsulates the object that represents a horizontal page break. More...
 
class  IHorizontalPageBreakCollection
 Encapsulates a collection of IHorizontalPageBreak objects. More...
 
class  IHyperlink
 Encapsulates the object that represents a hyperlink. More...
 
class  IHyperlinkCollection
 Encapsulates a collection of IHyperlink objects. More...
 
class  IIconSet
 Describe the IconSet conditional formatting rule. This conditional formatting rule applies icons to cells according to their values. More...
 
class  ILightCellsDataHandler
 Represents cells data handler for reading large spreadsheet files in light weight mode. More...
 
class  ILoadDataOption
 The load data options. More...
 
class  ILoadOptions
 Represents the options of loading the file. More...
 
class  IName
 Represents a defined name for a range of cells. More...
 
class  INameCollection
 Represents a collection of all the IName objects in the spreadsheet. More...
 
class  INegativeBarFormat
 Represents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule. More...
 
class  IOoxmlSaveOptions
 Represents the options of saving office open xml file. More...
 
class  IOutline
 Represents an outline on a worksheet. More...
 
class  IPageSetup
 Encapsulates the object that represents the page setup description. The IPageSetup object contains all page setup options. More...
 
class  IPaneCollection
 Represents all Pane objects shown in the specified window. More...
 
class  IPasteOptions
 Represents the paste special options. More...
 
class  IProtectedRange
 A specified range to be allowed to edit when the sheet protection is ON. More...
 
class  IProtectedRangeCollection
 Encapsulates a collection of IProtectedRange objects. More...
 
class  IProtection
 Represents the various types of protection options available for a worksheet. Only used in ExcelXP and above version. More...
 
class  IRange
 Encapsulates the object that represents a range of cells within a spreadsheet. More...
 
class  IRangeCollection
 Encapsulates a collection of IRange objects. More...
 
class  IReferredArea
 Represents a referred object by the formula. More...
 
class  IReferredAreaCollection
 Represents all referred cells and areas. More...
 
class  IReplaceOptions
 Represent the replace options. More...
 
class  IRow
 Represents a single row in a worksheet. More...
 
class  IRowCollection
 Collects the IRow objects that represent the individual rows in a worksheet. More...
 
class  ISaveOptions
 Represents all save options More...
 
class  IScenario
 Represents an individual scenario. More...
 
class  IScenarioCollection
 Represents the list of scenarios. More...
 
class  IScenarioInputCell
 Represents input cell for the scenario. More...
 
class  IScenarioInputCellCollection
 Represents the list of the scenario's input cells. More...
 
class  ISpreadsheetML2003SaveOptions
 Represents the options for saving Excel 2003 spread ml file. More...
 
class  IStyle
 Represents display style of excel document, such as font, color, alignment, border, etc. More...
 
class  IStyleCollection
 Encapsulates a collection of IStyle objects. More...
 
class  IStyleFlag
 Represents flags which indicates applied formatting properties. More...
 
class  IThemeColor
 Represents a theme color. More...
 
class  ITop10
 Describe the Top10 conditional formatting rule. This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified. More...
 
class  ITxtLoadOptions
 Represents the options for loading text file. More...
 
class  ITxtSaveOptions
 Repesents the save options for csv/tab delimitered/other text format. More...
 
class  IValidation
 Represents data validation settings. More...
 
class  IValidationCollection
 Represents data validation collection. More...
 
class  IVerticalPageBreak
 Encapsulates the object that represents a vertical page break. More...
 
class  IVerticalPageBreakCollection
 Encapsulates a collection of IVerticalPageBreak objects. More...
 
class  IWorkbook
 Represents a root object to create an Excel spreadsheet. More...
 
class  IWorkbookSettings
 Represents all settings of the workbook. More...
 
class  IWorksheet
 Encapsulates the object that represents a single worksheet. More...
 
class  IWorksheetCollection
 Encapsulates a collection of IWorksheet objects. More...
 
class  IWriteProtection
 Specifies write protection settings for a workbook. More...
 
class  IXlsSaveOptions
 Represents the save options for the Excel 97-2003 file format: xls and xlt. More...
 
class  License
 

Enumerations

enum  BackgroundType {
  BackgroundType_DiagonalCrosshatch = 9, BackgroundType_DiagonalStripe = 8, BackgroundType_Gray6 = 18, BackgroundType_Gray12 = 17,
  BackgroundType_Gray25 = 4, BackgroundType_Gray50 = 2, BackgroundType_Gray75 = 3, BackgroundType_HorizontalStripe = 5,
  BackgroundType_None = 0, BackgroundType_ReverseDiagonalStripe = 7, BackgroundType_Solid = 1, BackgroundType_ThickDiagonalCrosshatch = 10,
  BackgroundType_ThinDiagonalCrosshatch = 16, BackgroundType_ThinDiagonalStripe = 14, BackgroundType_ThinHorizontalCrosshatch = 15, BackgroundType_ThinHorizontalStripe = 11,
  BackgroundType_ThinReverseDiagonalStripe = 13, BackgroundType_ThinVerticalStripe = 12, BackgroundType_VerticalStripe = 6
}
 Enumerates cell background pattern types. More...
 
enum  BorderType {
  BorderType_BottomBorder = 8, BorderType_DiagonalDown = 0x10, BorderType_DiagonalUp = 0x20, BorderType_LeftBorder = 1,
  BorderType_RightBorder = 2, BorderType_TopBorder = 4, BorderType_Horizontal = 0x80, BorderType_Vertical = 0x40
}
 Enumerates the border line and diagonal line types. More...
 
enum  BuiltinStyleType {
  BuiltinStyleType_TwentyPercentAccent1 = 30, BuiltinStyleType_TwentyPercentAccent2 = 34, BuiltinStyleType_TwentyPercentAccent3 = 38, BuiltinStyleType_TwentyPercentAccent4 = 42,
  BuiltinStyleType_TwentyPercentAccent5 = 46, BuiltinStyleType_TwentyPercentAccent6 = 50, BuiltinStyleType_FortyPercentAccent1 = 31, BuiltinStyleType_FortyPercentAccent2 = 35,
  BuiltinStyleType_FortyPercentAccent3 = 39, BuiltinStyleType_FortyPercentAccent4 = 43, BuiltinStyleType_FortyPercentAccent5 = 47, BuiltinStyleType_FortyPercentAccent6 = 51,
  BuiltinStyleType_SixtyPercentAccent1 = 32, BuiltinStyleType_SixtyPercentAccent2 = 36, BuiltinStyleType_SixtyPercentAccent3 = 40, BuiltinStyleType_SixtyPercentAccent4 = 44,
  BuiltinStyleType_SixtyPercentAccent5 = 48, BuiltinStyleType_SixtyPercentAccent6 = 52, BuiltinStyleType_Accent1 = 29, BuiltinStyleType_Accent2 = 33,
  BuiltinStyleType_Accent3 = 37, BuiltinStyleType_Accent4 = 41, BuiltinStyleType_Accent5 = 45, BuiltinStyleType_Accent6 = 49,
  BuiltinStyleType_Bad = 27, BuiltinStyleType_Calculation = 22, BuiltinStyleType_CheckCell = 23, BuiltinStyleType_Comma = 3,
  BuiltinStyleType_Comma1 = 6, BuiltinStyleType_Currency = 4, BuiltinStyleType_Currency1 = 7, BuiltinStyleType_ExplanatoryText = 53,
  BuiltinStyleType_Good = 26, BuiltinStyleType_Header1 = 16, BuiltinStyleType_Header2 = 17, BuiltinStyleType_Header3 = 18,
  BuiltinStyleType_Header4 = 19, BuiltinStyleType_Hyperlink = 8, BuiltinStyleType_FollowedHyperlink = 9, BuiltinStyleType_Input = 20,
  BuiltinStyleType_LinkedCell = 24, BuiltinStyleType_Neutral = 28, BuiltinStyleType_Normal = 0, BuiltinStyleType_Note = 10,
  BuiltinStyleType_Output = 21, BuiltinStyleType_Percent = 5, BuiltinStyleType_Title = 15, BuiltinStyleType_Total = 25,
  BuiltinStyleType_WarningText = 11, BuiltinStyleType_RowLevel = 1, BuiltinStyleType_ColumnLevel = 2
}
 Represents all built style type. More...
 
enum  CalcModeType { CalcModeType_Automatic, CalcModeType_AutomaticExceptTable, CalcModeType_Manual }
 Represents the mode type of calculating formulas. More...
 
enum  CalculationPrecisionStrategy { CalculationPrecisionStrategy_None, CalculationPrecisionStrategy_Round, CalculationPrecisionStrategy_Decimal }
 Enumerates strategies for handling calculation precision. Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calcualted as the expected result. Such as formula "=-0.45+0.43+0.02", when calcuating operands by '+' operator directly, the result is not zero. For such kind of precision issue, some special strategies may give the expected result. More...
 
enum  CellBorderType {
  CellBorderType_DashDot = 9, CellBorderType_DashDotDot = 11, CellBorderType_Dashed = 3, CellBorderType_Dotted = 4,
  CellBorderType_Double = 6, CellBorderType_Hair = 7, CellBorderType_MediumDashDot = 10, CellBorderType_MediumDashDotDot = 12,
  CellBorderType_MediumDashed = 8, CellBorderType_None = 0, CellBorderType_Medium = 2, CellBorderType_SlantedDashDot = 13,
  CellBorderType_Thick = 5, CellBorderType_Thin = 1
}
 Enumerates a cell's border type. More...
 
enum  CellValueFormatStrategy { CellValueFormatStrategy_None, CellValueFormatStrategy_CellStyle, CellValueFormatStrategy_DisplayStyle }
 Specifies how to apply style for the value of the cell. More...
 
enum  CellValueType {
  CellValueType_IsBool, CellValueType_IsDateTime, CellValueType_IsError, CellValueType_IsNull,
  CellValueType_IsNumeric, CellValueType_IsString, CellValueType_IsUnknown
}
 Specifies a cell value type. More...
 
enum  ColorType {
  ColorType_Automatic, ColorType_AutomaticIndex, ColorType_RGB, ColorType_IndexedColor,
  ColorType_Theme
}
 Represents all color type More...
 
enum  ConsolidationFunction {
  ConsolidationFunction_Sum = 0, ConsolidationFunction_Count = 1, ConsolidationFunction_Average = 2, ConsolidationFunction_Max = 3,
  ConsolidationFunction_Min = 4, ConsolidationFunction_Product = 5, ConsolidationFunction_CountNums = 6, ConsolidationFunction_StdDev = 7,
  ConsolidationFunction_StdDevp = 8, ConsolidationFunction_Var = 9, ConsolidationFunction_Varp = 10, ConsolidationFunction_DistinctCount
}
 Represents consolidation function. More...
 
enum  CountryCode {
  CountryCode_Default = 0, CountryCode_USA = 1, CountryCode_Canada = 2, CountryCode_LatinAmeric = 3,
  CountryCode_Russia = 7, CountryCode_Egypt = 20, CountryCode_Greece = 30, CountryCode_Netherlands = 31,
  CountryCode_Belgium = 32, CountryCode_France = 33, CountryCode_Spain = 34, CountryCode_Hungary = 36,
  CountryCode_Italy = 39, CountryCode_Switzerland = 41, CountryCode_Austria = 43, CountryCode_UnitedKingdom = 44,
  CountryCode_Denmark = 45, CountryCode_Sweden = 46, CountryCode_Norway = 47, CountryCode_Poland = 48,
  CountryCode_Germany = 49, CountryCode_Mexico = 52, CountryCode_Brazil = 55, CountryCode_Australia = 61,
  CountryCode_NewZealand = 64, CountryCode_Thailand = 66, CountryCode_Japan = 81, CountryCode_SouthKorea = 82,
  CountryCode_VietNam = 84, CountryCode_China = 86, CountryCode_Turkey = 90, CountryCode_India = 91,
  CountryCode_Algeria = 213, CountryCode_Morocco = 216, CountryCode_Libya = 218, CountryCode_Portugal = 351,
  CountryCode_Iceland = 354, CountryCode_Finland = 358, CountryCode_Czech = 420, CountryCode_Taiwan = 886,
  CountryCode_Lebanon = 961, CountryCode_Jordan = 962, CountryCode_Syria = 963, CountryCode_Iraq = 964,
  CountryCode_Kuwait = 965, CountryCode_Saudi = 966, CountryCode_UnitedArabEmirates = 971, CountryCode_Israel = 972,
  CountryCode_Qatar = 974, CountryCode_Iran = 981
}
 Represents Excel country identifiers. More...
 
enum  DataBarAxisPosition {
  DataBarAxisPosition_DataBarAxisAutomatic = 0, DataBarAxisPosition_DataBarAxisMidpoint = 1, DataBarAxisPosition_DataBarAxisNone = 2, DataBarAxisPosition_Automatic = 0,
  DataBarAxisPosition_Midpoint = 1, DataBarAxisPosition_None = 2
}
 Specifies the axis position for a range of cells with conditional formatting as data bars. More...
 
enum  DataBarBorderType { DataBarBorderType_DataBarBorderNone = 0, DataBarBorderType_DataBarBorderSolid = 1, DataBarBorderType_None = 0, DataBarBorderType_Solid = 1 }
 Specifies the border type of a data bar. More...
 
enum  DataBarFillType { DataBarFillType_DataBarFillSolid = 0, DataBarFillType_DataBarFillGradient = 1, DataBarFillType_Solid = 0, DataBarFillType_Gradient = 1 }
 Specifies how a data bar is filled with color. More...
 
enum  DataBarNegativeColorType { DataBarNegativeColorType_DataBarColor = 0, DataBarNegativeColorType_DataBarSameAsPositive = 1, DataBarNegativeColorType_Color = 0, DataBarNegativeColorType_SameAsPositive = 1 }
 Specifies whether to use the same border and fill color as positive data bars. More...
 
enum  DateTimeGroupingType {
  DateTimeGroupingType_Day, DateTimeGroupingType_Hour, DateTimeGroupingType_Minute, DateTimeGroupingType_Month,
  DateTimeGroupingType_Second, DateTimeGroupingType_Year
}
 Specifies how to group dateTime values. More...
 
enum  DirectoryType { DirectoryType_Volume, DirectoryType_SameVolume, DirectoryType_DownDirectory, DirectoryType_UpDirectory }
 Represents the directory type of the file name. More...
 
enum  DisplayDrawingObjects { DisplayDrawingObjects_DisplayShapes, DisplayDrawingObjects_Placeholders, DisplayDrawingObjects_Hide }
 Represents whether and how to show objects in the workbook. More...
 
enum  DynamicFilterType {
  DynamicFilterType_AboveAverage, DynamicFilterType_BelowAverage, DynamicFilterType_LastMonth, DynamicFilterType_LastQuarter,
  DynamicFilterType_LastWeek, DynamicFilterType_LastYear, DynamicFilterType_January, DynamicFilterType_October,
  DynamicFilterType_November, DynamicFilterType_December, DynamicFilterType_Februray, DynamicFilterType_March,
  DynamicFilterType_April, DynamicFilterType_May, DynamicFilterType_June, DynamicFilterType_July,
  DynamicFilterType_August, DynamicFilterType_September, DynamicFilterType_NextMonth, DynamicFilterType_NextQuarter,
  DynamicFilterType_NextWeek, DynamicFilterType_NextYear, DynamicFilterType_None, DynamicFilterType_Quarter1,
  DynamicFilterType_Quarter2, DynamicFilterType_Quarter3, DynamicFilterType_Quarter4, DynamicFilterType_ThisMonth,
  DynamicFilterType_ThisQuarter, DynamicFilterType_ThisWeek, DynamicFilterType_ThisYear, DynamicFilterType_Today,
  DynamicFilterType_Tomorrow, DynamicFilterType_YearToDate, DynamicFilterType_Yesterday
}
 Dynamic filter type. More...
 
enum  ErrorCheckType {
  ErrorCheckType_Calc = 0x00000001, ErrorCheckType_EmptyCellRef = 0x00000002, ErrorCheckType_TextNumber = 0x00000004, ErrorCheckType_InconsistRange = 0x00000008,
  ErrorCheckType_InconsistFormula = 0x00000010, ErrorCheckType_TextDate = 0x00000020, ErrorCheckType_UnproctedFormula = 0x00000040, ErrorCheckType_Validation = 0x00000080,
  ErrorCheckType_CalculatedColumn
}
 Represents all errors check type. More...
 
enum  ExceptionType {
  ExceptionType_Chart, ExceptionType_DataType, ExceptionType_DataValidation, ExceptionType_ConditionalFormatting,
  ExceptionType_FileFormat, ExceptionType_Formula, ExceptionType_InvalidData, ExceptionType_InvalidOperator,
  ExceptionType_IncorrectPassword, ExceptionType_License, ExceptionType_Limitation, ExceptionType_PageSetup,
  ExceptionType_PivotTable, ExceptionType_Shape, ExceptionType_Sparkline, ExceptionType_SheetName,
  ExceptionType_SheetType, ExceptionType_Interrupted, ExceptionType_IO, ExceptionType_UnsupportedFeature,
  ExceptionType_UnsupportedStream, ExceptionType_UndisclosedInformation
}
 Represents custom exception type code. More...
 
enum  FileFormatType {
  FileFormatType_AsposePdf = 0, FileFormatType_CSV = 1, FileFormatType_Default = 5, FileFormatType_Xlsx = 6,
  FileFormatType_Excel2007Xlsx = 6, FileFormatType_Xlsm = 7, FileFormatType_Excel2007Xlsm = 7, FileFormatType_Xltx = 8,
  FileFormatType_Excel2007Xltx = 8, FileFormatType_Xltm = 9, FileFormatType_Xlam = 10, FileFormatType_Excel2007Xltm = 9,
  FileFormatType_TabDelimited = 11, FileFormatType_Html = 12, FileFormatType_MHtml = 17, FileFormatType_ODS = 14,
  FileFormatType_Excel97To2003 = 5, FileFormatType_Excel2003XML = 15, FileFormatType_Xlsb = 16, FileFormatType_Excel2007Xlsb = 16,
  FileFormatType_Unknown = 255, FileFormatType_Pdf = 13, FileFormatType_XPS = 20, FileFormatType_TIFF = 21,
  FileFormatType_SVG = 28, FileFormatType_Excel95 = 22, FileFormatType_Excel4 = 23, FileFormatType_Excel3 = 24,
  FileFormatType_Excel2 = 25, FileFormatType_Pptx = 26, FileFormatType_Docx = 27, FileFormatType_Dif = 30,
  FileFormatType_Doc = 31, FileFormatType_Ppt = 32, FileFormatType_MapiMessage = 33, FileFormatType_MSEquation = 34,
  FileFormatType_Ole10Native = 35, FileFormatType_VSD = 36, FileFormatType_VSDX = 37, FileFormatType_Docm = 38,
  FileFormatType_Dotx = 39, FileFormatType_Dotm = 40, FileFormatType_Pptm = 41, FileFormatType_Potx = 42,
  FileFormatType_Potm = 43, FileFormatType_Ppsx = 44, FileFormatType_Ppsm = 45, FileFormatType_Ooxml = 46,
  FileFormatType_ODT = 47, FileFormatType_ODP = 48, FileFormatType_ODF = 49, FileFormatType_ODG = 50,
  FileFormatType_XML = 51, FileFormatType_Xlt = 52, FileFormatType_OTT = 53, FileFormatType_BMP = 54,
  FileFormatType_OTS = 55
}
 Enumerates spreadsheet file format types. More...
 
enum  FilterOperatorType {
  FilterOperatorType_LessOrEqual, FilterOperatorType_LessThan, FilterOperatorType_Equal, FilterOperatorType_GreaterThan,
  FilterOperatorType_NotEqual, FilterOperatorType_GreaterOrEqual, FilterOperatorType_None
}
 Custom Filter operator type. More...
 
enum  FontUnderlineType {
  FontUnderlineType_None = 0, FontUnderlineType_Single = 1, FontUnderlineType_Double = 2, FontUnderlineType_Accounting = 3,
  FontUnderlineType_DoubleAccounting = 4, FontUnderlineType_Dash = 5, FontUnderlineType_DashDotDotHeavy = 6, FontUnderlineType_DashDotHeavy = 7,
  FontUnderlineType_DashedHeavy = 8, FontUnderlineType_DashLong = 9, FontUnderlineType_DashLongHeavy = 0x0A, FontUnderlineType_DotDash = 0x0B,
  FontUnderlineType_DotDotDash = 0x0C, FontUnderlineType_Dotted = 0x0D, FontUnderlineType_DottedHeavy = 0x0E, FontUnderlineType_Heavy = 0x0F,
  FontUnderlineType_Wave = 0x10, FontUnderlineType_WavyDouble = 0x11, FontUnderlineType_WavyHeavy = 0x12, FontUnderlineType_Words = 0x13
}
 Enumerates the font underline types. More...
 
enum  FormatConditionType {
  FormatConditionType_CellValue, FormatConditionType_Expression, FormatConditionType_ColorScale, FormatConditionType_DataBar,
  FormatConditionType_IconSet, FormatConditionType_Top10, FormatConditionType_UniqueValues, FormatConditionType_DuplicateValues,
  FormatConditionType_ContainsText, FormatConditionType_NotContainsText, FormatConditionType_BeginsWith, FormatConditionType_EndsWith,
  FormatConditionType_ContainsBlanks, FormatConditionType_NotContainsBlanks, FormatConditionType_ContainsErrors, FormatConditionType_NotContainsErrors,
  FormatConditionType_TimePeriod, FormatConditionType_AboveAverage
}
 Conditional format rule type. More...
 
enum  FormatConditionValueType {
  FormatConditionValueType_Formula, FormatConditionValueType_Max, FormatConditionValueType_Min, FormatConditionValueType_Number,
  FormatConditionValueType_Percent, FormatConditionValueType_Percentile, FormatConditionValueType_AutomaticMax, FormatConditionValueType_AutomaticMin
}
 Condition value type. More...
 
enum  IconSetType {
  IconSetType_Arrows3, IconSetType_ArrowsGray3, IconSetType_Flags3, IconSetType_Signs3,
  IconSetType_Symbols3, IconSetType_Symbols32, IconSetType_TrafficLights31, IconSetType_TrafficLights32,
  IconSetType_Arrows4, IconSetType_ArrowsGray4, IconSetType_Rating4, IconSetType_RedToBlack4,
  IconSetType_TrafficLights4, IconSetType_Arrows5, IconSetType_ArrowsGray5, IconSetType_Quarters5,
  IconSetType_Rating5, IconSetType_Stars3, IconSetType_Boxes5, IconSetType_Triangles3,
  IconSetType_None, IconSetType_CustomSet
}
 Icon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible. More...
 
enum  LoadDataFilterOptions {
  LoadDataFilterOptions_None = 0x0000, LoadDataFilterOptions_All = 0xFFFF, LoadDataFilterOptions_CellBlank = 0x0001, LoadDataFilterOptions_CellString = 0x0002,
  LoadDataFilterOptions_CellNumeric = 0x0004, LoadDataFilterOptions_CellError = 0x0008, LoadDataFilterOptions_CellBool = 0x0010, LoadDataFilterOptions_CellValue = 0x001F,
  LoadDataFilterOptions_Style = 0x0020, LoadDataFilterOptions_Formula = 0x0040, LoadDataFilterOptions_CellData = 0x007F, LoadDataFilterOptions_DocumentProperties = 0x0080,
  LoadDataFilterOptions_Chart = 0x0100, LoadDataFilterOptions_Shape = 0x0200, LoadDataFilterOptions_MergedArea = 0x0400, LoadDataFilterOptions_ConditionalFormatting = 0x0800,
  LoadDataFilterOptions_DataValidation = 0x1000, LoadDataFilterOptions_PivotTable = 0x2000, LoadDataFilterOptions_Table = 0x4000, LoadDataFilterOptions_Settings = 0x8000
}
 Represents the options to filter data when loading workbook from template. More...
 
enum  LoadFormat {
  LoadFormat_Auto, LoadFormat_CSV = 1, LoadFormat_Xlsx = 6, LoadFormat_TabDelimited = 11,
  LoadFormat_Html = 12, LoadFormat_MHtml = 13, LoadFormat_ODS = 14, LoadFormat_Excel97To2003 = 5,
  LoadFormat_SpreadsheetML = 15, LoadFormat_Xlsb = 16, LoadFormat_Unknown = 255
}
 Represents the load file format. More...
 
enum  LookAtType { LookAtType_Contains, LookAtType_StartWith, LookAtType_EndWith, LookAtType_EntireContent }
 Represents look at type. More...
 
enum  LookInType {
  LookInType_Formulas, LookInType_Values, LookInType_ValuesExcludeFormulaCell, LookInType_Comments,
  LookInType_OnlyFormulas, LookInType_OriginalValues
}
 Represents look in type. More...
 
enum  MemorySetting { MemorySetting_Normal, MemorySetting_MemoryPreference }
 Memory usage options. More...
 
enum  NumberCategoryType {
  NumberCategoryType_General, NumberCategoryType_Text, NumberCategoryType_Number, NumberCategoryType_Date,
  NumberCategoryType_Time, NumberCategoryType_Fraction, NumberCategoryType_Scientific
}
 Represents category type of cell's number formatting. More...
 
enum  OperatorType {
  OperatorType_Between, OperatorType_Equal, OperatorType_GreaterThan, OperatorType_GreaterOrEqual,
  OperatorType_LessThan, OperatorType_LessOrEqual, OperatorType_None, OperatorType_NotBetween,
  OperatorType_NotEqual
}
 Represents the operator type of conditional format and data validation. More...
 
enum  PageOrientationType { PageOrientationType_Landscape, PageOrientationType_Portrait }
 Represents print orientation constants. More...
 
enum  PaperSizeType {
  PaperSizeType_PaperLetter = 1, PaperSizeType_PaperLetterSmall = 2, PaperSizeType_PaperTabloid = 3, PaperSizeType_PaperLedger = 4,
  PaperSizeType_PaperLegal = 5, PaperSizeType_PaperStatement = 6, PaperSizeType_PaperExecutive = 7, PaperSizeType_PaperA3 = 8,
  PaperSizeType_PaperA4 = 9, PaperSizeType_PaperA4Small = 10, PaperSizeType_PaperA5 = 11, PaperSizeType_PaperB4 = 12,
  PaperSizeType_PaperB5 = 13, PaperSizeType_PaperFolio = 14, PaperSizeType_PaperQuarto = 15, PaperSizeType_Paper10x14 = 16,
  PaperSizeType_Paper11x17 = 17, PaperSizeType_PaperNote = 18, PaperSizeType_PaperEnvelope9 = 19, PaperSizeType_PaperEnvelope10 = 20,
  PaperSizeType_PaperEnvelope11 = 21, PaperSizeType_PaperEnvelope12 = 22, PaperSizeType_PaperEnvelope14 = 23, PaperSizeType_PaperCSheet = 24,
  PaperSizeType_PaperDSheet = 25, PaperSizeType_PaperESheet = 26, PaperSizeType_PaperEnvelopeDL = 27, PaperSizeType_PaperEnvelopeC5 = 28,
  PaperSizeType_PaperEnvelopeC3 = 29, PaperSizeType_PaperEnvelopeC4 = 30, PaperSizeType_PaperEnvelopeC6 = 31, PaperSizeType_PaperEnvelopeC65 = 32,
  PaperSizeType_PaperEnvelopeB4 = 33, PaperSizeType_PaperEnvelopeB5 = 34, PaperSizeType_PaperEnvelopeB6 = 35, PaperSizeType_PaperEnvelopeItaly = 36,
  PaperSizeType_PaperEnvelopeMonarch = 37, PaperSizeType_PaperEnvelopePersonal = 38, PaperSizeType_PaperFanfoldUS = 39, PaperSizeType_PaperFanfoldStdGerman = 40,
  PaperSizeType_PaperFanfoldLegalGerman = 41, PaperSizeType_PaperISOB4 = 42, PaperSizeType_PaperJapanesePostcard = 43, PaperSizeType_Paper9x11 = 44,
  PaperSizeType_Paper10x11 = 45, PaperSizeType_Paper15x11 = 46, PaperSizeType_PaperEnvelopeInvite = 47, PaperSizeType_PaperLetterExtra = 50,
  PaperSizeType_PaperLegalExtra = 51, PaperSizeType_PaperTabloidExtra = 52, PaperSizeType_PaperA4Extra = 53, PaperSizeType_PaperLetterTransverse = 54,
  PaperSizeType_PaperA4Transverse = 55, PaperSizeType_PaperLetterExtraTransverse = 56, PaperSizeType_PaperSuperA = 57, PaperSizeType_PaperSuperB = 58,
  PaperSizeType_PaperLetterPlus = 59, PaperSizeType_PaperA4Plus = 60, PaperSizeType_PaperA5Transverse = 61, PaperSizeType_PaperJISB5Transverse = 62,
  PaperSizeType_PaperA3Extra = 63, PaperSizeType_PaperA5Extra = 64, PaperSizeType_PaperISOB5Extra = 65, PaperSizeType_PaperA2 = 66,
  PaperSizeType_PaperA3Transverse = 67, PaperSizeType_PaperA3ExtraTransverse = 68, PaperSizeType_PaperJapaneseDoublePostcard = 69, PaperSizeType_PaperA6 = 70,
  PaperSizeType_PaperJapaneseEnvelopeKaku2 = 71, PaperSizeType_PaperJapaneseEnvelopeKaku3 = 72, PaperSizeType_PaperJapaneseEnvelopeChou3 = 73, PaperSizeType_PaperJapaneseEnvelopeChou4 = 74,
  PaperSizeType_PaperLetterRotated = 75, PaperSizeType_PaperA3Rotated = 76, PaperSizeType_PaperA4Rotated = 77, PaperSizeType_PaperA5Rotated = 78,
  PaperSizeType_PaperJISB4Rotated = 79, PaperSizeType_PaperJISB5Rotated = 80, PaperSizeType_PaperJapanesePostcardRotated = 81, PaperSizeType_PaperJapaneseDoublePostcardRotated = 82,
  PaperSizeType_PaperA6Rotated = 83, PaperSizeType_PaperJapaneseEnvelopeKaku2Rotated = 84, PaperSizeType_PaperJapaneseEnvelopeKaku3Rotated = 85, PaperSizeType_PaperJapaneseEnvelopeChou3Rotated = 86,
  PaperSizeType_PaperJapaneseEnvelopeChou4Rotated = 87, PaperSizeType_PaperJISB6 = 88, PaperSizeType_PaperJISB6Rotated = 89, PaperSizeType_Paper12x11 = 90,
  PaperSizeType_PaperJapaneseEnvelopeYou4 = 91, PaperSizeType_PaperJapaneseEnvelopeYou4Rotated = 92, PaperSizeType_PaperPRC16K = 93, PaperSizeType_PaperPRC32K = 94,
  PaperSizeType_PaperPRCBig32K = 95, PaperSizeType_PaperPRCEnvelope1 = 96, PaperSizeType_PaperPRCEnvelope2 = 97, PaperSizeType_PaperPRCEnvelope3 = 98,
  PaperSizeType_PaperPRCEnvelope4 = 99, PaperSizeType_PaperPRCEnvelope5 = 100, PaperSizeType_PaperPRCEnvelope6 = 101, PaperSizeType_PaperPRCEnvelope7 = 102,
  PaperSizeType_PaperPRCEnvelope8 = 103, PaperSizeType_PaperPRCEnvelope9 = 104, PaperSizeType_PaperPRCEnvelope10 = 105, PaperSizeType_PaperPRC16KRotated = 106,
  PaperSizeType_PaperPRC32KRotated = 107, PaperSizeType_PaperPRCBig32KRotated = 108, PaperSizeType_PaperPRCEnvelope1Rotated = 109, PaperSizeType_PaperPRCEnvelope2Rotated = 110,
  PaperSizeType_PaperPRCEnvelope3Rotated = 111, PaperSizeType_PaperPRCEnvelope4Rotated = 112, PaperSizeType_PaperPRCEnvelope5Rotated = 113, PaperSizeType_PaperPRCEnvelope6Rotated = 114,
  PaperSizeType_PaperPRCEnvelope7Rotated = 115, PaperSizeType_PaperPRCEnvelope8Rotated = 116, PaperSizeType_PaperPRCEnvelope9Rotated = 117, PaperSizeType_PaperPRCEnvelope10Rotated = 118,
  PaperSizeType_PaperB3 = 300, PaperSizeType_PaperBusinessCard = 301, PaperSizeType_PaperThermal = 302
}
 Represents paper size constants. More...
 
enum  ParameterType { ParameterType_Reference, ParameterType_Value, ParameterType_Array }
 Represent all parameters' type or return value type of function. More...
 
enum  PasteType {
  PasteType_All, PasteType_Default, PasteType_AllExceptBorders, PasteType_DefaultExceptBorders,
  PasteType_ColumnWidths, PasteType_RowHeights, PasteType_Comments, PasteType_Formats,
  PasteType_Formulas, PasteType_FormulasAndNumberFormats, PasteType_Validation, PasteType_Values,
  PasteType_ValuesAndNumberFormats
}
 Represents the paste special type. More...
 
enum  PrintCommentsType { PrintCommentsType_PrintInPlace, PrintCommentsType_PrintNoComments, PrintCommentsType_PrintSheetEnd }
 Represents the way comments are printed with the sheet. More...
 
enum  PrintErrorsType { PrintErrorsType_PrintErrorsBlank, PrintErrorsType_PrintErrorsDash, PrintErrorsType_PrintErrorsDisplayed, PrintErrorsType_PrintErrorsNA }
 Represents print errors constants. More...
 
enum  PrintOrderType { PrintOrderType_DownThenOver, PrintOrderType_OverThenDown }
 Represent print order constants. More...
 
enum  ProtectionType {
  ProtectionType_All, ProtectionType_Contents, ProtectionType_Objects, ProtectionType_Scenarios,
  ProtectionType_Structure, ProtectionType_Windows, ProtectionType_None
}
 Represents workbook/worksheet protection type. More...
 
enum  SaveFormat {
  SaveFormat_CSV = 1, SaveFormat_Xlsx = 6, SaveFormat_Xlsm = 7, SaveFormat_Xltx = 8,
  SaveFormat_Xltm = 9, SaveFormat_Xlam = 10, SaveFormat_TabDelimited = 11, SaveFormat_Html = 12,
  SaveFormat_MHtml = 17, SaveFormat_ODS = 14, SaveFormat_Excel97To2003 = 5, SaveFormat_SpreadsheetML = 15,
  SaveFormat_Xlsb = 16, SaveFormat_Auto = 0, SaveFormat_Unknown = 255, SaveFormat_Pdf = 13,
  SaveFormat_XPS = 20, SaveFormat_TIFF = 21, SaveFormat_SVG = 22, SaveFormat_Dif = 30
}
 Represents the format in which the workbook is saved. More...
 
enum  SheetType {
  SheetType_VB, SheetType_Worksheet, SheetType_Chart, SheetType_BIFF4Macro,
  SheetType_Other
}
 Specifies the worksheet type. More...
 
enum  ShiftType {
  ShiftType_Down, ShiftType_Left, ShiftType_None, ShiftType_Right,
  ShiftType_Up
}
 Represent the shift options when deleting a range of cells. More...
 
enum  SortOrder { SortOrder_Ascending, SortOrder_Descending }
 Represents sort order for the data range. More...
 
enum  StyleModifyFlag {
  StyleModifyFlag_All, StyleModifyFlag_Borders, StyleModifyFlag_LeftBorder, StyleModifyFlag_RightBorder,
  StyleModifyFlag_TopBorder, StyleModifyFlag_BottomBorder, StyleModifyFlag_HorizontalBorder, StyleModifyFlag_VerticalBorder,
  StyleModifyFlag_Diagonal, StyleModifyFlag_DiagonalDownBorder, StyleModifyFlag_DiagonalUpBorder, StyleModifyFlag_Font,
  StyleModifyFlag_FontSize, StyleModifyFlag_FontName, StyleModifyFlag_FontFamily, StyleModifyFlag_FontCharset,
  StyleModifyFlag_FontColor, StyleModifyFlag_FontWeight, StyleModifyFlag_FontItalic, StyleModifyFlag_FontUnderline,
  StyleModifyFlag_FontStrike, StyleModifyFlag_FontSubscript, StyleModifyFlag_FontSuperscript, StyleModifyFlag_FontScript,
  StyleModifyFlag_NumberFormat, StyleModifyFlag_HorizontalAlignment, StyleModifyFlag_VerticalAlignment, StyleModifyFlag_Indent,
  StyleModifyFlag_Rotation, StyleModifyFlag_WrapText, StyleModifyFlag_ShrinkToFit, StyleModifyFlag_TextDirection,
  StyleModifyFlag_CellShading, StyleModifyFlag_Pattern, StyleModifyFlag_ForegroundColor, StyleModifyFlag_BackgroundColor,
  StyleModifyFlag_Locked, StyleModifyFlag_HideFormula, StyleModifyFlag_AlignmentSettings, StyleModifyFlag_FontScheme,
  StyleModifyFlag_FontDirty, StyleModifyFlag_FontSpellingError, StyleModifyFlag_FontUFillTx, StyleModifyFlag_FontSpacing,
  StyleModifyFlag_FontKerning, StyleModifyFlag_FontEqualize, StyleModifyFlag_FontCap
}
 The style modified flags. More...
 
enum  TextAlignmentType {
  TextAlignmentType_Bottom, TextAlignmentType_Center, TextAlignmentType_CenterAcross, TextAlignmentType_Distributed,
  TextAlignmentType_Fill, TextAlignmentType_General, TextAlignmentType_Justify, TextAlignmentType_Left,
  TextAlignmentType_Right, TextAlignmentType_Top, TextAlignmentType_JustifiedLow, TextAlignmentType_ThaiDistributed
}
 Enumerates text alignment types. More...
 
enum  TextCapsType { TextCapsType_None, TextCapsType_All, TextCapsType_Small }
 This type specifies the cap types of the text. More...
 
enum  TextDirectionType { TextDirectionType_Context = 0, TextDirectionType_LeftToRight = 1, TextDirectionType_RightToLeft = 2 }
 Represents the direction of the text flow for this paragraph. More...
 
enum  TextStrikeType { TextStrikeType_Single, TextStrikeType_Double, TextStrikeType_None }
 This type specifies the strike type. More...
 
enum  ThemeColorType {
  ThemeColorType_Background1 = 0, ThemeColorType_Text1 = 1, ThemeColorType_Background2 = 2, ThemeColorType_Text2 = 3,
  ThemeColorType_Accent1 = 4, ThemeColorType_Accent2 = 5, ThemeColorType_Accent3 = 6, ThemeColorType_Accent4 = 7,
  ThemeColorType_Accent5 = 8, ThemeColorType_Accent6 = 9, ThemeColorType_Hyperlink = 10, ThemeColorType_FollowedHyperlink = 11,
  ThemeColorType_StyleColor
}
 Enumerates the theme color types. More...
 
enum  TimePeriodType {
  TimePeriodType_Today, TimePeriodType_Yesterday, TimePeriodType_Tomorrow, TimePeriodType_Last7Days,
  TimePeriodType_ThisMonth, TimePeriodType_LastMonth, TimePeriodType_NextMonth, TimePeriodType_ThisWeek,
  TimePeriodType_LastWeek, TimePeriodType_NextWeek
}
 Used in a FormatConditionType_TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied. More...
 
enum  TxtLoadStyleStrategy { TxtLoadStyleStrategy_None, TxtLoadStyleStrategy_BuiltIn, TxtLoadStyleStrategy_ExactFormat }
 Specifies how to apply style for parsed values when converting string value to number or datetime. More...
 
enum  TxtValueQuoteType { TxtValueQuoteType_Normal, TxtValueQuoteType_Always, TxtValueQuoteType_Minimum, TxtValueQuoteType_Never }
 Specifies the type of using quotation marks for values in text format files. More...
 
enum  UpdateLinksType { UpdateLinksType_UserSet = 0, UpdateLinksType_Never = 1, UpdateLinksType_Always }
 Represents how to update links to other workbooks when the workbook is opened. More...
 
enum  ValidationAlertType { ValidationAlertType_Information, ValidationAlertType_Stop, ValidationAlertType_Warning }
 Represents the data validation alert style. More...
 
enum  ValidationType {
  ValidationType_AnyValue, ValidationType_WholeNumber, ValidationType_Decimal, ValidationType_List,
  ValidationType_Date, ValidationType_Time, ValidationType_TextLength, ValidationType_Custom
}
 Represents data validation type. More...
 
enum  ViewType { ViewType_NormalView, ViewType_PageBreakPreview, ViewType_PageLayoutView }
 Represents the view type of the worksheet. More...
 
enum  VisibilityType { VisibilityType_Hidden = 1, VisibilityType_VeryHidden = 2, VisibilityType_Visible = 0 }
 Represents the states for sheet visibility. More...
 

Enumeration Type Documentation

§ BackgroundType

Enumerates cell background pattern types.

Enumerator
BackgroundType_DiagonalCrosshatch 

Represents diagonal crosshatch pattern.

BackgroundType_DiagonalStripe 

Represents diagonal stripe pattern.

BackgroundType_Gray6 

Represents 6.25% gray pattern

BackgroundType_Gray12 

Represents 12.5% gray pattern

BackgroundType_Gray25 

Represents 25% gray pattern.

BackgroundType_Gray50 

Represents 50% gray pattern.

BackgroundType_Gray75 

Represents 75% gray pattern.

BackgroundType_HorizontalStripe 

Represents horizontal stripe pattern.

BackgroundType_None 

Represents no background.

BackgroundType_ReverseDiagonalStripe 

Represents reverse diagonal stripe pattern.

BackgroundType_Solid 

Represents solid pattern.

BackgroundType_ThickDiagonalCrosshatch 

Represents thick diagonal crosshatch pattern.

BackgroundType_ThinDiagonalCrosshatch 

Represents thin diagonal crosshatch pattern.

BackgroundType_ThinDiagonalStripe 

Represents thin diagonal stripe pattern.

BackgroundType_ThinHorizontalCrosshatch 

Represents thin horizontal crosshatch pattern.

BackgroundType_ThinHorizontalStripe 

Represents thin horizontal stripe pattern.

BackgroundType_ThinReverseDiagonalStripe 

Represents thin reverse diagonal stripe pattern.

BackgroundType_ThinVerticalStripe 

Represents thin vertical stripe pattern.

BackgroundType_VerticalStripe 

Represents vertical stripe pattern.

§ BorderType

Enumerates the border line and diagonal line types.

Enumerator
BorderType_BottomBorder 

Represents bottom border line.

BorderType_DiagonalDown 

Represents the diagonal line from top left to right bottom.

BorderType_DiagonalUp 

Represents the diagonal line from bottom left to right top.

BorderType_LeftBorder 

Represents left border line.

BorderType_RightBorder 

Represents right border line exists.

BorderType_TopBorder 

Represents top border line.

BorderType_Horizontal 

Only for dynamic style,such as conditional formatting.

BorderType_Vertical 

Only for dynamic style,such as conditional formatting.

§ BuiltinStyleType

Represents all built style type.

Enumerator
BuiltinStyleType_TwentyPercentAccent1 
BuiltinStyleType_TwentyPercentAccent2 
BuiltinStyleType_TwentyPercentAccent3 
BuiltinStyleType_TwentyPercentAccent4 
BuiltinStyleType_TwentyPercentAccent5 
BuiltinStyleType_TwentyPercentAccent6 
BuiltinStyleType_FortyPercentAccent1 
BuiltinStyleType_FortyPercentAccent2 
BuiltinStyleType_FortyPercentAccent3 
BuiltinStyleType_FortyPercentAccent4 
BuiltinStyleType_FortyPercentAccent5 
BuiltinStyleType_FortyPercentAccent6 
BuiltinStyleType_SixtyPercentAccent1 
BuiltinStyleType_SixtyPercentAccent2 
BuiltinStyleType_SixtyPercentAccent3 
BuiltinStyleType_SixtyPercentAccent4 
BuiltinStyleType_SixtyPercentAccent5 
BuiltinStyleType_SixtyPercentAccent6 
BuiltinStyleType_Accent1 
BuiltinStyleType_Accent2 
BuiltinStyleType_Accent3 
BuiltinStyleType_Accent4 
BuiltinStyleType_Accent5 
BuiltinStyleType_Accent6 
BuiltinStyleType_Bad 
BuiltinStyleType_Calculation 
BuiltinStyleType_CheckCell 
BuiltinStyleType_Comma 
BuiltinStyleType_Comma1 
BuiltinStyleType_Currency 
BuiltinStyleType_Currency1 
BuiltinStyleType_ExplanatoryText 
BuiltinStyleType_Good 
BuiltinStyleType_Header1 
BuiltinStyleType_Header2 
BuiltinStyleType_Header3 
BuiltinStyleType_Header4 
BuiltinStyleType_Hyperlink 
BuiltinStyleType_FollowedHyperlink 
BuiltinStyleType_Input 
BuiltinStyleType_LinkedCell 
BuiltinStyleType_Neutral 
BuiltinStyleType_Normal 
BuiltinStyleType_Note 
BuiltinStyleType_Output 
BuiltinStyleType_Percent 
BuiltinStyleType_Title 
BuiltinStyleType_Total 
BuiltinStyleType_WarningText 
BuiltinStyleType_RowLevel 
BuiltinStyleType_ColumnLevel 

§ CalcModeType

Represents the mode type of calculating formulas.

Enumerator
CalcModeType_Automatic 
CalcModeType_AutomaticExceptTable 
CalcModeType_Manual 

§ CalculationPrecisionStrategy

Enumerates strategies for handling calculation precision. Because of the precision issue of IEEE 754 Floating-Point Arithmetic, some "seemingly simple" formulas may not be calcualted as the expected result. Such as formula "=-0.45+0.43+0.02", when calcuating operands by '+' operator directly, the result is not zero. For such kind of precision issue, some special strategies may give the expected result.

Enumerator
CalculationPrecisionStrategy_None 

No strategy applied on calculation. When calculating just use the original double value as operand and return the result directly. Most efficient for performance and applicable for most cases.

CalculationPrecisionStrategy_Round 

Rounds the calculation result according with significant digits.

CalculationPrecisionStrategy_Decimal 

Uses decimal as operands when possible. Most inefficient for performance.

§ CellBorderType

Enumerates a cell's border type.

Enumerator
CellBorderType_DashDot 

Represents thin dash-dotted line.

CellBorderType_DashDotDot 

Represents thin dash-dot-dotted line.

CellBorderType_Dashed 

Represents dashed line.

CellBorderType_Dotted 

Represents dotted line.

CellBorderType_Double 

Represents double line.

CellBorderType_Hair 

Represents hair line.

CellBorderType_MediumDashDot 

Represents medium dash-dotted line.

CellBorderType_MediumDashDotDot 

Represents medium dash-dot-dotted line.

CellBorderType_MediumDashed 

Represents medium dashed line.

CellBorderType_None 

Represents no line.

CellBorderType_Medium 

Represents medium line.

CellBorderType_SlantedDashDot 

Represents slanted medium dash-dotted line.

CellBorderType_Thick 

Represents thick line.

CellBorderType_Thin 

Represents thin line.

§ CellValueFormatStrategy

Specifies how to apply style for the value of the cell.

Enumerator
CellValueFormatStrategy_None 

Not formatted.

CellValueFormatStrategy_CellStyle 

Only formatted with the cell's original style.

CellValueFormatStrategy_DisplayStyle 

Formatted with the cell's displayed style.

§ CellValueType

Specifies a cell value type.

Enumerator
CellValueType_IsBool 

Cell value is boolean.

CellValueType_IsDateTime 

Cell value is datetime.

CellValueType_IsError 

Cell contains error value

CellValueType_IsNull 

Blank cell.

CellValueType_IsNumeric 

Cell value is numeric.

CellValueType_IsString 

Cell value is string.

CellValueType_IsUnknown 

Cell value type is unknown.

§ ColorType

Represents all color type

Enumerator
ColorType_Automatic 

Automatic color.

ColorType_AutomaticIndex 

It's automatic color, but the displayed color depends the setting of the OS System.

Not supported.

ColorType_RGB 

The RGB color.

ColorType_IndexedColor 

The color index in the color palette.

ColorType_Theme 

The theme color.

§ ConsolidationFunction

Represents consolidation function.

Enumerator
ConsolidationFunction_Sum 

Represents Sum function.

ConsolidationFunction_Count 

Represents Count function.

ConsolidationFunction_Average 

Represents Average function.

ConsolidationFunction_Max 

Represents Max function.

ConsolidationFunction_Min 

Represents Min function.

ConsolidationFunction_Product 

Represents Product function.

ConsolidationFunction_CountNums 

Represents Count Nums function.

ConsolidationFunction_StdDev 

Represents StdDev function.

ConsolidationFunction_StdDevp 

Represents StdDevp function.

ConsolidationFunction_Var 

Represents Var function.

ConsolidationFunction_Varp 

Represents Varp function.

ConsolidationFunction_DistinctCount 

Represents Distinct Count function.

Only valid for PivotTable with Data Module created since by 2013.

§ CountryCode

Represents Excel country identifiers.

Enumerator
CountryCode_Default 

Default

CountryCode_USA 

United States

CountryCode_Canada 

Canada

CountryCode_LatinAmeric 

Latin America, except Brazil

CountryCode_Russia 

Russia

CountryCode_Egypt 

Egypt

CountryCode_Greece 

Greece

CountryCode_Netherlands 

Netherlands

CountryCode_Belgium 

Belgium

CountryCode_France 

France

CountryCode_Spain 

Spain

CountryCode_Hungary 

Hungary

CountryCode_Italy 

Italy

CountryCode_Switzerland 

Switzerland

CountryCode_Austria 

Austria

CountryCode_UnitedKingdom 

United Kingdom

CountryCode_Denmark 

Denmark

CountryCode_Sweden 

Sweden

CountryCode_Norway 

Norway

CountryCode_Poland 

Poland

CountryCode_Germany 

Germany

CountryCode_Mexico 

Mexico

CountryCode_Brazil 

Brazil

CountryCode_Australia 

Australia

CountryCode_NewZealand 

New Zealand

CountryCode_Thailand 

Thailand

CountryCode_Japan 

Japan

CountryCode_SouthKorea 

SouthKorea

CountryCode_VietNam 

Viet Nam

CountryCode_China 

People's Republic of China

CountryCode_Turkey 

Turkey

CountryCode_India 

India

CountryCode_Algeria 

Algeria

CountryCode_Morocco 

Morocco

CountryCode_Libya 

Libya

CountryCode_Portugal 

Portugal

CountryCode_Iceland 

Iceland

CountryCode_Finland 

Finland

CountryCode_Czech 

Czech Republic

CountryCode_Taiwan 

Taiwan

CountryCode_Lebanon 

Lebanon

CountryCode_Jordan 

Jordan

CountryCode_Syria 

Syria

CountryCode_Iraq 

Iraq

CountryCode_Kuwait 

Kuwait

CountryCode_Saudi 

Saudi Arabia

CountryCode_UnitedArabEmirates 

United Arab Emirates

CountryCode_Israel 

Israel

CountryCode_Qatar 

Qatar

CountryCode_Iran 

Iran

§ DataBarAxisPosition

Specifies the axis position for a range of cells with conditional formatting as data bars.

Enumerator
DataBarAxisPosition_DataBarAxisAutomatic 

Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. When all values are positive or all values are negative, no axis is displayed.

NOTE: This enum type is now obsolete. Instead, please use DataBarAxisPosition_Automatic enum type.

DataBarAxisPosition_DataBarAxisMidpoint 

Display the axis at the midpoint of the cell regardless of the set of values in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction.

NOTE: This enum type is now obsolete. Instead, please use DataBarAxisPosition_Midpoint enum type.

DataBarAxisPosition_DataBarAxisNone 

No axis is displayed, and both positive and negative values are displayed in the left-to-right direction.

NOTE: This enum type is now obsolete. Instead, please use DataBarAxisPosition_None enum type.

DataBarAxisPosition_Automatic 

Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. When all values are positive or all values are negative, no axis is displayed.

DataBarAxisPosition_Midpoint 

Display the axis at the midpoint of the cell regardless of the set of values in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction.

DataBarAxisPosition_None 

No axis is displayed, and both positive and negative values are displayed in the left-to-right direction.

§ DataBarBorderType

Specifies the border type of a data bar.

Enumerator
DataBarBorderType_DataBarBorderNone 

The data bar has no border.

NOTE: This enum type is now obsolete. Instead, please use DataBarBorderType_None enum type.

DataBarBorderType_DataBarBorderSolid 

The data bar has a solid border.

NOTE: This enum type is now obsolete. Instead, please use DataBarBorderType_Solid enum type.

DataBarBorderType_None 

The data bar has no border.

DataBarBorderType_Solid 

The data bar has a solid border.

§ DataBarFillType

Specifies how a data bar is filled with color.

Enumerator
DataBarFillType_DataBarFillSolid 

The data bar is filled with solid color.

NOTE: This enum type is now obsolete. Instead, please use DataBarFillType_Solid enum type.

DataBarFillType_DataBarFillGradient 

The data bar is filled with a color gradient.

NOTE: This enum type is now obsolete. Instead, please use DataBarFillType_Gradient enum type.

DataBarFillType_Solid 

The data bar is filled with solid color.

DataBarFillType_Gradient 

The data bar is filled with a color gradient.

§ DataBarNegativeColorType

Specifies whether to use the same border and fill color as positive data bars.

Enumerator
DataBarNegativeColorType_DataBarColor 

Use the color specified in the Negative Value and Axis Setting dialog box or by using the ColorType and BorderColorType properties of the NegativeBarFormat object.

NOTE: This enum type is now obsolete. Instead, please use DataBarNegativeColorType_Color enum type.

DataBarNegativeColorType_DataBarSameAsPositive 

Use the same color as positive data bars.

NOTE: This enum type is now obsolete. Instead, please use DataBarNegativeColorType_SameAsPositive enum type.

DataBarNegativeColorType_Color 

Use the color specified in the Negative Value and Axis Setting dialog box or by using the ColorType and BorderColorType properties of the NegativeBarFormat object.

DataBarNegativeColorType_SameAsPositive 

Use the same color as positive data bars.

§ DateTimeGroupingType

Specifies how to group dateTime values.

Enumerator
DateTimeGroupingType_Day 

Group by day.

DateTimeGroupingType_Hour 

Group by hour.

DateTimeGroupingType_Minute 

Group by Minute.

DateTimeGroupingType_Month 

Group by Month.

DateTimeGroupingType_Second 

Group by Second.

DateTimeGroupingType_Year 

Group by Year.

§ DirectoryType

Represents the directory type of the file name.

Enumerator
DirectoryType_Volume 

Represents an MS-DOS drive letter. It is followed by the drive letter. Or UNC file names, such as \server\share\myfile.xls

DirectoryType_SameVolume 

Indicates that the source workbook is on the same drive as the dependent workbook (the drive letter is omitted)

DirectoryType_DownDirectory 

Indicates that the source workbook is in a subdirectory of the current directory.

DirectoryType_UpDirectory 

Indicates that the source workbook is in the parent directory of the current directory.

§ DisplayDrawingObjects

Represents whether and how to show objects in the workbook.

Enumerator
DisplayDrawingObjects_DisplayShapes 

Show all objects

DisplayDrawingObjects_Placeholders 

Show placeholders

DisplayDrawingObjects_Hide 

Hide all shapes.

§ DynamicFilterType

Dynamic filter type.

Enumerator
DynamicFilterType_AboveAverage 

Shows values that are above average.

DynamicFilterType_BelowAverage 

Shows values that are below average.

DynamicFilterType_LastMonth 

Shows last month's dates.

DynamicFilterType_LastQuarter 

Shows last quarter's dates.

DynamicFilterType_LastWeek 

Shows last week's dates.

DynamicFilterType_LastYear 

Shows last year's dates.

DynamicFilterType_January 

Shows the dates that are in January, regardless of year.

DynamicFilterType_October 

Shows the dates that are in October, regardless of year.

DynamicFilterType_November 

Shows the dates that are in November, regardless of year.

DynamicFilterType_December 

Shows the dates that are in December, regardless of year.

DynamicFilterType_Februray 

Shows the dates that are in Februray, regardless of year.

DynamicFilterType_March 

Shows the dates that are in March, regardless of year.

DynamicFilterType_April 

Shows the dates that are in April, regardless of year.

DynamicFilterType_May 

Shows the dates that are in May, regardless of year.

DynamicFilterType_June 

Shows the dates that are in June, regardless of year.

DynamicFilterType_July 

Shows the dates that are in July, regardless of year.

DynamicFilterType_August 

Shows the dates that are in August, regardless of year.

DynamicFilterType_September 

Shows the dates that are in September, regardless of year.

DynamicFilterType_NextMonth 

Shows next month's dates.

DynamicFilterType_NextQuarter 

Shows next quarter's dates.

DynamicFilterType_NextWeek 

Shows next week's dates.

DynamicFilterType_NextYear 

Shows next year's dates.

DynamicFilterType_None 
DynamicFilterType_Quarter1 

Shows the dates that are in the 1st quarter, regardless of year.

DynamicFilterType_Quarter2 

Shows the dates that are in the 2nd quarter, regardless of year.

DynamicFilterType_Quarter3 

Shows the dates that are in the 3rd quarter, regardless of year.

DynamicFilterType_Quarter4 

Shows the dates that are in the 4th quarter, regardless of year.

DynamicFilterType_ThisMonth 

Shows this month's dates.

DynamicFilterType_ThisQuarter 

Shows this quarter's dates.

DynamicFilterType_ThisWeek 

Shows this week's dates.

DynamicFilterType_ThisYear 

Shows this year's dates.

DynamicFilterType_Today 

Shows today's dates.

DynamicFilterType_Tomorrow 

Shows tomorrow's dates.

DynamicFilterType_YearToDate 

Shows the dates between the beginning of the year and today, inclusive.

DynamicFilterType_Yesterday 

Shows yesterday's dates.

§ ErrorCheckType

Represents all errors check type.

Enumerator
ErrorCheckType_Calc 

check for calculation errors

ErrorCheckType_EmptyCellRef 

check for references to empty cells

ErrorCheckType_TextNumber 

check the format of numeric values

ErrorCheckType_InconsistRange 

check formulas with references to less than the entirety of a range containing continuous data

ErrorCheckType_InconsistFormula 

check formulas that are inconsistent with formulas in neighboring cells.

ErrorCheckType_TextDate 

check the format of date/time values

ErrorCheckType_UnproctedFormula 

check for unprotected formulas

ErrorCheckType_Validation 

whether to perform data validation

ErrorCheckType_CalculatedColumn 

Ignore errors when cells contain a value different from a calculated column formula.

§ ExceptionType

Represents custom exception type code.

Enumerator
ExceptionType_Chart 

Invalid chart setting.

ExceptionType_DataType 

Invalid data type setting.

ExceptionType_DataValidation 

Invalid data validation setting.

ExceptionType_ConditionalFormatting 

Invalid data validation setting.

ExceptionType_FileFormat 

Invalid file format.

ExceptionType_Formula 

Invalid formula.

ExceptionType_InvalidData 

Invalid data.

ExceptionType_InvalidOperator 

Invalid operator.

ExceptionType_IncorrectPassword 

Incorrect password.

ExceptionType_License 

License related errors.

ExceptionType_Limitation 

Out of MS Excel limitation error.

ExceptionType_PageSetup 

Invalid page setup setting.

ExceptionType_PivotTable 

Invalid pivotTable setting.

ExceptionType_Shape 

Invalid drawing object setting.

ExceptionType_Sparkline 

Invalid sparkline object setting.

ExceptionType_SheetName 

Invalid worksheet name.

ExceptionType_SheetType 

Invalid worksheet type.

ExceptionType_Interrupted 

The operator is interrupted.

ExceptionType_IO 

The file is invalid.

ExceptionType_UnsupportedFeature 

Unsupported feature.

ExceptionType_UnsupportedStream 

Unsupported stream to be opened.

ExceptionType_UndisclosedInformation 

Files contains some undisclosed information.

§ FileFormatType

Enumerates spreadsheet file format types.

Enumerator
FileFormatType_AsposePdf 

Saves the spreadsheet in Aspose.Pdf.Xml format that can be read by Aspose.Pdf to produce a PDF file. NOTE: This member is now obsolete. Instead, please use FileFormatType_Pdf

FileFormatType_CSV 

Represents a CSV file.

FileFormatType_Default 

Represents an Excel 97-2003 xls file. NOTE: This member is now obsolete. Instead, please use FileFormatType_Excel97To2003

FileFormatType_Xlsx 

Represents an xlsx file.

FileFormatType_Excel2007Xlsx 

Represents an xlsx file. NOTE: This member is now obsolete. Instead, please use FileFormatType_Xlsx

FileFormatType_Xlsm 

Represents an xlsm file which enable macros.

FileFormatType_Excel2007Xlsm 

Represents an xlsm file which enable macros. NOTE: This member is now obsolete. Instead, please use FileFormatType_Xlsm

FileFormatType_Xltx 

Represents a template xltx file.

FileFormatType_Excel2007Xltx 

Represents a template xltx file. NOTE: This member is now obsolete. Instead, please use FileFormatType_Xltx

FileFormatType_Xltm 

Represents a macro-enabled template xltm file.

FileFormatType_Xlam 

Represents an addinMacro-enabled template xltm file.

FileFormatType_Excel2007Xltm 

Represents a macro-enabled template xltm file. NOTE: This member is now obsolete. Instead, please use FileFormatType_Xltm

FileFormatType_TabDelimited 

Represents a tab delimited text file.

FileFormatType_Html 

Represents an html file.

FileFormatType_MHtml 

Represents a MHtml file.

FileFormatType_ODS 

Represents an ODS file.

FileFormatType_Excel97To2003 

Represents an Excel97-2003 xls file.

FileFormatType_Excel2003XML 

Represents an Excel 2003 xml file.

FileFormatType_Xlsb 

Represents an xlsb file.

FileFormatType_Excel2007Xlsb 

Represents an xlsb file. NOTE: This member is now obsolete. Instead, please use FileFormatType_Xlsb

FileFormatType_Unknown 

Represents unrecognized format, cannot be loaded.

FileFormatType_Pdf 

Represents a Pdf file.

FileFormatType_XPS 

Represents an XPS file.

FileFormatType_TIFF 

Represents a TIFF file.

FileFormatType_SVG 

Represents an SVG file.

FileFormatType_Excel95 

Represents an Excel95 xls file.

The file format is not supported

FileFormatType_Excel4 

Represents an Excel4.0 xls file.

The file format is not supported

FileFormatType_Excel3 

Represents an Excel3.0 xls file.

The file format is not supported

FileFormatType_Excel2 

Represents an Excel2.1 xls file.

The file format is not supported

FileFormatType_Pptx 

Represents a Pptx file.

The file format is not supported Only for detecting file type.

FileFormatType_Docx 

Represents a Docx file.

The file format is not supported Only for detecting file type.

FileFormatType_Dif 

Data Interchange Format.

FileFormatType_Doc 

Represents a doc file.

The file format is not supported Only for detecting file type.

FileFormatType_Ppt 

Represents a ppt file.

The file format is not supported Only for detecting file type.

FileFormatType_MapiMessage 

Represents an email file.

The file format is not supported Only for detecting file type.

FileFormatType_MSEquation 

Represents the MS Equation 3.0 object.

The file format is not supported Only for detecting file type.

FileFormatType_Ole10Native 

Represents the embedded native object.

The file format is not supported Only for detecting file type.

FileFormatType_VSD 

Represents MS Visio VSD binary format.

The file format is not supported Only for detecting file type.

FileFormatType_VSDX 

MS Visio 2013 VSDX file format.

The file format is not supported Only for detecting file type.

FileFormatType_Docm 

Represents a docm file.

The file format is not supported Only for detecting file type.

FileFormatType_Dotx 

Represents a dotx file.

The file format is not supported Only for detecting file type.

FileFormatType_Dotm 

Represents a dotm file.

The file format is not supported Only for detecting file type.

FileFormatType_Pptm 

Represents a pptm file.

The file format is not supported Only for detecting file type.

FileFormatType_Potx 

Represents a Potx file.

The file format is not supported Only for detecting file type.

FileFormatType_Potm 

Represents a Potm file.

The file format is not supported Only for detecting file type.

FileFormatType_Ppsx 

Represents a ppsx file.

The file format is not supported Only for detecting file type.

FileFormatType_Ppsm 

Represents a ppsm file.

The file format is not supported Only for detecting file type.

FileFormatType_Ooxml 

Represents office open xml file (such as xlsx, docx,pptx, etc).

The file format is not supported Only for detecting file type. If the office open xml file is encrypted, it could not be dectected as xlsx ,docx, pptx,etc.

FileFormatType_ODT 

Represents an odt file.

The file format is not supported Only for detecting file type.

FileFormatType_ODP 

Represents an odp file.

The file format is not supported Only for detecting file type.

FileFormatType_ODF 

Represents an odf file.

The file format is not supported Only for detecting file type.

FileFormatType_ODG 

Represents an odg file.

The file format is not supported Only for detecting file type.

FileFormatType_XML 

Represents a simple xml file.

The file format is not supported Only for detecting file type.

FileFormatType_Xlt 

Represents a template xlt file.

FileFormatType_OTT 

Represents an odt file.

The file format is not supported Only for detecting file type.

FileFormatType_BMP 

Represents a bmp file.

The file format is not supported Only for detecting file type.

FileFormatType_OTS 

Represents a ods file.

§ FilterOperatorType

Custom Filter operator type.

Enumerator
FilterOperatorType_LessOrEqual 

Represents LessOrEqual operator.

FilterOperatorType_LessThan 

Represents LessThan operator.

FilterOperatorType_Equal 

Represents Equal operator.

FilterOperatorType_GreaterThan 

Represents GreaterThan operator.

FilterOperatorType_NotEqual 

Represents NotEqual operator.

FilterOperatorType_GreaterOrEqual 

Represents GreaterOrEqual operator.

FilterOperatorType_None 

Represents no comparision.

§ FontUnderlineType

Enumerates the font underline types.

Enumerator
FontUnderlineType_None 

Represents no underline.

FontUnderlineType_Single 

Represents single underline.

FontUnderlineType_Double 

Represents double underline.

FontUnderlineType_Accounting 

Represents single accounting underline.

FontUnderlineType_DoubleAccounting 

Represents double accounting underline.

FontUnderlineType_Dash 

Represents Dashed Underline

FontUnderlineType_DashDotDotHeavy 

Represents Thick Dash-Dot-Dot Underline

FontUnderlineType_DashDotHeavy 

Represents Thick Dash-Dot Underline

FontUnderlineType_DashedHeavy 

Represents Thick Dashed Underline

FontUnderlineType_DashLong 

Represents Long Dashed Underline

FontUnderlineType_DashLongHeavy 

Represents Thick Long Dashed Underline

FontUnderlineType_DotDash 

Represents Dash-Dot Underline

FontUnderlineType_DotDotDash 

Represents Dash-Dot-Dot Underline

FontUnderlineType_Dotted 

Represents Dotted Underline

FontUnderlineType_DottedHeavy 

Represents Thick Dotted Underline

FontUnderlineType_Heavy 

Represents Thick Underline

FontUnderlineType_Wave 

Represents Wave Underline

FontUnderlineType_WavyDouble 

Represents Double Wave Underline

FontUnderlineType_WavyHeavy 

Represents Heavy Wave Underline

FontUnderlineType_Words 

Represents Underline Non-Space Characters Only

§ FormatConditionType

Conditional format rule type.

Enumerator
FormatConditionType_CellValue 

This conditional formatting rule compares a cell value to a formula calculated result, using an operator.

FormatConditionType_Expression 

This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.

FormatConditionType_ColorScale 

This conditional formatting rule creates a gradated color scale on the cells.

FormatConditionType_DataBar 

This conditional formatting rule displays a gradated data bar in the range of cells.

FormatConditionType_IconSet 

This conditional formatting rule applies icons to cells according to their values.

FormatConditionType_Top10 

This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.

FormatConditionType_UniqueValues 

This conditional formatting rule highlights unique values in the range.

FormatConditionType_DuplicateValues 

This conditional formatting rule highlights duplicated values.

FormatConditionType_ContainsText 

This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text.

FormatConditionType_NotContainsText 

This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.

FormatConditionType_BeginsWith 

This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values.

FormatConditionType_EndsWith 

This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.

FormatConditionType_ContainsBlanks 

This conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.

FormatConditionType_NotContainsBlanks 

This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.

FormatConditionType_ContainsErrors 

This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.

FormatConditionType_NotContainsErrors 

This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.

FormatConditionType_TimePeriod 

This conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated. For example, with a cell containing the value 38913 the conditional format shall be applied if the rule requires a value of 7/14/2006.

FormatConditionType_AboveAverage 

This conditional formatting rule highlights cells that are above or below the average for all values in the range.

§ FormatConditionValueType

Condition value type.

Enumerator
FormatConditionValueType_Formula 

The minimum/ midpoint / maximum value for the gradient is determined by a formula.

FormatConditionValueType_Max 

Indicates that the maximum value in the range shall be used as the maximum value for the gradient.

FormatConditionValueType_Min 

Indicates that the minimum value in the range shall be used as the minimum value for the gradient.

FormatConditionValueType_Number 

Indicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value.

FormatConditionValueType_Percent 

Value indicates a percentage between the minimum and maximum values in the range shall be used as the minimum / midpoint / maximum value for the gradient.

FormatConditionValueType_Percentile 

Value indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient.

FormatConditionValueType_AutomaticMax 

Indicates that the Automatic maximum value in the range shall be used as the Automatic maximum value for the gradient.

FormatConditionValueType_AutomaticMin 

Indicates that the Automatic minimum value in the range shall be used as the Automatic minimum value for the gradient.

§ IconSetType

Icon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible.

Enumerator
IconSetType_Arrows3 

3 arrows icon set.

IconSetType_ArrowsGray3 

3 gray arrows icon set.

IconSetType_Flags3 

3 flags icon set.

IconSetType_Signs3 

3 signs icon set.

IconSetType_Symbols3 

3 symbols icon set (circled).

IconSetType_Symbols32 

3 Symbols icon set (uncircled).

IconSetType_TrafficLights31 

3 traffic lights icon set (unrimmed).

IconSetType_TrafficLights32 

3 traffic lights icon set with thick black border.

IconSetType_Arrows4 

4 arrows icon set.

IconSetType_ArrowsGray4 

4 gray arrows icon set.

IconSetType_Rating4 

4 ratings icon set.

IconSetType_RedToBlack4 

4 'red to black' icon set.

IconSetType_TrafficLights4 

4 traffic lights icon set.

IconSetType_Arrows5 

5 arrows icon set.

IconSetType_ArrowsGray5 

5 gray arrows icon set.

IconSetType_Quarters5 

5 quarters icon set.

IconSetType_Rating5 

5 rating icon set.

IconSetType_Stars3 

3 stars set

IconSetType_Boxes5 

5 boxes set

IconSetType_Triangles3 

3 triangles set

IconSetType_None 

None

IconSetType_CustomSet 

CustomSet,this element is read-only.

§ LoadDataFilterOptions

Represents the options to filter data when loading workbook from template.

Enumerator
LoadDataFilterOptions_None 

Load nothing

LoadDataFilterOptions_All 

Load all

LoadDataFilterOptions_CellBlank 

Load cells whose value is blank

LoadDataFilterOptions_CellString 

Load cells whose value is string

LoadDataFilterOptions_CellNumeric 

Load cells whose value is numeric(including datetime)

LoadDataFilterOptions_CellError 

Load cells whose value is error

LoadDataFilterOptions_CellBool 

Load cells whose value is bool

LoadDataFilterOptions_CellValue 

Load cells value(all value types) only

LoadDataFilterOptions_Style 

Load styles for cell formatting

LoadDataFilterOptions_Formula 

Load formulas including defined Names

LoadDataFilterOptions_CellData 

Load cells data including values, formulas and formatting

LoadDataFilterOptions_DocumentProperties 

Load document properties

LoadDataFilterOptions_Chart 

Load charts

LoadDataFilterOptions_Shape 

Load shapes

LoadDataFilterOptions_MergedArea 

Load merged cells

LoadDataFilterOptions_ConditionalFormatting 

Load conditional formatting

LoadDataFilterOptions_DataValidation 

Load data validations

LoadDataFilterOptions_PivotTable 

Load pivot tables

LoadDataFilterOptions_Table 

Load tables

LoadDataFilterOptions_Settings 

Load settings for workbook and worksheet.

§ LoadFormat

Represents the load file format.

Enumerator
LoadFormat_Auto 

Represents recognizing the format automatically.

LoadFormat_CSV 

Represents a CSV file.

LoadFormat_Xlsx 

Represents Office Open XML spreadsheetML workbook or template, with or without macros.

LoadFormat_TabDelimited 

Represents a tab delimited text file.

LoadFormat_Html 

Represents an html file.

LoadFormat_MHtml 

Represents a mhtml file.

LoadFormat_ODS 

Represents an ods file.

LoadFormat_Excel97To2003 

Represents an Excel97-2003 xls file.

LoadFormat_SpreadsheetML 

Represents an Excel 2003 xml file.

LoadFormat_Xlsb 

Represents an xlsb file.

LoadFormat_Unknown 

Represents unrecognized format, cannot be loaded.

§ LookAtType

Represents look at type.

Enumerator
LookAtType_Contains 

Cell value Contains the find object.

LookAtType_StartWith 

Cell value Starts with the find object.

LookAtType_EndWith 

Cell value ends with the find object.

LookAtType_EntireContent 

Cell value is same as the find object.

§ LookInType

Represents look in type.

Enumerator
LookInType_Formulas 

If the cell contains a formula, find it from formula. Else find object from the formula.

LookInType_Values 

Only find object from the formatted values.

LookInType_ValuesExcludeFormulaCell 

Only find object from the values of cells which do not contains formula.

LookInType_Comments 

Only find object from the comments.

LookInType_OnlyFormulas 

Only find object from formulas.

LookInType_OriginalValues 

Only find object from the original values.

§ MemorySetting

Memory usage options.

Enumerator
MemorySetting_Normal 

Default option. This option is applied for all versions.

MemorySetting_MemoryPreference 

Optimized for memory usage. This option may degrade performance in some special cases and which will be used later.

§ NumberCategoryType

Represents category type of cell's number formatting.

Enumerator
NumberCategoryType_General 

General

NumberCategoryType_Text 

Text

NumberCategoryType_Number 

Number

NumberCategoryType_Date 

Date or Date and Time

NumberCategoryType_Time 

Time

NumberCategoryType_Fraction 

Fraction

NumberCategoryType_Scientific 

Scientific

§ OperatorType

Represents the operator type of conditional format and data validation.

Enumerator
OperatorType_Between 

Represents Between operator of conditional format and data validation.

OperatorType_Equal 

Represents Equal operator of conditional format and data validation.

OperatorType_GreaterThan 

Represents GreaterThan operator of conditional format and data validation.

OperatorType_GreaterOrEqual 

Represents GreaterOrEqual operator of conditional format and data validation.

OperatorType_LessThan 

Represents LessThan operator of conditional format and data validation.

OperatorType_LessOrEqual 

Represents LessOrEqual operator of conditional format and data validation.

OperatorType_None 

Represents no comparision.

OperatorType_NotBetween 

Represents NotBetween operator of conditional format and data validation.

OperatorType_NotEqual 

Represents NotEqual operator of conditional format and data validation.

§ PageOrientationType

Represents print orientation constants.

Enumerator
PageOrientationType_Landscape 

Landscape orientation

PageOrientationType_Portrait 

Portrait orientation

§ PaperSizeType

Represents paper size constants.

Enumerator
PaperSizeType_PaperLetter 

Letter (8-1/2 in. x 11 in.)

PaperSizeType_PaperLetterSmall 

Letter Small (8-1/2 in. x 11 in.)

PaperSizeType_PaperTabloid 

Tabloid (11 in. x 17 in.)

PaperSizeType_PaperLedger 

Ledger (17 in. x 11 in.)

PaperSizeType_PaperLegal 

Legal (8-1/2 in. x 14 in.)

PaperSizeType_PaperStatement 

Statement (5-1/2 in. x 8-1/2 in.)

PaperSizeType_PaperExecutive 

Executive (7-1/4 in. x 10-1/2 in.)

PaperSizeType_PaperA3 

A3 (297 mm x 420 mm)

PaperSizeType_PaperA4 

A4 (210 mm x 297 mm)

PaperSizeType_PaperA4Small 

A4 Small (210 mm x 297 mm)

PaperSizeType_PaperA5 

A5 (148 mm x 210 mm)

PaperSizeType_PaperB4 

JIS B4 (257 mm x 364 mm)

PaperSizeType_PaperB5 

JIS B5 (182 mm x 257 mm)

PaperSizeType_PaperFolio 

Folio (8-1/2 in. x 13 in.)

PaperSizeType_PaperQuarto 

Quarto (215 mm x 275 mm)

PaperSizeType_Paper10x14 

10 in. x 14 in.

PaperSizeType_Paper11x17 

11 in. x 17 in.

PaperSizeType_PaperNote 

Note (8-1/2 in. x 11 in.)

PaperSizeType_PaperEnvelope9 

Envelope #9 (3-7/8 in. x 8-7/8 in.)

PaperSizeType_PaperEnvelope10 

Envelope #10 (4-1/8 in. x 9-1/2 in.)

PaperSizeType_PaperEnvelope11 

Envelope #11 (4-1/2 in. x 10-3/8 in.)

PaperSizeType_PaperEnvelope12 

Envelope #12 (4-1/2 in. x 11 in.)

PaperSizeType_PaperEnvelope14 

Envelope #14 (5 in. x 11-1/2 in.)

PaperSizeType_PaperCSheet 

C size sheet

PaperSizeType_PaperDSheet 

D size sheet

PaperSizeType_PaperESheet 

E size sheet

PaperSizeType_PaperEnvelopeDL 

Envelope DL (110 mm x 220 mm)

PaperSizeType_PaperEnvelopeC5 

Envelope C5 (162 mm x 229 mm)

PaperSizeType_PaperEnvelopeC3 

Envelope C3 (324 mm x 458 mm)

PaperSizeType_PaperEnvelopeC4 

Envelope C4 (229 mm x 324 mm)

PaperSizeType_PaperEnvelopeC6 

Envelope C6 (114 mm x 162 mm)

PaperSizeType_PaperEnvelopeC65 

Envelope C65 (114 mm x 229 mm)

PaperSizeType_PaperEnvelopeB4 

Envelope B4 (250 mm x 353 mm)

PaperSizeType_PaperEnvelopeB5 

Envelope B5 (176 mm x 250 mm)

PaperSizeType_PaperEnvelopeB6 

Envelope B6 (176 mm x 125 mm)

PaperSizeType_PaperEnvelopeItaly 

Envelope Italy (110 mm x 230 mm)

PaperSizeType_PaperEnvelopeMonarch 

Envelope Monarch (3-7/8 in. x 7-1/2 in.)

PaperSizeType_PaperEnvelopePersonal 

Envelope (3-5/8 in. x 6-1/2 in.)

PaperSizeType_PaperFanfoldUS 

U.S. Standard Fanfold (14-7/8 in. x 11 in.)

PaperSizeType_PaperFanfoldStdGerman 

German Standard Fanfold (8-1/2 in. x 12 in.)

PaperSizeType_PaperFanfoldLegalGerman 

German Legal Fanfold (8-1/2 in. x 13 in.)

PaperSizeType_PaperISOB4 

B4 (ISO) 250 x 353 mm

PaperSizeType_PaperJapanesePostcard 

Japanese Postcard (100mm 148mm)

PaperSizeType_Paper9x11 

9? 11?

PaperSizeType_Paper10x11 

10? 11?

PaperSizeType_Paper15x11 

15? 11?

PaperSizeType_PaperEnvelopeInvite 

Envelope Invite (220mm 220mm)

PaperSizeType_PaperLetterExtra 

US Letter Extra 9 \275 x 12 in

PaperSizeType_PaperLegalExtra 

US Legal Extra 9 \275 x 15 in

PaperSizeType_PaperTabloidExtra 

US Tabloid Extra 11.69 x 18 in

PaperSizeType_PaperA4Extra 

A4 Extra 9.27 x 12.69 in

PaperSizeType_PaperLetterTransverse 

Letter Transverse 8 \275 x 11 in

PaperSizeType_PaperA4Transverse 

A4 Transverse 210 x 297 mm

PaperSizeType_PaperLetterExtraTransverse 

Letter Extra Transverse 9\275 x 12 in

PaperSizeType_PaperSuperA 

SuperA/SuperA/A4 227 x 356 mm

PaperSizeType_PaperSuperB 

SuperB/SuperB/A3 305 x 487 mm

PaperSizeType_PaperLetterPlus 

US Letter Plus 8.5 x 12.69 in

PaperSizeType_PaperA4Plus 

A4 Plus 210 x 330 mm

PaperSizeType_PaperA5Transverse 

A5 Transverse 148 x 210 mm

PaperSizeType_PaperJISB5Transverse 

B5 (JIS) Transverse 182 x 257 mm

PaperSizeType_PaperA3Extra 

A3 Extra 322 x 445 mm

PaperSizeType_PaperA5Extra 

A5 Extra 174 x 235 mm

PaperSizeType_PaperISOB5Extra 

B5 (ISO) Extra 201 x 276 mm

PaperSizeType_PaperA2 

A2 420 x 594 mm

PaperSizeType_PaperA3Transverse 

A3 Transverse 297 x 420 mm

PaperSizeType_PaperA3ExtraTransverse 

A3 Extra Transverse 322 x 445 mm

PaperSizeType_PaperJapaneseDoublePostcard 

Japanese Double Postcard 200 x 148 mm

PaperSizeType_PaperA6 

A6 105 x 148 mm

PaperSizeType_PaperJapaneseEnvelopeKaku2 

Japanese Envelope Kaku #2

PaperSizeType_PaperJapaneseEnvelopeKaku3 

Japanese Envelope Kaku #3

PaperSizeType_PaperJapaneseEnvelopeChou3 

Japanese Envelope Chou #3

PaperSizeType_PaperJapaneseEnvelopeChou4 

Japanese Envelope Chou #4

PaperSizeType_PaperLetterRotated 

11in 8.5in

PaperSizeType_PaperA3Rotated 

420mm 297mm

PaperSizeType_PaperA4Rotated 

297mm 210mm

PaperSizeType_PaperA5Rotated 

210mm 148mm

PaperSizeType_PaperJISB4Rotated 

B4 (JIS) Rotated 364 x 257 mm

PaperSizeType_PaperJISB5Rotated 

B5 (JIS) Rotated 257 x 182 mm

PaperSizeType_PaperJapanesePostcardRotated 

Japanese Postcard Rotated 148 x 100 mm

PaperSizeType_PaperJapaneseDoublePostcardRotated 

Double Japanese Postcard Rotated 148 x 200 mm

PaperSizeType_PaperA6Rotated 

A6 Rotated 148 x 105 mm

PaperSizeType_PaperJapaneseEnvelopeKaku2Rotated 

Japanese Envelope Kaku #2 Rotated

PaperSizeType_PaperJapaneseEnvelopeKaku3Rotated 

Japanese Envelope Kaku #3 Rotated

PaperSizeType_PaperJapaneseEnvelopeChou3Rotated 

Japanese Envelope Chou #3 Rotated

PaperSizeType_PaperJapaneseEnvelopeChou4Rotated 

Japanese Envelope Chou #4 Rotated

PaperSizeType_PaperJISB6 

B6 (JIS) 128 x 182 mm

PaperSizeType_PaperJISB6Rotated 

B6 (JIS) Rotated 182 x 128 mm

PaperSizeType_Paper12x11 

12 x 11 in

PaperSizeType_PaperJapaneseEnvelopeYou4 

Japanese Envelope You #4

PaperSizeType_PaperJapaneseEnvelopeYou4Rotated 

Japanese Envelope You #4 Rotated

PaperSizeType_PaperPRC16K 

PRC 16K 146 x 215 mm

PaperSizeType_PaperPRC32K 

PRC 32K 97 x 151 mm

PaperSizeType_PaperPRCBig32K 

PRC 32K (Big) 97 x 151 mm

PaperSizeType_PaperPRCEnvelope1 

PRC Envelope #1 102 x 165 mm

PaperSizeType_PaperPRCEnvelope2 

PRC Envelope #2 102 x 176 mm

PaperSizeType_PaperPRCEnvelope3 

PRC Envelope #3 125 x 176 mm

PaperSizeType_PaperPRCEnvelope4 

PRC Envelope #4 110 x 208 mm

PaperSizeType_PaperPRCEnvelope5 

PRC Envelope #5 110 x 220 mm

PaperSizeType_PaperPRCEnvelope6 

PRC Envelope #6 120 x 230 mm

PaperSizeType_PaperPRCEnvelope7 

PRC Envelope #7 160 x 230 mm

PaperSizeType_PaperPRCEnvelope8 

PRC Envelope #8 120 x 309 mm

PaperSizeType_PaperPRCEnvelope9 

PRC Envelope #9 229 x 324 mm

PaperSizeType_PaperPRCEnvelope10 

PRC Envelope #10 324 x 458 mm

PaperSizeType_PaperPRC16KRotated 

PRC 16K Rotated

PaperSizeType_PaperPRC32KRotated 

PRC 32K Rotated

PaperSizeType_PaperPRCBig32KRotated 

PRC 32K (Big) Rotated

PaperSizeType_PaperPRCEnvelope1Rotated 

PRC Envelope #1 Rotated 165 x 102 mm

PaperSizeType_PaperPRCEnvelope2Rotated 

PRC Envelope #2 Rotated 176 x 102 mm

PaperSizeType_PaperPRCEnvelope3Rotated 

PRC Envelope #3 Rotated 176 x 125 mm

PaperSizeType_PaperPRCEnvelope4Rotated 

PRC Envelope #4 Rotated 208 x 110 mm

PaperSizeType_PaperPRCEnvelope5Rotated 

PRC Envelope #5 Rotated 220 x 110 mm

PaperSizeType_PaperPRCEnvelope6Rotated 

PRC Envelope #6 Rotated 230 x 120 mm

PaperSizeType_PaperPRCEnvelope7Rotated 

PRC Envelope #7 Rotated 230 x 160 mm

PaperSizeType_PaperPRCEnvelope8Rotated 

PRC Envelope #8 Rotated 309 x 120 mm

PaperSizeType_PaperPRCEnvelope9Rotated 

PRC Envelope #9 Rotated 324 x 229 mm

PaperSizeType_PaperPRCEnvelope10Rotated 

PRC Envelope #10 Rotated 458 x 324 mm

PaperSizeType_PaperB3 

Usual B3 (13.9 x 19.7 in)

PaperSizeType_PaperBusinessCard 

Business Card (90mm x 55 mm)

PaperSizeType_PaperThermal 

Thermal (3 x 11 in)

§ ParameterType

Represent all parameters' type or return value type of function.

Enumerator
ParameterType_Reference 
ParameterType_Value 
ParameterType_Array 

§ PasteType

Represents the paste special type.

Enumerator
PasteType_All 

Copies all data of the range.

PasteType_Default 

It works as "All" behavior of MS Excel.

PasteType_AllExceptBorders 

Copies all data of the range withoutd the range.

PasteType_DefaultExceptBorders 

It works as "All except borders" behavior of MS Excel.

PasteType_ColumnWidths 

Only copies the widths of the range.

PasteType_RowHeights 

Only copies the heights of the range.

PasteType_Comments 
PasteType_Formats 
PasteType_Formulas 
PasteType_FormulasAndNumberFormats 
PasteType_Validation 
PasteType_Values 
PasteType_ValuesAndNumberFormats 

§ PrintCommentsType

Represents the way comments are printed with the sheet.

Enumerator
PrintCommentsType_PrintInPlace 

Represents to print comments as displayed on sheet.

PrintCommentsType_PrintNoComments 

Represents not to print comments.

PrintCommentsType_PrintSheetEnd 

Represents to print comments at end of sheet.

§ PrintErrorsType

Represents print errors constants.

Enumerator
PrintErrorsType_PrintErrorsBlank 

Represents not to print errors.

PrintErrorsType_PrintErrorsDash 

Represents to print errors as "--".

PrintErrorsType_PrintErrorsDisplayed 

Represents to print errors as displayed.

PrintErrorsType_PrintErrorsNA 

Represents to print errors as "#N/A".

§ PrintOrderType

Represent print order constants.

Enumerator
PrintOrderType_DownThenOver 

Down, then over

PrintOrderType_OverThenDown 

Over, then down

§ ProtectionType

Represents workbook/worksheet protection type.

Enumerator
ProtectionType_All 

Represents to protect all.

ProtectionType_Contents 

Represents to protect contents, used in Worksheet protection.

ProtectionType_Objects 

Represents to protect objects, used in Worksheet protection.

ProtectionType_Scenarios 

Represents to protect scenarios, used in Worksheet protection.

ProtectionType_Structure 

Represents to protect structure, used in Workbook protection.

ProtectionType_Windows 

Represents to protect window, used in Workbook protection.

ProtectionType_None 

Represents no protection. Only for Reading property.

§ SaveFormat

Represents the format in which the workbook is saved.

Enumerator
SaveFormat_CSV 

Represents a CSV file.

SaveFormat_Xlsx 

Represents an xlsx file.

SaveFormat_Xlsm 

Represents an xlsm file which enable macros.

SaveFormat_Xltx 

Represents an xltx file.

SaveFormat_Xltm 

Represents an xltm file which enable macros.

SaveFormat_Xlam 

Represents an xltm file which enable adding macros.

SaveFormat_TabDelimited 

Represents a tab delimited text file.

SaveFormat_Html 

Represents an html file.

SaveFormat_MHtml 

Represents a mhtml file.

SaveFormat_ODS 

Represents an ods file.

SaveFormat_Excel97To2003 

Represents an Excel97-2003 xls file.

SaveFormat_SpreadsheetML 

Represents an Excel 2003 xml file.

SaveFormat_Xlsb 

Represents an xlsb file.

SaveFormat_Auto 

If saving the file to the disk, the file format accords to the extension of the file name. If saving the file to the stream, the file format is xlsx.

SaveFormat_Unknown 

Represents unrecognized format, cannot be saved.

SaveFormat_Pdf 

Represents a Pdf file.

SaveFormat_XPS 

Represents an XPS file.

SaveFormat_TIFF 

Represents a TIFF file.

SaveFormat_SVG 

Represents an SVG file.

SaveFormat_Dif 

Data Interchange Format.

§ SheetType

Specifies the worksheet type.

Enumerator
SheetType_VB 

Visual Basic module

SheetType_Worksheet 
SheetType_Chart 

Chart

SheetType_BIFF4Macro 

BIFF4 Macro sheet

SheetType_Other 

§ ShiftType

Represent the shift options when deleting a range of cells.

Enumerator
ShiftType_Down 

Shift cells down.

ShiftType_Left 

Shift cells left.

ShiftType_None 

Do not shift cells.

ShiftType_Right 

Shift cells right.

ShiftType_Up 

Shift cells up.

§ SortOrder

Represents sort order for the data range.

Enumerator
SortOrder_Ascending 
SortOrder_Descending 

§ StyleModifyFlag

The style modified flags.

Enumerator
StyleModifyFlag_All 
StyleModifyFlag_Borders 
StyleModifyFlag_LeftBorder 
StyleModifyFlag_RightBorder 
StyleModifyFlag_TopBorder 
StyleModifyFlag_BottomBorder 
StyleModifyFlag_HorizontalBorder 

Only for dynamic style, such as conditional formatting.

StyleModifyFlag_VerticalBorder 

Only for dynamic style, such as conditional formatting.

StyleModifyFlag_Diagonal 
StyleModifyFlag_DiagonalDownBorder 
StyleModifyFlag_DiagonalUpBorder 
StyleModifyFlag_Font 
StyleModifyFlag_FontSize 
StyleModifyFlag_FontName 
StyleModifyFlag_FontFamily 
StyleModifyFlag_FontCharset 
StyleModifyFlag_FontColor 
StyleModifyFlag_FontWeight 
StyleModifyFlag_FontItalic 
StyleModifyFlag_FontUnderline 
StyleModifyFlag_FontStrike 
StyleModifyFlag_FontSubscript 

NOTE: This member is now obsolete. Instead, please use StyleModifyFlag_FontScript.

StyleModifyFlag_FontSuperscript 

NOTE: This member is now obsolete. Instead, please use StyleModifyFlag_FontScript.

StyleModifyFlag_FontScript 
StyleModifyFlag_NumberFormat 
StyleModifyFlag_HorizontalAlignment 
StyleModifyFlag_VerticalAlignment 
StyleModifyFlag_Indent 
StyleModifyFlag_Rotation 
StyleModifyFlag_WrapText 
StyleModifyFlag_ShrinkToFit 
StyleModifyFlag_TextDirection 
StyleModifyFlag_CellShading 
StyleModifyFlag_Pattern 
StyleModifyFlag_ForegroundColor 
StyleModifyFlag_BackgroundColor 
StyleModifyFlag_Locked 
StyleModifyFlag_HideFormula 
StyleModifyFlag_AlignmentSettings 

Includes horizontal/vertical Alignment, rotation,wrap Text,indent,shrinkToFit,Text Direction

StyleModifyFlag_FontScheme 

Unused.

StyleModifyFlag_FontDirty 

Unused.

StyleModifyFlag_FontSpellingError 

Unused.

StyleModifyFlag_FontUFillTx 

Unused.

StyleModifyFlag_FontSpacing 

Unused.

StyleModifyFlag_FontKerning 

Unused.

StyleModifyFlag_FontEqualize 

Unused.

StyleModifyFlag_FontCap 

Unused.

§ TextAlignmentType

Enumerates text alignment types.

Enumerator
TextAlignmentType_Bottom 

Represents bottom text alignment.

TextAlignmentType_Center 

Represents center text alignment.

TextAlignmentType_CenterAcross 

Represents center across text alignment.

TextAlignmentType_Distributed 

Represents distributed text alignment.

TextAlignmentType_Fill 

Represents fill text alignment.

TextAlignmentType_General 

Represents general text alignment.

TextAlignmentType_Justify 

Represents justify text alignment.

TextAlignmentType_Left 

Represents left text alignment.

TextAlignmentType_Right 

Represents right text alignment.

TextAlignmentType_Top 

Represents top text alignment.

TextAlignmentType_JustifiedLow 

Aligns the text with an adjusted kashida length for Arabic text.

TextAlignmentType_ThaiDistributed 

Distributes Thai text specially, because each character is treated as a word.

§ TextCapsType

This type specifies the cap types of the text.

Enumerator
TextCapsType_None 

None caps.

TextCapsType_All 

Apply all caps on the text.

TextCapsType_Small 

Apply small caps to the text.

§ TextDirectionType

Represents the direction of the text flow for this paragraph.

Enumerator
TextDirectionType_Context 
TextDirectionType_LeftToRight 
TextDirectionType_RightToLeft 

§ TextStrikeType

This type specifies the strike type.

Enumerator
TextStrikeType_Single 

A single strikethrough applied on the text

TextStrikeType_Double 

A double strikethrough applied on the text

TextStrikeType_None 

No strike is applied to the text

§ ThemeColorType

Enumerates the theme color types.

Enumerator
ThemeColorType_Background1 
ThemeColorType_Text1 
ThemeColorType_Background2 
ThemeColorType_Text2 
ThemeColorType_Accent1 
ThemeColorType_Accent2 
ThemeColorType_Accent3 
ThemeColorType_Accent4 
ThemeColorType_Accent5 
ThemeColorType_Accent6 
ThemeColorType_Hyperlink 
ThemeColorType_FollowedHyperlink 
ThemeColorType_StyleColor 

Inner used. A color used in theme definitions which means to use the color of the style.

§ TimePeriodType

Used in a FormatConditionType_TimePeriod conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.

Enumerator
TimePeriodType_Today 

Today's date.

TimePeriodType_Yesterday 

Yesterday's date.

TimePeriodType_Tomorrow 

Tomorrow's date.

TimePeriodType_Last7Days 

A date in the last seven days.

TimePeriodType_ThisMonth 

A date occurring in this calendar month.

TimePeriodType_LastMonth 

A date occuring in the last calendar month.

TimePeriodType_NextMonth 

A date occurring in the next calendar month.

TimePeriodType_ThisWeek 

A date occurring this week.

TimePeriodType_LastWeek 

A date occurring last week.

TimePeriodType_NextWeek 

A date occurring next week.

§ TxtLoadStyleStrategy

Specifies how to apply style for parsed values when converting string value to number or datetime.

Enumerator
TxtLoadStyleStrategy_None 

Does not set style for the parsed value.

TxtLoadStyleStrategy_BuiltIn 

Set the style as built-in number/datetime when the parsed value are plain numeric/datetime values.

When ms excel parsing datetime or numeric values according to user's input(such as CSV file), the formatting of those values may be changed, such as leading/tailing zeros of number, year/month/day order of datetime, ...etc. This type is for simulating ms excel's behavior.

TxtLoadStyleStrategy_ExactFormat 

Set the exact custom format for the parsed value to make the formatted value be same with the original input one.

§ TxtValueQuoteType

Specifies the type of using quotation marks for values in text format files.

Enumerator
TxtValueQuoteType_Normal 

All values that contain special characters such as quotation mark, separator character will be quoted. Same with the behavior of ms excel for exporting text file.

TxtValueQuoteType_Always 

All values will be quoted always.

TxtValueQuoteType_Minimum 

Only quote values when needed. Such as, if one value contains quotation mark but the quotation mark is not at the begin of this value, this value will not be quoted.

TxtValueQuoteType_Never 

All values will not be quoted. The exported text file with this type may not be read back correctly because the needed quotation marks being absent.

§ UpdateLinksType

Represents how to update links to other workbooks when the workbook is opened.

Enumerator
UpdateLinksType_UserSet 

Prompt user to update.

UpdateLinksType_Never 

Do not update, and do not prompt user.

UpdateLinksType_Always 

Always update.

§ ValidationAlertType

Represents the data validation alert style.

Enumerator
ValidationAlertType_Information 

Information alert style.

ValidationAlertType_Stop 

Stop alert style.

ValidationAlertType_Warning 

Warning alert style.

§ ValidationType

Represents data validation type.

Enumerator
ValidationType_AnyValue 

Any value validation type.

ValidationType_WholeNumber 

Whole number validation type.

ValidationType_Decimal 

Decimal validation type.

ValidationType_List 

List validation type.

ValidationType_Date 

Date validation type.

ValidationType_Time 

Time validation type.

ValidationType_TextLength 

Text length validation type.

ValidationType_Custom 

Custom validation type.

§ ViewType

Represents the view type of the worksheet.

Enumerator
ViewType_NormalView 
ViewType_PageBreakPreview 
ViewType_PageLayoutView 

§ VisibilityType

Represents the states for sheet visibility.

Enumerator
VisibilityType_Hidden 

Indicates the sheet is hidden, but can be shown by the user via the user interface.

VisibilityType_VeryHidden 

Indicates the sheet is hidden and cannot be shown in the user interface (UI). This state is only available programmatically.

VisibilityType_Visible 

Indicates the sheet is visible.