Aspose::Cells Namespace Reference

Namespaces

 Charts
 
 DigitalSignatures
 
 Drawing
 
 
 Pivot
 
 Properties
 
 Rendering
 
 Tables
 
 Vba
 

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  IAutoFitterOptions
 Represents all auto fitter options. 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
 
class  IColumnCollection
 Collects the IColumn objects that represent the individual columns in a worksheet. More...
 
class  IComment
 Encapsulates the object that represents a cell comment. More...
 
class  ICommentCollection
 Encapsulates a collection of IComment objects. 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  IFilterColumn
 Represents a filter for a single column. The Filter object is a member of the Filters collection More...
 
class  IFilterColumnCollection
 A collection of Filter objects that represents all the filters in an autofiltered range. 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  IHeaderFooterCommand
 Represents the command of header/footer More...
 
class  IHorizontalPageBreak
 Encapsulates the object that represents a horizontal page break. More...
 
class  IHorizontalPageBreakCollection
 Encapsulates a collection of IHorizontalPageBreak objects. More...
 
class  IHtmlSaveOptions
 Represents the options for saving html file. 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  ILightCellsDataProvider
 Represents Data provider for saving 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  IPdfSaveOptions
 Represents the options for saving pdf file. 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 area 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 spreadml file. More...
 
class  IStyle
 Represents display style of excel document, such as font, color, alignment, border, etc. 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  IWorkbookDesigner
 Encapsulates the object that represents a designer 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  IXlsbSaveOptions
 Represents the options for saving xlsb file. 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-in 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 calculated as the expected result. Such as formula "=-0.45+0.43+0.02", when calculating 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, CellValueFormatStrategy_DisplayString }
 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_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_None = 0, DataBarBorderType_Solid = 1 }
 Specifies the border type of a data bar. More...
 
enum  DataBarFillType { DataBarFillType_Solid = 0, DataBarFillType_Gradient = 1 }
 Specifies how a data bar is filled with color. More...
 
enum  DataBarNegativeColorType { 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_February, 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  EncryptionType { EncryptionType_XOR, EncryptionType_Compatible, EncryptionType_EnhancedCryptographicProviderV1, EncryptionType_StrongCryptographicProvider }
 Encryption Type. Only used by excel2003. We will encrypt 2007/2010 workbook using SHA AES the same as Excel does, and this EncryptionType will be ignored. 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 error check type. More...
 
enum  ErrorType {
  ErrorType_Div = 0x07, ErrorType_NA = 0x2A, ErrorType_Name = 0x1D, ErrorType_Null = 0,
  ErrorType_Number = 0x24, ErrorType_Ref = 0x17, ErrorType_Recursive = 0xFE, ErrorType_Value = 0x0F
}
 Summary description for ErrorType. 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_Permission,
  ExceptionType_UnsupportedFeature, ExceptionType_UnsupportedStream, ExceptionType_UndisclosedInformation, ExceptionType_FileCorrupted
}
 Represents custom exception type code. More...
 
enum  ExternalCellValueType {
  ExternalCellValueType_Blank = 0, ExternalCellValueType_Number = 1, ExternalCellValueType_String = 2, ExternalCellValueType_Error = 3,
  ExternalCellValueType_Bool = 4
}
 
enum  FileFormatType {
  FileFormatType_Csv = 1, FileFormatType_CSV = 1, FileFormatType_Xlsx = 6, FileFormatType_Xlsm = 7,
  FileFormatType_Xltx = 8, FileFormatType_Xltm = 9, FileFormatType_Xlam = 10, FileFormatType_Tsv = 11,
  FileFormatType_TSV = 11, FileFormatType_TabDelimited = Aspose::Cells::FileFormatType_Tsv, FileFormatType_Html = 12, FileFormatType_MHtml = 17,
  FileFormatType_Ods = 14, FileFormatType_ODS = 14, FileFormatType_Excel97To2003 = 5, FileFormatType_SpreadsheetML = 15,
  FileFormatType_Excel2003XML = 15, FileFormatType_Xlsb = 16, FileFormatType_Unknown = 255, FileFormatType_Pdf = 13,
  FileFormatType_Xps = 20, FileFormatType_XPS = 20, FileFormatType_Tiff = 21, FileFormatType_TIFF = 21,
  FileFormatType_Svg = 28, 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_MSEquation = 34, FileFormatType_Ole10Native = 35, FileFormatType_Vsd = 36,
  FileFormatType_VSD = 36, FileFormatType_Vsdx = 37, 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_ODT = 47, FileFormatType_Odp = 48, FileFormatType_ODP = 48,
  FileFormatType_Odf = 49, FileFormatType_ODF = 49, FileFormatType_Odg = 50, FileFormatType_ODG = 50,
  FileFormatType_Xml = 51, FileFormatType_XML = 51, FileFormatType_Xlt = 52, FileFormatType_Ott = 53,
  FileFormatType_OTT = 53, FileFormatType_Bmp = 54, FileFormatType_BMP = 54, FileFormatType_Ots = 55,
  FileFormatType_OTS = 55, FileFormatType_Numbers = 56, FileFormatType_Numbers09 = 56, FileFormatType_Markdown = 57,
  FileFormatType_GraphChart = 58, FileFormatType_Fods = 59, FileFormatType_FODS = 59, FileFormatType_Sxc = 60,
  FileFormatType_SXC = 60, FileFormatType_Otp = 61, FileFormatType_OTP = 61, FileFormatType_Numbers35 = 62,
  FileFormatType_Emf = 0x102, FileFormatType_Wmf = 0x103, FileFormatType_Jpg = 0x105, FileFormatType_Png = 0x106,
  FileFormatType_Gif = 0x142, FileFormatType_Json = 0x201, FileFormatType_SqlScript = 0x202
}
 Represents the file format types. More...
 
enum  FilterOperatorType {
  FilterOperatorType_LessOrEqual, FilterOperatorType_LessThan, FilterOperatorType_Equal, FilterOperatorType_GreaterThan,
  FilterOperatorType_NotEqual, FilterOperatorType_GreaterOrEqual, FilterOperatorType_None, FilterOperatorType_BeginsWith,
  FilterOperatorType_EndsWith, FilterOperatorType_Contains, FilterOperatorType_NotContains
}
 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  HeaderFooterCommandType {
  HeaderFooterCommandType_Text, HeaderFooterCommandType_CurrentPage, HeaderFooterCommandType_Pagecount, HeaderFooterCommandType_CurrentDate,
  HeaderFooterCommandType_CurrentTime, HeaderFooterCommandType_SheetName, HeaderFooterCommandType_FileName, HeaderFooterCommandType_FilePath,
  HeaderFooterCommandType_Picture
}
 Represents the command type of header and footer. More...
 
enum  HtmlCrossType {
  HtmlCrossType_Default, HtmlCrossType_MSExport, HtmlCrossType_Cross, HtmlCrossType_CrossHideRight,
  HtmlCrossType_FitToCell
}
 Represents five types of html cross string. More...
 
enum  HtmlExportDataOptions { HtmlExportDataOptions_Table = 0x01, HtmlExportDataOptions_All = 0xFF }
 Represents the options for exporting html data. More...
 
enum  HtmlHiddenColDisplayType { HtmlHiddenColDisplayType_Hidden, HtmlHiddenColDisplayType_Remove }
 Represents two types of showing the hidden columns in html. More...
 
enum  HtmlHiddenRowDisplayType { HtmlHiddenRowDisplayType_Hidden, HtmlHiddenRowDisplayType_Remove }
 Represents two types of showing the hidden rows in html. More...
 
enum  HtmlLinkTargetType { HtmlLinkTargetType_Blank, HtmlLinkTargetType_Parent, HtmlLinkTargetType_Self, HtmlLinkTargetType_Top }
 Represents the type of target attribute in HTML tag. 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, IconSetType_Smilies3, IconSetType_ColorSmilies3
}
 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 = 0x00000000, LoadDataFilterOptions_All = 0x7FFFFFFF, LoadDataFilterOptions_CellBlank = 0x00000001, LoadDataFilterOptions_CellString = 0x00000002,
  LoadDataFilterOptions_CellNumeric = 0x00000004, LoadDataFilterOptions_CellError = 0x00000008, LoadDataFilterOptions_CellBool = 0x00000010, LoadDataFilterOptions_CellValue = 0x0000001F,
  LoadDataFilterOptions_Formula = 0x00000020, LoadDataFilterOptions_CellData = 0x0400003F, LoadDataFilterOptions_Chart = 0x00000100, LoadDataFilterOptions_Shape = 0x18000200,
  LoadDataFilterOptions_Drawing = 0x18000300, LoadDataFilterOptions_MergedArea = 0x00000400, LoadDataFilterOptions_ConditionalFormatting = 0x00000800, LoadDataFilterOptions_DataValidation = 0x00001000,
  LoadDataFilterOptions_PivotTable = 0x00002000, LoadDataFilterOptions_Table = 0x00004000, LoadDataFilterOptions_Hyperlinks = 0x00008000, LoadDataFilterOptions_SheetSettings = 0x00010000,
  LoadDataFilterOptions_SheetData = 0x180FFFFF, LoadDataFilterOptions_BookSettings = 0x00100000, LoadDataFilterOptions_Settings = 0x00110000, LoadDataFilterOptions_XmlMap = 0x00200000,
  LoadDataFilterOptions_Structure = 0x00400000, LoadDataFilterOptions_DocumentProperties = 0x00800000, LoadDataFilterOptions_DefinedNames = 0x01000000, LoadDataFilterOptions_VBA = 0x02000000,
  LoadDataFilterOptions_Style = 0x04000000, LoadDataFilterOptions_Picture = 0x08000000, LoadDataFilterOptions_OleObject = 0x10000000, LoadDataFilterOptions_Revision = 0x20000000
}
 Represents the options to filter data when loading workbook from template. More...
 
enum  LoadFormat {
  LoadFormat_Auto, LoadFormat_Csv = 1, LoadFormat_CSV = 1, LoadFormat_Xlsx = 6,
  LoadFormat_Tsv = 11, LoadFormat_TSV = 11, LoadFormat_TabDelimited = Aspose::Cells::LoadFormat_Tsv, LoadFormat_Html = 12,
  LoadFormat_MHtml = 13, LoadFormat_Ods = 14, LoadFormat_ODS = 14, LoadFormat_Excel97To2003 = 5,
  LoadFormat_SpreadsheetML = 15, LoadFormat_Xlsb = 16, LoadFormat_Ots = 31, LoadFormat_Numbers = 56,
  LoadFormat_Fods = 59, LoadFormat_FODS = 59, LoadFormat_Sxc = 60, LoadFormat_SXC = 60,
  LoadFormat_Xml = 51, LoadFormat_Unknown = 255, LoadFormat_Image = 254, LoadFormat_Json = 0x201
}
 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, PaperSizeType_Custom = 0
}
 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_ValuesAndFormats, 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  PrintingPageType { PrintingPageType_Default = 0, PrintingPageType_IgnoreBlank = 1, PrintingPageType_IgnoreStyle = 2 }
 Indicates which pages will not be printed. More...
 
enum  PrintOrderType { PrintOrderType_DownThenOver, PrintOrderType_OverThenDown }
 Represent print order constants. More...
 
enum  PrintSizeType { PrintSizeType_Full, PrintSizeType_Fit, PrintSizeType_Custom }
 Represents the printed chart size. 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_CSV = 1, SaveFormat_Xlsx = 6, SaveFormat_Xlsm = 7,
  SaveFormat_Xltx = 8, SaveFormat_Xltm = 9, SaveFormat_Xlam = 10, SaveFormat_Tsv = 11,
  SaveFormat_TSV = 11, SaveFormat_TabDelimited = Aspose::Cells::SaveFormat_Tsv, SaveFormat_Html = 12, SaveFormat_MHtml = 17,
  SaveFormat_Ods = 14, 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_XPS = 20, SaveFormat_Tiff = 21, SaveFormat_TIFF = 21,
  SaveFormat_Svg = 28, SaveFormat_SVG = 28, SaveFormat_Dif = 30, SaveFormat_Ots = 31,
  SaveFormat_Xlt = 32, SaveFormat_Xml = 51, SaveFormat_Numbers = 56, SaveFormat_Markdown = 57,
  SaveFormat_Fods = 59, SaveFormat_FODS = 59, SaveFormat_Sxc = 60, SaveFormat_SXC = 60,
  SaveFormat_Pptx = 61, SaveFormat_Docx = 62, SaveFormat_Emf = 0x102, SaveFormat_Jpg = 0x105,
  SaveFormat_Png = 0x106, SaveFormat_Bmp = 0x107, SaveFormat_Gif = 0x142, SaveFormat_Json = 0x201,
  SaveFormat_SqlScript = 0x202
}
 Represents the format in which the workbook is saved. More...
 
enum  SheetType {
  SheetType_VB, SheetType_Worksheet, SheetType_Chart, SheetType_BIFF4Macro,
  SheetType_InternationalMacro, SheetType_Other, SheetType_Dialog
}
 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_LeftBorder = 0x00000100, StyleModifyFlag_RightBorder = 0x00000200, StyleModifyFlag_TopBorder = 0x00000400, StyleModifyFlag_BottomBorder = 0x00000800,
  StyleModifyFlag_DiagonalDownBorder = 0x00001000, StyleModifyFlag_DiagonalUpBorder = 0x00002000, StyleModifyFlag_Diagonal = Aspose::Cells::StyleModifyFlag_DiagonalDownBorder|Aspose::Cells::StyleModifyFlag_DiagonalUpBorder, StyleModifyFlag_HorizontalBorder = 0x0000020,
  StyleModifyFlag_VerticalBorder = 0x0000040, StyleModifyFlag_Borders = Aspose::Cells::StyleModifyFlag_LeftBorder|Aspose::Cells::StyleModifyFlag_RightBorder|Aspose::Cells::StyleModifyFlag_TopBorder|Aspose::Cells::StyleModifyFlag_BottomBorder|Aspose::Cells::StyleModifyFlag_Diagonal|Aspose::Cells::StyleModifyFlag_HorizontalBorder|Aspose::Cells::StyleModifyFlag_VerticalBorder, StyleModifyFlag_NumberFormat = 0x00004000, StyleModifyFlag_HorizontalAlignment = 0x00008000,
  StyleModifyFlag_VerticalAlignment = 0x00010000, StyleModifyFlag_Indent = 0x00020000, StyleModifyFlag_Rotation = 0x00040000, StyleModifyFlag_WrapText = 0x00080000,
  StyleModifyFlag_ShrinkToFit = 0x00100000, StyleModifyFlag_TextDirection = 0x00200000, StyleModifyFlag_RelativeIndent = 0x0000080, StyleModifyFlag_AlignmentSettings = Aspose::Cells::StyleModifyFlag_HorizontalAlignment|Aspose::Cells::StyleModifyFlag_VerticalAlignment|Aspose::Cells::StyleModifyFlag_Rotation|Aspose::Cells::StyleModifyFlag_WrapText|Aspose::Cells::StyleModifyFlag_Indent|Aspose::Cells::StyleModifyFlag_ShrinkToFit|Aspose::Cells::StyleModifyFlag_TextDirection|Aspose::Cells::StyleModifyFlag_RelativeIndent,
  StyleModifyFlag_Pattern = 0x00400000, StyleModifyFlag_ForegroundColor = 0x00800000, StyleModifyFlag_BackgroundColor = 0x01000000, StyleModifyFlag_CellShading = Aspose::Cells::StyleModifyFlag_Pattern|Aspose::Cells::StyleModifyFlag_ForegroundColor|Aspose::Cells::StyleModifyFlag_BackgroundColor,
  StyleModifyFlag_Locked = 0x04000000, StyleModifyFlag_HideFormula = 0x08000000, StyleModifyFlag_ProtectionSettings = Aspose::Cells::StyleModifyFlag_Locked|Aspose::Cells::StyleModifyFlag_HideFormula, StyleModifyFlag_FontSize = 0x00000001,
  StyleModifyFlag_FontName = 0x00000002, StyleModifyFlag_FontColor = 0x00000003, StyleModifyFlag_FontWeight = 0x00000004, StyleModifyFlag_FontItalic = 0x00000005,
  StyleModifyFlag_FontUnderline = 0x00000006, StyleModifyFlag_FontStrike = 0x00000007, StyleModifyFlag_FontScript = 0x00000008, StyleModifyFlag_FontFamily = 0x00000009,
  StyleModifyFlag_FontCharset = 0x0000000A, StyleModifyFlag_FontScheme = 0x0000000B, StyleModifyFlag_FontDirty = 0x0000000C, StyleModifyFlag_FontSpellingError = 0x0000000D,
  StyleModifyFlag_FontUFillTx = 0x0000000E, StyleModifyFlag_FontSpacing = 0x0000000F, StyleModifyFlag_FontKerning = 0x00000010, StyleModifyFlag_FontEqualize = 0x00000011,
  StyleModifyFlag_FontCap = 0x00000012, StyleModifyFlag_Font = 0x000000013, StyleModifyFlag_All = Aspose::Cells::StyleModifyFlag_Borders|Aspose::Cells::StyleModifyFlag_NumberFormat|Aspose::Cells::StyleModifyFlag_AlignmentSettings|Aspose::Cells::StyleModifyFlag_CellShading|Aspose::Cells::StyleModifyFlag_ProtectionSettings|Aspose::Cells::StyleModifyFlag_Font
}
 The style modified flags. More...
 
enum  TextAlignmentType {
  TextAlignmentType_General = 0x0700, TextAlignmentType_Bottom = 0x0210, TextAlignmentType_Center = 0x070A, TextAlignmentType_CenterAcross = 0x0506,
  TextAlignmentType_Distributed = 0x0327, TextAlignmentType_Fill = 0x0504, TextAlignmentType_Justify = 0x071D, TextAlignmentType_Left = 0x0101,
  TextAlignmentType_Right = 0x0103, TextAlignmentType_Top = 0x0200, TextAlignmentType_JustifiedLow = 0x0340, TextAlignmentType_ThaiDistributed = 0x0380
}
 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  TextOrientationType { TextOrientationType_ClockWise, TextOrientationType_CounterClockWise, TextOrientationType_NoRotation, TextOrientationType_TopToBottom }
 Enumerates text orientation types. 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, TimePeriodType_ThisYear, TimePeriodType_LastYear,
  TimePeriodType_NextYear
}
 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-in 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.

Only sets for MS Excel.

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 calculated as the expected result. Such as formula "=-0.45+0.43+0.02", when calculating 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.

CellValueFormatStrategy_DisplayString 

Gets the displayed string shown in ms excel. The main difference from DisplayStyle is this option also considers the effect of column width. If the column width is too small to show the formatted string completely, "#" may be shown, just like what ms excel does.

◆ 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_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_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_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_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_February 

Shows the dates that are in February, 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 

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.

◆ EncryptionType

Encryption Type. Only used by excel2003. We will encrypt 2007/2010 workbook using SHA AES the same as Excel does, and this EncryptionType will be ignored.

Enumerator
EncryptionType_XOR 
EncryptionType_Compatible 

Office 97/2000 compatible.

EncryptionType_EnhancedCryptographicProviderV1 
EncryptionType_StrongCryptographicProvider 

◆ ErrorCheckType

Represents all error 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.

◆ ErrorType

Summary description for ErrorType.

Enumerator
ErrorType_Div 

Division by zero.

ErrorType_NA 

Cell values doesn't exist.

ErrorType_Name 

Text cannot be identified.

ErrorType_Null 

Null error..

ErrorType_Number 

Invalid number.

ErrorType_Ref 

Invalid reference.

ErrorType_Recursive 

Recursive reference.

ErrorType_Value 

Invalid parameter or operand type.

◆ 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 process is interrupted.

ExceptionType_IO 

The file is invalid.

ExceptionType_Permission 

Permission is required to open this file.

ExceptionType_UnsupportedFeature 

Unsupported feature.

ExceptionType_UnsupportedStream 

Unsupported stream to be opened.

ExceptionType_UndisclosedInformation 

Files contains some undisclosed information.

ExceptionType_FileCorrupted 

File content is corrupted.

◆ ExternalCellValueType

Enumerator
ExternalCellValueType_Blank 
ExternalCellValueType_Number 
ExternalCellValueType_String 
ExternalCellValueType_Error 
ExternalCellValueType_Bool 

◆ FileFormatType

Represents the file format types.

Enumerator
FileFormatType_Csv 

Comma-Separated Values(CSV) text file.

FileFormatType_CSV 

Comma-Separated Values(CSV) text file. NOTE: This member is now obsolete. Instead, please use Csv property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Xlsx 

Office Open XML SpreadsheetML file (macro-free).

FileFormatType_Xlsm 

Office Open XML SpreadsheetML Macro-Enabled file.

FileFormatType_Xltx 

Office Open XML SpreadsheetML Template (macro-free).

FileFormatType_Xltm 

Office Open XML SpreadsheetML Macro-Enabled Template.

FileFormatType_Xlam 

Office Open XML SpreadsheetML addinMacro-Enabled file.

FileFormatType_Tsv 

Tab-Separated Values(TSV) text file.

FileFormatType_TSV 

Tab-Separated Values(TSV) text file. NOTE: This member is now obsolete. Instead, please use Tsv property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_TabDelimited 

Tab-Separated Values(TSV) text file, same with Tsv

FileFormatType_Html 

HTML format.

FileFormatType_MHtml 

MHTML (Web archive) format.

FileFormatType_Ods 

Open Document Sheet(ODS) file.

FileFormatType_ODS 

Open Document Sheet(ODS) file. NOTE: This member is now obsolete. Instead, please use Ods property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Excel97To2003 

Excel97-2003 spreadsheet file.

FileFormatType_SpreadsheetML 

Excel 2003 SpreadsheetML file.

FileFormatType_Excel2003XML 

Excel 2003 SpreadsheetML file. NOTE: This member is now obsolete. Instead, please use SpreadsheetML property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Xlsb 

The Excel Binary File Format (.xlsb)

FileFormatType_Unknown 

Represents unrecognized format, cannot be loaded.

FileFormatType_Pdf 

PDF (Adobe Portable Document) format.

FileFormatType_Xps 

XPS (XML Paper Specification) format.

FileFormatType_XPS 

XPS (XML Paper Specification) format. NOTE: This member is now obsolete. Instead, please use Xps property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Tiff 

Represents a TIFF file.

FileFormatType_TIFF 

Represents a TIFF file. NOTE: This member is now obsolete. Instead, please use Tiff property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Svg 

SVG file.

FileFormatType_SVG 

SVG file. NOTE: This member is now obsolete. Instead, please use Svg property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Excel95 

Represents an Excel95 xls file.

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 a 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_MSEquation 

Represents the MS Equation 3.0 object. NOTE: This member is now obsolete. Instead, please use MsEquation property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

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_VSD 

Represents MS Visio VSD binary format. NOTE: This member is now obsolete. Instead, please use Vsd property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Vsdx 

Represents MS Visio 2013 VSDX file format.

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

FileFormatType_VSDX 

Represents MS Visio 2013 VSDX file format. NOTE: This member is now obsolete. Instead, please use Vsdx property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

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 detected as xlsx ,docx, pptx,etc.

FileFormatType_Odt 

Represents an ODT file.

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

FileFormatType_ODT 

Represents an ODT file. NOTE: This member is now obsolete. Instead, please use Odt property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Odp 

Represents a ODP file.

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

FileFormatType_ODP 

Represents an ODP file. NOTE: This member is now obsolete. Instead, please use Odp property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Odf 

Represents an ODF file.

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

FileFormatType_ODF 

Represents an ODF file. NOTE: This member is now obsolete. Instead, please use Odf property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Odg 

Represents an ODG file.

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

FileFormatType_ODG 

Represents an ODG file. NOTE: This member is now obsolete. Instead, please use Odg property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Xml 

Represents a simple xml file.

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

FileFormatType_XML 

Represents a simple xml file. NOTE: This member is now obsolete. Instead, please use Xml property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Xlt 

Excel97-2003 spreadsheet template.

FileFormatType_Ott 

Represents an OTT file.

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

FileFormatType_OTT 

Represents an OTT file. NOTE: This member is now obsolete. Instead, please use Ott property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Bmp 

Represents a BMP file.

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

FileFormatType_BMP 

Represents an BMP file. NOTE: This member is now obsolete. Instead, please use Bmp property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Ots 

Represents an ots file.

FileFormatType_OTS 

Represents an OTS file. NOTE: This member is now obsolete. Instead, please use Ots property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Numbers 

Represents Numbers 9.0 file format by Apple Inc.

FileFormatType_Numbers09 

Represents Numbers 9.0 file format by Apple Inc.

FileFormatType_Markdown 

Represents markdown document.

FileFormatType_GraphChart 

Represents embedded graph chart.

FileFormatType_Fods 

Represents OpenDocument Flat XML Spreadsheet (.fods) file format.

FileFormatType_FODS 

Represents OpenDocument Flat XML Spreadsheet (.fods) file format. NOTE: This member is now obsolete. Instead, please use Fods property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Sxc 

Represents StarOffice Calc Spreadsheet (.sxc) file format.

FileFormatType_SXC 

Represents StarOffice Calc Spreadsheet (.sxc) file format. NOTE: This member is now obsolete. Instead, please use Sxc property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Otp 

Represents a OTP file.

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

FileFormatType_OTP 

Represents a OTP file. NOTE: This member is now obsolete. Instead, please use Otp property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

FileFormatType_Numbers35 

Represents Numbers 3.5 file format since 2014 by Apple Inc

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

FileFormatType_Emf 

Windows Enhanced Metafile.

FileFormatType_Wmf 

Windows Metafile.

FileFormatType_Jpg 

JPEG JFIF.

FileFormatType_Png 

Portable Network Graphics.

FileFormatType_Gif 

Gif

FileFormatType_Json 

Json

FileFormatType_SqlScript 

Sql

◆ 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 comparison.

FilterOperatorType_BeginsWith 

Begins with the text.

FilterOperatorType_EndsWith 

Ends with the text.

FilterOperatorType_Contains 

Contains the text.

FilterOperatorType_NotContains 

Not contains the text.

◆ 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.

◆ HeaderFooterCommandType

Represents the command type of header and footer.

Enumerator
HeaderFooterCommandType_Text 

The text.

HeaderFooterCommandType_CurrentPage 

Current page number

HeaderFooterCommandType_Pagecount 

Page count

HeaderFooterCommandType_CurrentDate 

Current date

HeaderFooterCommandType_CurrentTime 

Current time

HeaderFooterCommandType_SheetName 

Sheet name

HeaderFooterCommandType_FileName 

File name without path

HeaderFooterCommandType_FilePath 

File path without file name

HeaderFooterCommandType_Picture 

Picture

◆ HtmlCrossType

Represents five types of html cross string.

Enumerator
HtmlCrossType_Default 

Display like MS Excel,depends on the next cell. If the next cell is null,the string will cross,or it will be truncated

HtmlCrossType_MSExport 

Display the string like MS Excel exporting html.

HtmlCrossType_Cross 

Display HTML cross string, this performance for creating large html files will be more than ten times faster than setting the value to Default or FitToCell.

HtmlCrossType_CrossHideRight 

Display HTML cross string and hide the right string when the texts overlap.

HtmlCrossType_FitToCell 

Only displaying the string within the width of cell.

◆ HtmlExportDataOptions

Represents the options for exporting html data.

Enumerator
HtmlExportDataOptions_Table 

Export file to html which only contains table part.

HtmlExportDataOptions_All 

Export all the data to html.

◆ HtmlHiddenColDisplayType

Represents two types of showing the hidden columns in html.

Enumerator
HtmlHiddenColDisplayType_Hidden 

Hidden the hidden columns in html page.

HtmlHiddenColDisplayType_Remove 

Remove the hidden columns in html page.

◆ HtmlHiddenRowDisplayType

Represents two types of showing the hidden rows in html.

Enumerator
HtmlHiddenRowDisplayType_Hidden 

Hidden the hidden rows in html page.

HtmlHiddenRowDisplayType_Remove 

Remove the hidden rows in html page.

◆ HtmlLinkTargetType

Represents the type of target attribute in HTML tag.

Enumerator
HtmlLinkTargetType_Blank 

Opens the linked document in a new window or tab

HtmlLinkTargetType_Parent 

Opens the linked document in the parent frame

HtmlLinkTargetType_Self 

Opens the linked document in the same frame as it was clicked (this is default)

HtmlLinkTargetType_Top 

Opens the linked document in the full body of the window

◆ 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.

IconSetType_Smilies3 

3 smilies. Only for .ods.

IconSetType_ColorSmilies3 

3 color smilies. Only for .ods.

◆ LoadDataFilterOptions

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

Enumerator
LoadDataFilterOptions_None 

Load nothing for sheet data

NOTE: This member is now obsolete and please use Structure instead. This property will be removed 12 months later since December 2017. Aspose apologizes for any inconvenience you may have experienced.

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_Formula 

Load cell formulas.

Generally defined Name objects(DefinedNames) also need to be loaded when loading formulas because they may be referenced by formulas. So Formula or CellData option should work with DefinedNames option together(Formula|DefinedNames or CellData|DefinedNames) for most scenarios.

LoadDataFilterOptions_CellData 

Load cells data including values, formulas and formatting

LoadDataFilterOptions_Chart 

Load charts

LoadDataFilterOptions_Shape 

Load shapes

NOTE: This member is now obsolete and please use Drawing instead. This property will be removed 12 months later since November 2019. Aspose apologizes for any inconvenience you may have experienced.

LoadDataFilterOptions_Drawing 

Drawing objects(including Chart, Picture, OleObject and all other drawing objects)

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_Hyperlinks 

Load hyperlinks

LoadDataFilterOptions_SheetSettings 

Load settings for worksheet

LoadDataFilterOptions_SheetData 

Load all data of worksheet, such as cells data, settings, objects, ...etc.

LoadDataFilterOptions_BookSettings 

Load settings for workbook

LoadDataFilterOptions_Settings 

Load settings for workbook and worksheet

LoadDataFilterOptions_XmlMap 

Load XmlMap

LoadDataFilterOptions_Structure 

Load structure of the workbook

LoadDataFilterOptions_DocumentProperties 

Load document properties

LoadDataFilterOptions_DefinedNames 

Load defined Name objects

LoadDataFilterOptions_VBA 

Load VBA projects

LoadDataFilterOptions_Style 

Load styles for cell formatting

LoadDataFilterOptions_Picture 

Load pictures

LoadDataFilterOptions_OleObject 

Load OleObjects

LoadDataFilterOptions_Revision 

Load revision logs

◆ LoadFormat

Represents the load file format.

Enumerator
LoadFormat_Auto 

Represents recognizing the format automatically.

LoadFormat_Csv 

Comma-Separated Values(CSV) text file.

LoadFormat_CSV 

Comma-Separated Values(CSV) text file. NOTE: This member is now obsolete. Instead, please use Csv property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

LoadFormat_Xlsx 

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

LoadFormat_Tsv 

Tab-Separated Values(TSV) text file.

LoadFormat_TSV 

Tab-Separated Values(TSV) text file. NOTE: This member is now obsolete. Instead, please use Tsv property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

LoadFormat_TabDelimited 

Represents a tab delimited text file, same with Tsv

LoadFormat_Html 

Represents a html file.

LoadFormat_MHtml 

Represents a mhtml file.

LoadFormat_Ods 

Open Document Sheet(ODS) file.

LoadFormat_ODS 

Open Document Sheet(ODS) file. NOTE: This member is now obsolete. Instead, please use Ods property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

LoadFormat_Excel97To2003 

Represents an Excel97-2003 xls file.

LoadFormat_SpreadsheetML 

Represents an Excel 2003 xml file.

LoadFormat_Xlsb 

Represents an xlsb file.

LoadFormat_Ots 

Open Document Template Sheet(OTS) file.

LoadFormat_Numbers 

Represents a numbers file.

LoadFormat_Fods 

Represents OpenDocument Flat XML Spreadsheet (.fods) file format.

LoadFormat_FODS 

Represents OpenDocument Flat XML Spreadsheet (.fods) file format. NOTE: This member is now obsolete. Instead, please use Fods property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

LoadFormat_Sxc 

Represents StarOffice Calc Spreadsheet (.sxc) file format.

LoadFormat_SXC 

Represents StarOffice Calc Spreadsheet (.sxc) file format. NOTE: This member is now obsolete. Instead, please use Sxc property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

LoadFormat_Xml 

Represents a simple xml file.

LoadFormat_Unknown 

Represents unrecognized format, cannot be loaded.

LoadFormat_Image 

Image

LoadFormat_Json 

Json

◆ 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 object from formula,else find it from the value.

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 for cells model.

This option is applied for all versions.

MemorySetting_MemoryPreference 

Memory performance preferrable. With this option the data will be held in compact format so for common scenarios it may give lower memory cost. However, this option also may degrade R/W performance a bit in some special cases.

This option is available since v 8.0.0.

◆ 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)

PaperSizeType_Custom 

Represents the custom paper size.

◆ 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 without 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_ValuesAndFormats 
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".

◆ PrintingPageType

Indicates which pages will not be printed.

Enumerator
PrintingPageType_Default 

Prints all pages.

PrintingPageType_IgnoreBlank 

Don't print the pages which the cells are blank.

PrintingPageType_IgnoreStyle 

Don't print the pages which cells only contain styles.

◆ PrintOrderType

Represent print order constants.

Enumerator
PrintOrderType_DownThenOver 

Down, then over

PrintOrderType_OverThenDown 

Over, then down

◆ PrintSizeType

Represents the printed chart size.

Enumerator
PrintSizeType_Full 

Use full page.

PrintSizeType_Fit 

Scale to fit page.

PrintSizeType_Custom 

Custom.

◆ 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 

Comma-Separated Values(CSV) text file.

SaveFormat_CSV 

Comma-Separated Values(CSV) text file. NOTE: This member is now obsolete. Instead, please use Csv property. This property will be removed 6 months later since April 2021. Aspose apologizes for any inconvenience you may have experienced.

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 addin macros.

SaveFormat_Tsv 

Tab-Separated Values(TSV) text file.

SaveFormat_TSV 

Tab-Separated Values(TSV) text file. NOTE: This member is now obsolete. Instead, please use Tsv property.

SaveFormat_TabDelimited 

Represents a tab delimited text file, same with Tsv

SaveFormat_Html 

Represents a html file.

SaveFormat_MHtml 

Represents a mhtml file.

SaveFormat_Ods 

Open Document Sheet(ODS) file.

SaveFormat_ODS 

Open Document Sheet(ODS) file. NOTE: This member is now obsolete. Instead, please use Ods property.

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 

XPS (XML Paper Specification) format.

SaveFormat_XPS 

XPS (XML Paper Specification) format. NOTE: This member is now obsolete. Instead, please use SaveFormat_Xps property.

SaveFormat_Tiff 

Represents a TIFF file.

SaveFormat_TIFF 

Represents a TIFF file. NOTE: This member is now obsolete. Instead, please use SaveFormat_Tiff property.

SaveFormat_Svg 

SVG file.

SaveFormat_SVG 

SVG file. NOTE: This member is now obsolete. Instead, please use SaveFormat_Svg property.

SaveFormat_Dif 

Data Interchange Format.

SaveFormat_Ots 

Open Document Template Sheet(OTS) file.

SaveFormat_Xlt 

Excel 97-2003 template file.

SaveFormat_Xml 

Represents a simple xml file.

SaveFormat_Numbers 

Represents a numbers file.

Not supported.

SaveFormat_Markdown 

Represents markdown document.

SaveFormat_Fods 

Represents OpenDocument Flat XML Spreadsheet (.fods) file format.

SaveFormat_FODS 

Represents OpenDocument Flat XML Spreadsheet (.fods) file format. NOTE: This member is now obsolete. Instead, please use Fods property.

SaveFormat_Sxc 

Represents StarOffice Calc Spreadsheet (.sxc) file format.

SaveFormat_SXC 

Represents StarOffice Calc Spreadsheet (.sxc) file format. NOTE: This member is now obsolete. Instead, please use Sxc property.

SaveFormat_Pptx 

Represents .pptx file.

SaveFormat_Docx 

Represents .docx file.

SaveFormat_Emf 

Windows Enhanced Metafile.

SaveFormat_Jpg 

JPEG JFIF.

SaveFormat_Png 

Portable Network Graphics.

SaveFormat_Bmp 

Windows Bitmap

SaveFormat_Gif 

Gif

SaveFormat_Json 

Json

SaveFormat_SqlScript 

Sql

◆ SheetType

Specifies the worksheet type.

Enumerator
SheetType_VB 

Visual Basic module

SheetType_Worksheet 
SheetType_Chart 

Chart

SheetType_BIFF4Macro 

BIFF4 Macro sheet

SheetType_InternationalMacro 

International Macro sheet

SheetType_Other 
SheetType_Dialog 

Dialog worksheet

◆ 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_LeftBorder 

Indicates whether left border has been modified for the style.

StyleModifyFlag_RightBorder 

Indicates whether right border has been modified for the style.

StyleModifyFlag_TopBorder 

Indicates whether top border has been modified for the style.

StyleModifyFlag_BottomBorder 

Indicates whether bottom border has been modified for the style.

StyleModifyFlag_DiagonalDownBorder 

Indicates whether diagonal-down border has been modified for the style.

StyleModifyFlag_DiagonalUpBorder 

Indicates whether diagonal-up border has been modified for the style.

StyleModifyFlag_Diagonal 

Indicates whether one or more diagonal borders(DiagonalDownBorder , DiagonalUpBorder ) have been modified for the style.

StyleModifyFlag_HorizontalBorder 

Indicates whether horizontal border has been modified for the style. Only for dynamic style, such as conditional formatting.

StyleModifyFlag_VerticalBorder 

Indicates whether vertical border has been modified for the style. Only for dynamic style, such as conditional formatting.

StyleModifyFlag_Borders 

Indicates whether one or more borders(LeftBorder , RightBorder , TopBorder , BottomBorder , Diagonal , HorizontalBorder , VerticalBorder ) have been modified for the style.

StyleModifyFlag_NumberFormat 

Indicates whether numberformat has been modified.

StyleModifyFlag_HorizontalAlignment 

Indicates whether horizontal alignment has been modified.

StyleModifyFlag_VerticalAlignment 

Indicates whether vertical alignment has been modified.

StyleModifyFlag_Indent 

Indicates whether indent property has been modified.

StyleModifyFlag_Rotation 

Indicates whether rotation property has been modified.

StyleModifyFlag_WrapText 

Indicates whether wrap text property has been modified.

StyleModifyFlag_ShrinkToFit 

Indicates whether shrink to fit property has been modified.

StyleModifyFlag_TextDirection 

Indicates whether text direction property has been modified.

StyleModifyFlag_RelativeIndent 

Indicates whether relative indent property has been modified for the style. Only for dynamic style, such as conditional formatting.

StyleModifyFlag_AlignmentSettings 

Indicates whether one or more alignment-related properties(HorizontalAlignment , VerticalAlignment , Rotation , WrapText , WrapText , Indent , ShrinkToFit , TextDirection , RelativeIndent ) have been modified.

StyleModifyFlag_Pattern 

Indicates whether pattern of the shading has been modified.

StyleModifyFlag_ForegroundColor 

Indicates whether foreground color has been modified.

StyleModifyFlag_BackgroundColor 

Indicates whether background color has been modified.

StyleModifyFlag_CellShading 

Indicates whether one or more shading-related properties(Pattern , ForegroundColor , BackgroundColor ) have been modified.

StyleModifyFlag_Locked 

Indicates whether locked property has been modified.

StyleModifyFlag_HideFormula 

Indicates whether hide formula has been modified.

StyleModifyFlag_ProtectionSettings 

Indicates whether one or more protection-related properties(Locked , HideFormula ) have been modified.

StyleModifyFlag_FontSize 

Indicates whether font size has been modified.

StyleModifyFlag_FontName 

Indicates whether font name has been modified.

StyleModifyFlag_FontColor 

Indicates whether font color has been modified.

StyleModifyFlag_FontWeight 

Indicates whether font weight has been modified.

StyleModifyFlag_FontItalic 

Indicates whether italic property of font has been modified.

StyleModifyFlag_FontUnderline 

Indicates whether underline property of font has been modified.

StyleModifyFlag_FontStrike 

Indicates whether strike property font has been modified.

StyleModifyFlag_FontScript 

Indicates whether subscript or superscript property of font has been modified.

StyleModifyFlag_FontFamily 

Indicates whether font family has been modified.

StyleModifyFlag_FontCharset 

Indicates whether charset of the font has been modified.

StyleModifyFlag_FontScheme 

unused.

StyleModifyFlag_FontDirty 

unused.

StyleModifyFlag_FontSpellingError 

unused.

StyleModifyFlag_FontUFillTx 

unused.

StyleModifyFlag_FontSpacing 

unused.

StyleModifyFlag_FontKerning 

unused.

StyleModifyFlag_FontEqualize 

unused.

StyleModifyFlag_FontCap 

unused.

StyleModifyFlag_Font 

Indicates whether one or more properties have been modified for the font of the style.

StyleModifyFlag_All 

Indicates whether one or more properties have been modified for the style.

◆ TextAlignmentType

Enumerates text alignment types.

Enumerator
TextAlignmentType_General 

Represents general text alignment.

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_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 

◆ TextOrientationType

Enumerates text orientation types.

Enumerator
TextOrientationType_ClockWise 

Rotates text with 90 degrees clockwise.

TextOrientationType_CounterClockWise 

Rotates text with 90 degrees counterclockwise.

TextOrientationType_NoRotation 

Represents the default value.

TextOrientationType_TopToBottom 

Displays text from top to bottom of the cell. Stacked text.

◆ 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 occurring 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.

TimePeriodType_ThisYear 

A date occurring this year. Only for .ods.

TimePeriodType_LastYear 

A date occurring last year. Only for .ods.

TimePeriodType_NextYear 

A date occurring next year. Only for .ods.

◆ 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.