Globals

Properties

AccessCacheOptions
AdjustFontSizeForRowType
AutoFillType
AutoFitMergedCellsType
AutoFitWrappedTextType
AutoShapeType
AxisType
BackgroundMode
BackgroundType
Bar3DShapeType
BevelPresetType
BevelType
BorderType
BubbleSizeRepresents
BuiltinStyleType
BulletType
CalcModeType
CalculationPrecisionStrategy
CategoryType
CellBorderType
CellValueFormatStrategy
CellValueType
ChartLineFormattingType
ChartMarkerType
ChartSplitType
ChartTextDirectionType
ChartType
CheckValueType
ColorDepth
ColorType
CommentTitleType
ConsolidationFunction
ControlBorderType
ControlCaptionAlignmentType
ControlListStyle
ControlMatchEntryType
ControlMousePointerType
ControlPictureAlignmentType
ControlPicturePositionType
ControlPictureSizeMode
ControlScrollBarType
ControlScrollOrientation
ControlSpecialEffectType
ControlType
CopyFormatType
CountryCode
CredentialsMethodType
CrossType
DataBarAxisPosition
DataBarBorderType
DataBarFillType
DataBarNegativeColorType
DataLabelShapeType
DataLabelsSeparatorType
DateTimeGroupingType
DefaultEditLanguage
DirectoryType
DisplayDrawingObjects
DisplayUnitType
DropButtonStyle
DynamicFilterType
EmfRenderSetting
EncryptionType
EquationCharacterPositionType
EquationCombiningCharacterType
EquationDelimiterShapeType
EquationFractionType
EquationHorizontalJustificationType
EquationLimitLocationType
EquationMathematicalOperatorType
EquationNodeType
EquationVerticalJustificationType
ErrorBarDisplayType
ErrorBarType
ErrorCheckType
ExceptionType
ExternalLinkType
FileFormatType
FillPattern
FillPictureType
FillType
FilterOperatorType
FilterType
FontSchemeType
FontSourceType
FontUnderlineType

FormatConditionType
FormatConditionValueType
FormatSetType
FormattingType
GradientColorType
GradientDirectionType
GradientFillType
GradientPresetType
GradientStyleType
GridlineType
HeaderFooterCommandType
HtmlCrossType
HtmlExportDataOptions
HtmlFormatHandlingType
HtmlHiddenColDisplayType
HtmlHiddenRowDisplayType
HtmlLinkTargetType
IconSetType
ImageBinarizationMethod
ImageType
InputMethodEditorMode
JsonExportHyperlinkType
LabelPositionType
LegendPositionType
LightRigDirectionType
LightRigType
LineCapType
LineJoinType
LineSpaceSizeType
LineType
LoadDataFilterOptions
LoadFormat
LoadNumbersTableType
LookAtType
LookInType
MapChartLabelLayout
MapChartProjectionType
MapChartRegionType
MemorySetting
MergeEmptyTdType
MetadataType
MirrorType
MsoArrowheadLength
MsoArrowheadStyle
MsoArrowheadWidth
MsoDrawingType
MsoLineDashStyle
MsoLineStyle
MsoPresetTextEffect
MsoPresetTextEffectShape
NameScopeType
NumberCategoryType
OLEDBCommandType
OdsCellFieldType
OdsGeneratorType
OdsPageBackgroundGraphicPositionType
OdsPageBackgroundGraphicType
OdsPageBackgroundType
OoxmlCompliance
OoxmlCompressionType
OpenDocumentFormatVersionType
OperatorType
PageLayoutAlignmentType
PageOrientationType
PaneStateType
PaperSizeType
ParameterType
PasteOperationType
PasteType
PdfCompliance
PdfCompressionCore
PdfCustomPropertiesExport
PdfFontEncoding
PdfOptimizationType
PivotAreaType
PivotConditionFormatRuleType
PivotConditionFormatScopeType
PivotFieldDataDisplayFormat
PivotFieldGroupType
PivotFieldSubtotalType
PivotFieldType
PivotFilterType
PivotGroupByType
PivotItemPosition
PivotMissingItemLimitType
PivotTableAutoFormatType

PivotTableSelectionType
PivotTableStyleType
PlacementType
PlotDataByType
PlotEmptyCellsType
PresetCameraType
PresetMaterialType
PresetShadowType
PresetThemeGradientType
PresetWordArtStyle
PrintCommentsType
PrintErrorsType
PrintOrderType
PrintSizeType
PrintingPageType
PropertyType
ProtectionType
QuartileCalculationType
ReConnectionMethodType
RectangleAlignmentType
ReflectionEffectType
RenameStrategy
ReserveMissingPivotItemType
ResourceLoadingType
RevisionActionType
RevisionType
SaveFormat
SelectionType
ShapeAnchorType
ShapeLockType
ShapePathType
SheetType
ShiftType
ShowDropButtonType
SlicerCacheCrossFilterType
SlicerCacheItemSortType
SlicerStyleType
SlideViewType
SmartTagShowType
SortOnType
SortOrder
SparklineAxisMinMaxType
SparklinePresetStyleType
SparklineType
SqlDataType
SqlScriptOperatorType
StyleModifyFlag
TableDataSourceType
TableStyleElementType
TableStyleType
TargetModeType
TextAlignmentType
TextAutonumberScheme
TextCapsType
TextCrossType
TextDirectionType
TextFontAlignType
TextNodeType
TextOrientationType
TextOverflowType
TextStrikeType
TextTabAlignmentType
TextVerticalType
TextureType
ThemeColorType
TickLabelAlignmentType
TickLabelPositionType
TickMarkType
TiffCompression
TimePeriodType
TimeUnit
TotalsCalculation
TrendlineType
TxtLoadStyleStrategy
TxtValueQuoteType
UpdateLinksType
ValidationAlertType
ValidationType
VbaModuleType
VbaProjectReferenceType
ViewType
VisibilityType
WebExtensionStoreType
WeightType
XAdESType

Properties

constant

AccessCacheOptions number

Utility class containing constants. Cache options for data access. Can be combined with | operator for multiple options together. For some features, accessing large dataset requires a lot of repeated and complicated operations such as search, calculation, ...etc and those operations will take a lot of extra time. For common situations, all dependent data remains unchanged during the access, so some caches can be built and used to improve the access performance. For this purpose, we provide this API so that user can specify which kind of data access needs to be optimized by possible caching mechanism. Please note, for different options, different data set may be required to be "read-only". And performance of accessing data depends on many aspects, the use of caching mechanism does not guarantee that performance will be improved. For some situations, such as the dataset to be accessed is small, using cache may cause even more time because caching itself also needs certain extra time.

Properties

Name	Type	Optional	Description
NONE			No cache for any data access.
ALL			Apply all possible optimizations for all kinds of data access in the workbook. All settings and data should not be changed during the optimized access.
POSITION_AND_SIZE			Apply possible optimization for getting object(such as Shape)'s position and size. Row height and column width settings should not be changed during the optimized access.
CELLS_DATA			Apply possible optimization for getting cells' values. Cells data(data and settings of Cell, Row) should not be changed during the optimized access, no new Cell/Row objects should be created either(such as by #Error Cref: P:Aspose.Cells.Cells.Item(System.Int32,System.Int32)).
CELL_DISPLAY			Apply possible optimization for getting display-related results of cells(Cell.DisplayStringValue, Cell.getStyle(), Cell.getDisplayStyle(), etc.). Cells data and style-related objects(Cell/Row/Column styles, column width, etc.) should not be changed during the optimized access.
GET_FORMULA			Apply possible optimization for getting formulas. All data and settings which may affect the formula expression(Worksheet's name, Name's text, table's column, etc.) should not be changed during the optimized access.
SET_FORMULA			Apply possible optimization for setting formulas. All data and settings which may affect the formula expression(Worksheet's name, Name's text, table's column, etc.) should not be changed during the optimized access.
CALCULATE_FORMULA			Apply possible optimization for calculating formulas. Cells data should not be changed during the optimized access, none new objects(Cell, Row, etc.) should be created either(such as by #Error Cref: P:Aspose.Cells.Cells.Item(System.Int32,System.Int32)).
CONDITIONAL_FORMATTING			Apply possible optimization for getting formatting result of conditional formattings. All data and settings which may affect the result of conditional formattings(settings of conditional formattings, dependent cell values, etc.) should not be changed during the optimized access.
VALIDATION			Apply possible optimization for getting validation result. All data and settings which may affect the result of validation(settings of the validation, dependent cell values, etc.) should not be changed during the optimized access.

constant

AdjustFontSizeForRowType number

Utility class containing constants. Represents which kind of rows should be ajusted.

Properties

Name	Type	Optional	Description
NONE			No adjsut.
EMPTY_ROWS			If the row is empty, change font size to fit row height.

constant

AutoFillType number

Utility class containing constants. Represents the auto fill type.

Properties

Name	Type	Optional	Description
COPY			Copies the value and format of the source area to the target area
DEFAULT			Automatically fills the target area with the value and format.
FORMATS			Copies only the format of the source area to the target area,
SERIES			Extend the value in the source area to the target area in the form of a series and copy format to the target area.
VALUES			Copies only the value of the source area to the target area,

constant

AutoFitMergedCellsType number

Utility class containing constants. Represents the type of auto fitting merged cells.

Properties

Name	Type	Optional	Description
NONE			Ignore merged cells. Default.
FIRST_LINE			Only expands the height of the first row.
LAST_LINE			Only expands the height of the last row.
EACH_LINE			Only expands the height of each row.

constant

AutoFitWrappedTextType number

Utility class containing constants. Represents the type of auto fitting wrapped text.

Properties

Name	Type	Optional	Description
DEFAULT			Works as MS Excel.
PARAGRAPH			Auto fit width with the longest paragraph.

constant

AutoShapeType number

Utility class containing constants. Represents all built-in auto shape type.

Properties

Name	Type	Optional	Description
NOT_PRIMITIVE
RECTANGLE
ROUNDED_RECTANGLE
OVAL
DIAMOND
ISOSCELES_TRIANGLE
RIGHT_TRIANGLE
PARALLELOGRAM
TRAPEZOID
HEXAGON
OCTAGON
CROSS
STAR_5
RIGHT_ARROW
HOME_PLATE
CUBE
BALLOON
SEAL
ARC
LINE
PLAQUE
CAN
DONUT
TEXT_SIMPLE
TEXT_OCTAGON
TEXT_HEXAGON
TEXT_CURVE
TEXT_WAVE
TEXT_RING
TEXT_ON_CURVE
MSOSPT_TEXT_ON_RING
STRAIGHT_CONNECTOR
BENT_CONNECTOR_2
ELBOW_CONNECTOR
BENT_CONNECTOR_4
BENT_CONNECTOR_5
CURVED_CONNECTOR_2
CURVED_CONNECTOR
CURVED_CONNECTOR_4
CURVED_CONNECTOR_5
LINE_CALLOUT_NO_BORDER_2
LINE_CALLOUT_NO_BORDER_3
LINE_CALLOUT_NO_BORDER_4
LINE_CALLOUT_WITH_ACCENT_BAR_2
LINE_CALLOUT_WITH_ACCENT_BAR_3
LINE_CALLOUT_WITH_ACCENT_BAR_4
LINE_CALLOUT_WITH_BORDER_2
LINE_CALLOUT_WITH_BORDER_3
LINE_CALLOUT_WITH_BORDER_4
LINE_CALLOUT_WITH_BORDER_AND_ACCENT_BAR_2
LINE_CALLOUT_WITH_BORDER_AND_ACCENT_BAR_3
LINE_CALLOUT_WITH_BORDER_AND_ACCENT_BAR_4
DOWN_RIBBON
UP_RIBBON
CHEVRON
REGULAR_PENTAGON
NO_SYMBOL
STAR_8
STAR_16
STAR_32
RECTANGULAR_CALLOUT
ROUNDED_RECTANGULAR_CALLOUT
OVAL_CALLOUT
WAVE
FOLDED_CORNER
LEFT_ARROW
DOWN_ARROW
UP_ARROW
LEFT_RIGHT_ARROW
UP_DOWN_ARROW
EXPLOSION_1
EXPLOSION_2
LIGHTNING_BOLT
HEART
PICTURE_FRAME
QUAD_ARROW
LEFT_ARROW_CALLOUT
RIGHT_ARROW_CALLOUT
UP_ARROW_CALLOUT
DOWN_ARROW_CALLOUT
LEFT_RIGHT_ARROW_CALLOUT
UP_DOWN_ARROW_CALLOUT
QUAD_ARROW_CALLOUT
BEVEL
LEFT_BRACKET
RIGHT_BRACKET
LEFT_BRACE
RIGHT_BRACE
LEFT_UP_ARROW
BENT_UP_ARROW
BENT_ARROW
STAR_24
STRIPED_RIGHT_ARROW
NOTCHED_RIGHT_ARROW
BLOCK_ARC
SMILEY_FACE
VERTICAL_SCROLL
HORIZONTAL_SCROLL
CIRCULAR_ARROW
NOTCHED_CIRCULAR_ARROW			A value that SHOULD NOT be used.
U_TURN_ARROW
CURVED_RIGHT_ARROW
CURVED_LEFT_ARROW
CURVED_UP_ARROW
CURVED_DOWN_ARROW
CLOUD_CALLOUT
CURVED_DOWN_RIBBON
CURVED_UP_RIBBON
FLOW_CHART_PROCESS
FLOW_CHART_DECISION
FLOW_CHART_DATA
FLOW_CHART_PREDEFINED_PROCESS
FLOW_CHART_INTERNAL_STORAGE
FLOW_CHART_DOCUMENT
FLOW_CHART_MULTIDOCUMENT
FLOW_CHART_TERMINATOR
FLOW_CHART_PREPARATION
FLOW_CHART_MANUAL_INPUT
FLOW_CHART_MANUAL_OPERATION
FLOW_CHART_CONNECTOR
FLOW_CHART_CARD
FLOW_CHART_PUNCHED_TAPE
FLOW_CHART_SUMMING_JUNCTION
FLOW_CHART_OR
FLOW_CHART_COLLATE
FLOW_CHART_SORT
FLOW_CHART_EXTRACT
FLOW_CHART_MERGE
FLOW_CHART_OFFLINE_STORAGE
FLOW_CHART_STORED_DATA
FLOW_CHART_SEQUENTIAL_ACCESS_STORAGE
FLOW_CHART_MAGNETIC_DISK
FLOW_CHART_DIRECT_ACCESS_STORAGE
FLOW_CHART_DISPLAY
FLOW_CHART_DELAY
TEXT_PLAIN_TEXT			A plain text shape.
TEXT_STOP			An octagonal text shape.
TEXT_TRIANGLE			A triangular text shape pointing upwards.
TEXT_TRIANGLE_INVERTED			A triangular text shape pointing downwards.
TEXT_CHEVRON			A chevron text shape pointing upwards.
TEXT_CHEVRON_INVERTED			A chevron text shape pointing downwards.
TEXT_RING_INSIDE			A circular text shape, as if reading an inscription on the inside of a ring.
TEXT_RING_OUTSIDE			A circular text shape, as if reading an inscription on the outside of a ring.
TEXT_ARCH_UP_CURVE			An upward arching curved text shape.
TEXT_ARCH_DOWN_CURVE			A downward arching curved text shape.
TEXT_CIRCLE_CURVE			A circular text shape.
TEXT_BUTTON_CURVE			A text shape that resembles a button.
TEXT_ARCH_UP_POUR			An upward arching text shape.
TEXT_ARCH_DOWN_POUR			A downward arching text shape.
TEXT_CIRCLE_POUR			A circular text shape.
TEXT_BUTTON_POUR			A text shape that resembles a button.
TEXT_CURVE_UP			An upward curving text shape.
TEXT_CURVE_DOWN			A downward curving text shape.
TEXT_CASCADE_UP			A cascading text shape pointed upwards.
TEXT_CASCADE_DOWN			A cascading text shape pointed downwards.
TEXT_WAVE_1			A wavy text shape.
TEXT_WAVE_2			A wavy text shape.
TEXT_DOUBLE_WAVE_1			A wavy text shape.
TEXT_DOUBLE_WAVE_2			A wavy text shape.
TEXT_INFLATE			A text shape that expands vertically in the middle.
TEXT_DEFLATE			A text shape that shrinks vertically in the middle.
TEXT_INFLATE_BOTTOM			A text shape that expands downward in the middle.
TEXT_DEFLATE_BOTTOM			A text shape that shrinks upwards in the middle.
TEXT_INFLATE_TOP			A text shape that expands upward in the middle.
TEXT_DEFLATE_TOP			A text shape that shrinks downward in the middle.
TEXT_DEFLATE_INFLATE			A text shape where lower lines expand upward. Upper lines shrink to compensate.
TEXT_DEFLATE_INFLATE_DEFLATE			A text shape where lines in the center expand vertically. Upper and lower lines shrink to compensate.
TEXT_FADE_RIGHT			A text shape that shrinks vertically on the right side.
TEXT_FADE_LEFT			A text shape that shrinks vertically on the left side.
TEXT_FADE_UP			A text shape that shrinks horizontally on top.
TEXT_FADE_DOWN			A text shape that shrinks horizontally on bottom.
TEXT_SLANT_UP			An upward slanted text shape.
TEXT_SLANT_DOWN			A downward slanted text shape.
TEXT_CAN_UP			A text shape that is curved upwards as if being read on the side of a can.
TEXT_CAN_DOWN			A text shape that is curved downwards as if being read on the side of a can.
FLOW_CHART_ALTERNATE_PROCESS
FLOW_CHART_OFFPAGE_CONNECTOR
LINE_CALLOUT_NO_BORDER_1
LINE_CALLOUT_WITH_ACCENT_BAR_1
LINE_CALLOUT_WITH_BORDER_1
LINE_CALLOUT_WITH_BORDER_AND_ACCENT_BAR_1
LEFT_RIGHT_UP_ARROW
SUN
MOON
DOUBLE_BRACKET			A shape enclosed in brackets.
DOUBLE_BRACE			A shape enclosed in braces.
STAR_4
DOUBLE_WAVE
BLANK_ACTION_BUTTON
HOME_ACTION_BUTTON
HELP_ACTION_BUTTON
INFORMATION_ACTION_BUTTON
FORWARD_NEXT_ACTION_BUTTON
BACK_PREVIOUS_ACTION_BUTTON
END_ACTION_BUTTON
BEGINNING_ACTION_BUTTON
RETURN_ACTION_BUTTON
DOCUMENT_ACTION_BUTTON
SOUND_ACTION_BUTTON
MOVIE_ACTION_BUTTON
HOST_CONTROL			This value SHOULD NOT be used.
TEXT_BOX
HEPTAGON
DECAGON
DODECAGON
STAR_6
STAR_7
STAR_10
STAR_12
ROUND_SINGLE_CORNER_RECTANGLE
ROUND_SAME_SIDE_CORNER_RECTANGLE
ROUND_DIAGONAL_CORNER_RECTANGLE
SNIP_ROUND_SINGLE_CORNER_RECTANGLE
SNIP_SINGLE_CORNER_RECTANGLE
SNIP_SAME_SIDE_CORNER_RECTANGLE
SNIP_DIAGONAL_CORNER_RECTANGLE
TEARDROP
PIE
HALF_FRAME
L_SHAPE
DIAGONAL_STRIPE
CHORD
CLOUD
MATH_PLUS
MATH_MINUS
MATH_MULTIPLY
MATH_DIVIDE
MATH_EQUAL
MATH_NOT_EQUAL
LINE_INV
NON_ISOSCELES_TRAPEZOID
PIE_WEDGE
LEFT_CIRCULAR_ARROW
LEFT_RIGHT_CIRCULAR_ARROW
SWOOSH_ARROW
LEFT_RIGHT_RIBBON
TEXT_NO_SHAPE
GEAR_6
GEAR_9
FUNNEL
CORNER_TABS
SQUARE_TABS
PLAQUE_TABS
CHART_X
CHART_STAR
CHART_PLUS
FRAME
MODEL_3_D
ROUND_CALLOUT			There is no such type in Excel
TEXT_ARCH_LEFT_POUR			There is no such type in Excel
TEXT_ARCH_RIGHT_POUR			There is no such type in Excel
TEXT_ARCH_LEFT_CURVE			There is no such type in Excel
TEXT_ARCH_RIGHT_CURVE			There is no such type in Excel
UNKNOWN

constant

AxisType number

Utility class containing constants. Represents the axis type.

Properties

Name	Type	Optional	Description
CATEGORY			Category axis
VALUE			Value axis
SERIES			Series axis

constant

BackgroundMode number

Utility class containing constants. Represents the display mode of the background.

Properties

Name	Type	Optional	Description
AUTOMATIC			Automatic
OPAQUE			Opaque
TRANSPARENT			Transparent

constant

BackgroundType number

Utility class containing constants. Enumerates cell background pattern types.

Properties

Name	Type	Optional	Description
DIAGONAL_CROSSHATCH			Represents diagonal crosshatch pattern.
DIAGONAL_STRIPE			Represents diagonal stripe pattern.
GRAY_6			Represents 6.25% gray pattern
GRAY_12			Represents 12.5% gray pattern
GRAY_25			Represents 25% gray pattern.
GRAY_50			Represents 50% gray pattern.
GRAY_75			Represents 75% gray pattern.
HORIZONTAL_STRIPE			Represents horizontal stripe pattern.
NONE			Represents no background.
REVERSE_DIAGONAL_STRIPE			Represents reverse diagonal stripe pattern.
SOLID			Represents solid pattern.
THICK_DIAGONAL_CROSSHATCH			Represents thick diagonal crosshatch pattern.
THIN_DIAGONAL_CROSSHATCH			Represents thin diagonal crosshatch pattern.
THIN_DIAGONAL_STRIPE			Represents thin diagonal stripe pattern.
THIN_HORIZONTAL_CROSSHATCH			Represents thin horizontal crosshatch pattern.
THIN_HORIZONTAL_STRIPE			Represents thin horizontal stripe pattern.
THIN_REVERSE_DIAGONAL_STRIPE			Represents thin reverse diagonal stripe pattern.
THIN_VERTICAL_STRIPE			Represents thin vertical stripe pattern.
VERTICAL_STRIPE			Represents vertical stripe pattern.

constant

Bar3DShapeType number

Utility class containing constants. Represents the shape used with the 3-D bar or column chart.

Properties

Name	Type	Optional	Description
BOX			Box
PYRAMID_TO_POINT			PyramidToPoint
PYRAMID_TO_MAX			PyramidToMax
CYLINDER			Cylinder
CONE_TO_POINT			ConeToPoint
CONE_TO_MAX			ConeToMax

constant

BevelPresetType number

Utility class containing constants. Represents a preset for a type of bevel which can be applied to a shape in 3D.

Properties

Name	Type	Optional	Description
NONE			No bevel
ANGLE			Angle
ART_DECO			Art deco
CIRCLE			Circle
CONVEX			Convex
COOL_SLANT			Cool slant
CROSS			Cross
DIVOT			Divot
HARD_EDGE			Hard edge
RELAXED_INSET			Relaxed inset
RIBLET			Riblet
SLOPE			Slope
SOFT_ROUND			Soft round

constant

BevelType number

Utility class containing constants. Represents a preset for a type of bevel which can be applied to a shape in 3D.

Properties

Name	Type	Optional	Description
NONE			No bevel
ANGLE			Angle
ART_DECO			Art deco
CIRCLE			Circle
CONVEX			Convex
COOL_SLANT			Cool slant
CROSS			Cross
DIVOT			Divot
HARD_EDGE			Hard edge
RELAXED_INSET			Relaxed inset
RIBLET			Riblet
SLOPE			Slope
SOFT_ROUND			Soft round

constant

BorderType number

Utility class containing constants. Enumerates the border line and diagonal line types.

Properties

Name	Type	Optional	Description
BOTTOM_BORDER			Represents bottom border line.
DIAGONAL_DOWN			Represents the diagonal line from top left to right bottom.
DIAGONAL_UP			Represents the diagonal line from bottom left to right top.
LEFT_BORDER			Represents left border line.
RIGHT_BORDER			Represents right border line exists.
TOP_BORDER			Represents top border line.
HORIZONTAL			Only for dynamic style,such as conditional formatting.
VERTICAL			Only for dynamic style,such as conditional formatting.

constant

BubbleSizeRepresents number

Utility class containing constants. Represents what the bubble size represents on a bubble chart.

Properties

Name	Type	Optional	Description
SIZE_IS_AREA			Represents the value of Series.BubbleSizes is area of the bubble.
SIZE_IS_WIDTH			Represents the value of Series.BubbleSizes is width of the bubble.

constant

BuiltinStyleType number

Utility class containing constants. Represents all built-in style types.

Properties

Name	Type	Optional	Description
TWENTY_PERCENT_ACCENT_1
TWENTY_PERCENT_ACCENT_2
TWENTY_PERCENT_ACCENT_3
TWENTY_PERCENT_ACCENT_4
TWENTY_PERCENT_ACCENT_5
TWENTY_PERCENT_ACCENT_6
FORTY_PERCENT_ACCENT_1
FORTY_PERCENT_ACCENT_2
FORTY_PERCENT_ACCENT_3
FORTY_PERCENT_ACCENT_4
FORTY_PERCENT_ACCENT_5
FORTY_PERCENT_ACCENT_6
SIXTY_PERCENT_ACCENT_1
SIXTY_PERCENT_ACCENT_2
SIXTY_PERCENT_ACCENT_3
SIXTY_PERCENT_ACCENT_4
SIXTY_PERCENT_ACCENT_5
SIXTY_PERCENT_ACCENT_6
ACCENT_1
ACCENT_2
ACCENT_3
ACCENT_4
ACCENT_5
ACCENT_6
BAD
CALCULATION
CHECK_CELL
COMMA
COMMA_1
CURRENCY
CURRENCY_1
EXPLANATORY_TEXT
GOOD
HEADER_1
HEADER_2
HEADER_3
HEADER_4
HYPERLINK
FOLLOWED_HYPERLINK
INPUT
LINKED_CELL
NEUTRAL
NORMAL
NOTE
OUTPUT
PERCENT
TITLE
TOTAL
WARNING_TEXT
ROW_LEVEL
COLUMN_LEVEL

constant

BulletType number

Utility class containing constants. Represents the type of the bullet.

Properties

Name	Type	Optional	Description
NONE			No bullet.
CHARACTER			Character bullet.
PICTURE			Image bullet.
AUTO_NUMBERED			Automatic numbered bullet.

constant

CalcModeType number

Utility class containing constants. Represents the mode type of calculating formulas. Only sets for MS Excel.

Properties

Name	Type	Optional	Description
AUTOMATIC
AUTOMATIC_EXCEPT_TABLE
MANUAL

constant

CalculationPrecisionStrategy number

Utility class containing constants. 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.

Properties

Name	Type	Optional	Description
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.
ROUND			Rounds the calculation result according with significant digits.
DECIMAL			Uses decimal as operands when possible. Most inefficient for performance.

constant

CategoryType number

Utility class containing constants. Represents the category axis type.

Properties

Name	Type	Optional	Description
AUTOMATIC_SCALE			AutomaticScale
CATEGORY_SCALE			CategoryScale
TIME_SCALE			TimeScale

constant

CellBorderType number

Utility class containing constants. Enumerates a cell's border type.

Properties

Name	Type	Optional	Description
DASH_DOT			Represents thin dash-dotted line.
DASH_DOT_DOT			Represents thin dash-dot-dotted line.
DASHED			Represents dashed line.
DOTTED			Represents dotted line.
DOUBLE			Represents double line.
HAIR			Represents hair line.
MEDIUM_DASH_DOT			Represents medium dash-dotted line.
MEDIUM_DASH_DOT_DOT			Represents medium dash-dot-dotted line.
MEDIUM_DASHED			Represents medium dashed line.
NONE			Represents no line.
MEDIUM			Represents medium line.
SLANTED_DASH_DOT			Represents slanted medium dash-dotted line.
THICK			Represents thick line.
THIN			Represents thin line.

constant

CellValueFormatStrategy number

Utility class containing constants. Specifies how to apply style for the value of the cell.

Properties

Name	Type	Optional	Description
NONE			Not formatted.
CELL_STYLE			Only formatted with the cell's original style.
DISPLAY_STYLE			Formatted with the cell's displayed style.
DISPLAY_STRING			Gets the displayed string shown in ms excel. The main difference from DISPLAY_STYLE 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.

constant

CellValueType number

Utility class containing constants. Specifies a cell value type.

Properties

Name	Type	Optional	Description
IS_UNKNOWN			Cell value type is unknown.
IS_NULL			Blank cell. Corresponding value should be null.
IS_NUMERIC			Cell value is numeric. Corresponding value must be int or double.
IS_DATE_TIME			Cell value is datetime. Corresponding value must be DateTime.
IS_STRING			Cell value is string. Corresponding value must be string.
IS_BOOL			Cell value is boolean. Corresponding value must be bool.
IS_ERROR			Cell contains error value. Corresponding value must be error string.

constant

ChartLineFormattingType number

Utility class containing constants. Represents line format type of chart line.

Properties

Name	Type	Optional	Description
AUTOMATIC			Represents automatic formatting type.
SOLID			Represents solid formatting type.
NONE			Represents none formatting type.
GRADIENT			Gradient

constant

ChartMarkerType number

Utility class containing constants. Represents the marker style in a line chart, scatter chart, or radar chart.

Properties

Name	Type	Optional	Description
AUTOMATIC			Automatic markers.
CIRCLE			Circular markers.
DASH			Long bar markers
DIAMOND			Diamond-shaped markers.
DOT			Short bar markers.
NONE			No markers.
SQUARE_PLUS			Square markers with a plus sign.
SQUARE			Square markers.
SQUARE_STAR			Square markers with an asterisk.
TRIANGLE			Triangular markers.
SQUARE_X			Square markers with an X.
PICTURE			Picture

constant

ChartSplitType number

Utility class containing constants. Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.

Properties

Name	Type	Optional	Description
POSITION			Represents the data points shall be split between the pie and the second chart by putting the last Split Position of the data points in the second chart
VALUE			Represents the data points shall be split between the pie and the second chart by putting the data points with value less than Split Position in the second chart.
PERCENT_VALUE			Represents the data points shall be split between the pie and the second chart by putting the points with percentage less than Split Position percent in the second chart.
CUSTOM			Represents the data points shall be split between the pie and the second chart according to the Custom Split values.
AUTO			Represents the data points shall be split using the default mechanism for this chart type. NOTE: This member is now obsolete. Instead, please use Series.IsAutoSplit property. This property will be removed 12 months later since September 2023. Aspose apologizes for any inconvenience you may have experienced.

constant

ChartTextDirectionType number

Utility class containing constants. Represents the text direction type of the chart.

Properties

Name	Type	Optional	Description
HORIZONTAL			Horizontal direction type.
VERTICAL			Vertical direction type.
ROTATE_90			Rotate 90 angle.
ROTATE_270			Rotate 270 angle.
STACKED			Stacked text.

constant

ChartType number

Utility class containing constants. Enumerates all chart types used in Excel.

Properties

Name	Type	Optional	Description
AREA			Represents Area Chart.
AREA_STACKED			Represents Stacked Area Chart.
AREA_100_PERCENT_STACKED			Represents 100% Stacked Area Chart.
AREA_3_D			Represents 3D Area Chart.
AREA_3_D_STACKED			Represents 3D Stacked Area Chart.
AREA_3_D_100_PERCENT_STACKED			Represents 3D 100% Stacked Area Chart.
BAR			Represents Bar Chart: Clustered Bar Chart.
BAR_STACKED			Represents Stacked Bar Chart.
BAR_100_PERCENT_STACKED			Represents 100% Stacked Bar Chart.
BAR_3_D_CLUSTERED			Represents 3D Clustered Bar Chart.
BAR_3_D_STACKED			Represents 3D Stacked Bar Chart.
BAR_3_D_100_PERCENT_STACKED			Represents 3D 100% Stacked Bar Chart.
BUBBLE			Represents Bubble Chart.
BUBBLE_3_D			Represents 3D Bubble Chart.
COLUMN			Represents Column Chart: Clustered Column Chart.
COLUMN_STACKED			Represents Stacked Column Chart.
COLUMN_100_PERCENT_STACKED			Represents 100% Stacked Column Chart.
COLUMN_3_D			Represents 3D Column Chart.
COLUMN_3_D_CLUSTERED			Represents 3D Clustered Column Chart.
COLUMN_3_D_STACKED			Represents 3D Stacked Column Chart.
COLUMN_3_D_100_PERCENT_STACKED			Represents 3D 100% Stacked Column Chart.
CONE			Represents Cone Chart.
CONE_STACKED			Represents Stacked Cone Chart.
CONE_100_PERCENT_STACKED			Represents 100% Stacked Cone Chart.
CONICAL_BAR			Represents Conical Bar Chart.
CONICAL_BAR_STACKED			Represents Stacked Conical Bar Chart.
CONICAL_BAR_100_PERCENT_STACKED			Represents 100% Stacked Conical Bar Chart.
CONICAL_COLUMN_3_D			Represents 3D Conical Column Chart.
CYLINDER			Represents Cylinder Chart.
CYLINDER_STACKED			Represents Stacked Cylinder Chart.
CYLINDER_100_PERCENT_STACKED			Represents 100% Stacked Cylinder Chart.
CYLINDRICAL_BAR			Represents Cylindrical Bar Chart.
CYLINDRICAL_BAR_STACKED			Represents Stacked Cylindrical Bar Chart.
CYLINDRICAL_BAR_100_PERCENT_STACKED			Represents 100% Stacked Cylindrical Bar Chart.
CYLINDRICAL_COLUMN_3_D			Represents 3D Cylindrical Column Chart.
DOUGHNUT			Represents Doughnut Chart.
DOUGHNUT_EXPLODED			Represents Exploded Doughnut Chart.
LINE			Represents Line Chart.
LINE_STACKED			Represents Stacked Line Chart.
LINE_100_PERCENT_STACKED			Represents 100% Stacked Line Chart.
LINE_WITH_DATA_MARKERS			Represents Line Chart with data markers.
LINE_STACKED_WITH_DATA_MARKERS			Represents Stacked Line Chart with data markers.
LINE_100_PERCENT_STACKED_WITH_DATA_MARKERS			Represents 100% Stacked Line Chart with data markers.
LINE_3_D			Represents 3D Line Chart.
PIE			Represents Pie Chart.
PIE_3_D			Represents 3D Pie Chart.
PIE_PIE			Represents Pie of Pie Chart.
PIE_EXPLODED			Represents Exploded Pie Chart.
PIE_3_D_EXPLODED			Represents 3D Exploded Pie Chart.
PIE_BAR			Represents Bar of Pie Chart.
PYRAMID			Represents Pyramid Chart.
PYRAMID_STACKED			Represents Stacked Pyramid Chart.
PYRAMID_100_PERCENT_STACKED			Represents 100% Stacked Pyramid Chart.
PYRAMID_BAR			Represents Pyramid Bar Chart.
PYRAMID_BAR_STACKED			Represents Stacked Pyramid Bar Chart.
PYRAMID_BAR_100_PERCENT_STACKED			Represents 100% Stacked Pyramid Bar Chart.
PYRAMID_COLUMN_3_D			Represents 3D Pyramid Column Chart.
RADAR			Represents Radar Chart.
RADAR_WITH_DATA_MARKERS			Represents Radar Chart with data markers.
RADAR_FILLED			Represents Filled Radar Chart.
SCATTER			Represents Scatter Chart.
SCATTER_CONNECTED_BY_CURVES_WITH_DATA_MARKER			Represents Scatter Chart connected by curves, with data markers.
SCATTER_CONNECTED_BY_CURVES_WITHOUT_DATA_MARKER			Represents Scatter Chart connected by curves, without data markers.
SCATTER_CONNECTED_BY_LINES_WITH_DATA_MARKER			Represents Scatter Chart connected by lines, with data markers.
SCATTER_CONNECTED_BY_LINES_WITHOUT_DATA_MARKER			Represents Scatter Chart connected by lines, without data markers.
STOCK_HIGH_LOW_CLOSE			Represents High-Low-Close Stock Chart.
STOCK_OPEN_HIGH_LOW_CLOSE			Represents Open-High-Low-Close Stock Chart.
STOCK_VOLUME_HIGH_LOW_CLOSE			Represents Volume-High-Low-Close Stock Chart.
STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE			Represents Volume-Open-High-Low-Close Stock Chart.
SURFACE_3_D			Represents Surface Chart: 3D Surface Chart.
SURFACE_WIREFRAME_3_D			Represents Wireframe 3D Surface Chart.
SURFACE_CONTOUR			Represents Contour Chart.
SURFACE_CONTOUR_WIREFRAME			Represents Wireframe Contour Chart.
BOX_WHISKER			The series is laid out as box and whisker.
FUNNEL			The series is laid out as a funnel.
PARETO_LINE			The series is laid out as pareto lines.
SUNBURST			The series is laid out as a sunburst.
TREEMAP			The series is laid out as a treemap.
WATERFALL			The series is laid out as a waterfall.
HISTOGRAM			The series is laid out as a histogram.
MAP			The series is laid out as a region map.
RADIAL_HISTOGRAM			The series is laid out as a radial historgram. It is used only for rendering

constant

CheckValueType number

Utility class containing constants. Represents the check value type of the check box.

Properties

Name	Type	Optional	Description
UN_CHECKED			UnChecked
CHECKED			Checked
MIXED			Mixed

constant

ColorDepth number

Utility class containing constants. Enumerates Bit Depth Type for tiff image.

Properties

Name	Type	Optional	Description
DEFAULT			Default value, not set value.
FORMAT_1_BPP			1 bit per pixel
FORMAT_4_BPP			4 bits per pixel
FORMAT_8_BPP			8 bits per pixel
FORMAT_24_BPP			24 bits per pixel
FORMAT_32_BPP			32 bits per pixel

constant

ColorType number

Utility class containing constants. Represents all color type

Properties

Name	Type	Optional	Description
AUTOMATIC			Automatic color.
AUTOMATIC_INDEX			It's automatic color,but the displayed color depends the setting of the OS System. Not supported.
RGB			The RGB color.
INDEXED_COLOR			The color index in the color palette.
THEME			The theme color.

constant

CommentTitleType number

Utility class containing constants. Represents comment title type while rendering when comment is set to display at end of sheet.

Properties

Name	Type	Optional	Description
CELL			Represents comment title cell.
COMMENT			Represents comment title comment.
NOTE			Represents comment title note.
REPLY			Represents comment title reply.

constant

ConsolidationFunction number

Utility class containing constants. Represents consolidation function.

Properties

Name	Type	Optional	Description
SUM			Represents Sum function.
COUNT			Represents Count function.
AVERAGE			Represents Average function.
MAX			Represents Max function.
MIN			Represents Min function.
PRODUCT			Represents Product function.
COUNT_NUMS			Represents Count Nums function.
STD_DEV			Represents StdDev function.
STD_DEVP			Represents StdDevp function.
VAR			Represents Var function.
VARP			Represents Varp function.
DISTINCT_COUNT			Represents Distinct Count function. Only valid for PivotTable with Data Module created since by 2013.

constant

ControlBorderType number

Utility class containing constants. Represents the border type of the ActiveX control.

Properties

Name	Type	Optional	Description
NONE			No border.
SINGLE			The single line.

constant

ControlCaptionAlignmentType number

Utility class containing constants. Represents the position of the Caption relative to the control.

Properties

Name	Type	Optional	Description
LEFT			The left of the control.
RIGHT			The right of the control.

constant

ControlListStyle number

Utility class containing constants. Represents the visual appearance of the list in a ListBox or ComboBox.

Properties

Name	Type	Optional	Description
PLAIN			Displays a list in which the background of an item is highlighted when it is selected.
OPTION			Displays a list in which an option button or a checkbox next to each entry displays the selection state of that item.

constant

ControlMatchEntryType number

Utility class containing constants. Represents how a ListBox or ComboBox searches its list as the user types.

Properties

Name	Type	Optional	Description
FIRST_LETTER			The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter.
COMPLETE			As each character is typed, the control searches for an entry matching all characters entered.
NONE			The list will not be searched when characters are typed.

constant

ControlMousePointerType number

Utility class containing constants. Represents the type of icon displayed as the mouse pointer for the control.

Properties

Name	Type	Optional	Description
DEFAULT			Standard pointer.
ARROW			Arrow.
CROSS			Cross-hair pointer.
I_BEAM			I-beam.
SIZE_NESW			Double arrow pointing northeast and southwest.
SIZE_NS			Double arrow pointing north and south.
SIZE_NWSE			Double arrow pointing northwest and southeast.
SIZE_WE			Double arrow pointing west and east.
UP_ARROW			Up arrow.
HOUR_GLASS			Hourglass.
NO_DROP			"Not” symbol (circle with a diagonal line) on top of the object being dragged.
APP_STARTING			Arrow with an hourglass.
HELP			Arrow with a question mark.
SIZE_ALL			"Size-all” cursor (arrows pointing north, south, east, and west).
CUSTOM			Uses the icon specified by the MouseIcon property.

constant

ControlPictureAlignmentType number

Utility class containing constants. Represents the alignment of the picture inside the Form or Image.

Properties

Name	Type	Optional	Description
TOP_LEFT			The top left corner.
TOP_RIGHT			The top right corner.
CENTER			The center.
BOTTOM_LEFT			The bottom left corner.
BOTTOM_RIGHT			The bottom right corner.

constant

ControlPicturePositionType number

Utility class containing constants. Represents the location of the control's picture relative to its caption.

Properties

Name	Type	Optional	Description
LEFT_TOP			The picture appears to the left of the caption. The caption is aligned with the top of the picture.
LEFT_CENTER			The picture appears to the left of the caption. The caption is centered relative to the picture.
LEFT_BOTTOM			The picture appears to the left of the caption. The caption is aligned with the bottom of the picture.
RIGHT_TOP			The picture appears to the right of the caption. The caption is aligned with the top of the picture.
RIGHT_CENTER			The picture appears to the right of the caption. The caption is centered relative to the picture.
RIGHT_BOTTOM			The picture appears to the right of the caption. The caption is aligned with the bottom of the picture.
ABOVE_LEFT			The picture appears above the caption. The caption is aligned with the left edge of the picture.
ABOVE_CENTER			The picture appears above the caption. The caption is centered below the picture.
ABOVE_RIGHT			The picture appears above the caption. The caption is aligned with the right edge of the picture.
BELOW_LEFT			The picture appears below the caption. The caption is aligned with the left edge of the picture.
BELOW_CENTER			The picture appears below the caption. The caption is centered above the picture.
BELOW_RIGHT			The picture appears below the caption. The caption is aligned with the right edge of the picture.
CENTER			The picture appears in the center of the control. The caption is centered horizontally and vertically on top of the picture.

constant

ControlPictureSizeMode number

Utility class containing constants. Represents how to display the picture.

Properties

Name	Type	Optional	Description
CLIP			Crops any part of the picture that is larger than the control's boundaries.
STRETCH			Stretches the picture to fill the control's area. This setting distorts the picture in either the horizontal or vertical direction.
ZOOM			Enlarges the picture, but does not distort the picture in either the horizontal or vertical direction.

constant

ControlScrollBarType number

Utility class containing constants. Represents the type of scroll bar.

Properties

Name	Type	Optional	Description
NONE			Displays no scroll bars.
HORIZONTAL			Displays a horizontal scroll bar.
BARS_VERTICAL			Displays a vertical scroll bar.
BARS_BOTH			Displays both a horizontal and a vertical scroll bar.

constant

ControlScrollOrientation number

Utility class containing constants. Represents type of scroll orientation

Properties

Name	Type	Optional	Description
AUTO			Control is rendered horizontally when the control's width is greater than its height. Control is rendered vertically otherwise.
VERTICAL			Control is rendered vertically.
HORIZONTAL			Control is rendered horizontally.

constant

ControlSpecialEffectType number

Utility class containing constants. Represents the type of special effect.

Properties

Name	Type	Optional	Description
FLAT			Flat
RAISED			Raised
SUNKEN			Sunken
ETCHED			Etched
BUMP			Bump

constant

ControlType number

Utility class containing constants. Represents all type of ActiveX control.

Properties

Name	Type	Optional	Description
COMMAND_BUTTON			Button
COMBO_BOX			ComboBox
CHECK_BOX			CheckBox
LIST_BOX			ListBox
TEXT_BOX			TextBox
SPIN_BUTTON			Spinner
RADIO_BUTTON			RadioButton
LABEL			Label
IMAGE			Image
TOGGLE_BUTTON			ToggleButton
SCROLL_BAR			ScrollBar
BAR_CODE			ScrollBar Unsupported.
UNKNOWN			Unknown

constant

CopyFormatType number

Utility class containing constants. Represents type of copying format when inserting rows.

Properties

Name	Type	Optional	Description
SAME_AS_ABOVE			Formats same as above row.
SAME_AS_BELOW			Formats same as below row.
CLEAR			Clears formatting.

constant

CountryCode number

Utility class containing constants. Represents Excel country identifiers.

Properties

Name	Type	Optional	Description
DEFAULT
USA			United States
CANADA			Canada
LATIN_AMERIC			Latin America, except Brazil
RUSSIA			Russia
EGYPT			Egypt
GREECE			Greece
NETHERLANDS			Netherlands
BELGIUM			Belgium
FRANCE			France
SPAIN			Spain
HUNGARY			Hungary
ITALY			Italy
SWITZERLAND			Switzerland
AUSTRIA			Austria
UNITED_KINGDOM			United Kingdom
DENMARK			Denmark
SWEDEN			Sweden
NORWAY			Norway
POLAND			Poland
GERMANY			Germany
MEXICO			Mexico
BRAZIL			Brazil
AUSTRALIA			Australia
NEW_ZEALAND			New Zealand
THAILAND			Thailand
JAPAN			Japan
SOUTH_KOREA			SouthKorea
VIET_NAM			Viet Nam
CHINA			People's Republic of China
TURKEY			Turkey
INDIA			India
ALGERIA			Algeria
MOROCCO			Morocco
LIBYA			Libya
PORTUGAL			Portugal
ICELAND			Iceland
FINLAND			Finland
CZECH			Czech Republic
TAIWAN			Taiwan
LEBANON			Lebanon
JORDAN			Jordan
SYRIA			Syria
IRAQ			Iraq
KUWAIT			Kuwait
SAUDI			Saudi Arabia
UNITED_ARAB_EMIRATES			United Arab Emirates
ISRAEL			Israel
QATAR			Qatar
IRAN			Iran

constant

CredentialsMethodType number

Utility class containing constants. Specifies Credentials method used for server access.

Properties

Name	Type	Optional	Description
INTEGRATED			Integrated Authentication
NONE			No Credentials
PROMPT			Prompt Credentials
STORED			Stored Credentials

constant

CrossType number

Utility class containing constants. Represents the axis cross type.

Properties

Name	Type	Optional	Description
AUTOMATIC			Microsoft Excel sets the axis crossing point.
MAXIMUM			The axis crosses at the maximum value.
MINIMUM			The axis crosses at the minimum value.
CUSTOM			The axis crosses at the custom value.

constant

DataBarAxisPosition number

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

Properties

Name	Type	Optional	Description
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.
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.
NONE			No axis is displayed, and both positive and negative values are displayed in the left-to-right direction.

constant

DataBarBorderType number

Utility class containing constants. Specifies the border type of a data bar.

Properties

Name	Type	Optional	Description
NONE			The data bar has no border.
SOLID			The data bar has a solid border.

constant

DataBarFillType number

Utility class containing constants. Specifies how a data bar is filled with color.

Properties

Name	Type	Optional	Description
SOLID			The data bar is filled with solid color.
GRADIENT			The data bar is filled with a color gradient.

constant

DataBarNegativeColorType number

Utility class containing constants. Specifies whether to use the same border and fill color as positive data bars.

Properties

Name	Type	Optional	Description
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.
SAME_AS_POSITIVE			Use the same color as positive data bars.

constant

DataLabelShapeType number

Utility class containing constants. Specifies the preset shape geometry that is to be used for a chart.

Properties

Name	Type	Optional	Description
RECT			Represents the rectangle shape.
ROUND_RECT			Represents the round rectangle shape.
ELLIPSE			Represents the ellipse shape.
RIGHT_ARROW_CALLOUT			Represents the right arrow callout shape.
DOWN_ARROW_CALLOUT			Represents the down arrow callout shape.
LEFT_ARROW_CALLOUT			Represents the left arrow callout shape.
UP_ARROW_CALLOUT			Represents the up arrow callout shape.
WEDGE_RECT_CALLOUT			Represents the wedge rectangle callout shape.
WEDGE_ROUND_RECT_CALLOUT			Represents the wedge round rectangle callout shape.
WEDGE_ELLIPSE_CALLOUT			Represents the wedge ellipse callout shape.
LINE_CALLOUT			Represents the line callout shape.
BENT_LINE_CALLOUT			Represents the bent line callout shape.
LINE_WITH_ACCENT_BAR_CALLOUT			Represents the line with accent bar callout shape.
BENT_LINE_WITH_ACCENT_BAR_CALLOUT			Represents the bent line with accent bar callout shape.
LINE			This type is only used for special file processing

constant

DataLabelsSeparatorType number

Utility class containing constants. Represents the separator type of DataLabels.

Properties

Name	Type	Optional	Description
AUTO			Represents automatic separator
SPACE			Represents space(" ")
COMMA			Represents comma(",")
SEMICOLON			Represents semicolon(";")
PERIOD			Represents period(".")
NEW_LINE			Represents newline("\n")
CUSTOM			Represents custom separator

constant

DateTimeGroupingType number

Utility class containing constants. Specifies how to group dateTime values.

Properties

Name	Type	Optional	Description
DAY			Group by day.
HOUR			Group by hour.
MINUTE			Group by Minute.
MONTH			Group by Month.
SECOND			Group by Second.
YEAR			Group by Year.

constant

DefaultEditLanguage number

Utility class containing constants. Represents the default edit language.

Properties

Name	Type	Optional	Description
AUTO			Represents auto detecting edit language according to the text itself.
ENGLISH			Represents English language.
CJK			Represents Chinese, Japanese, Korean language.

constant

DirectoryType number

Utility class containing constants. Represents the directory type of the file name.

Properties

Name	Type	Optional	Description
VOLUME			Represents an MS-DOS drive letter. It is followed by the drive letter. Or UNC file names, such as \server\share\myfile.xls
SAME_VOLUME			Indicates that the source workbook is on the same drive as the dependent workbook (the drive letter is omitted)
DOWN_DIRECTORY			Indicates that the source workbook is in a subdirectory of the current directory.
UP_DIRECTORY			Indicates that the source workbook is in the parent directory of the current directory.

constant

DisplayDrawingObjects number

Utility class containing constants. Represents whether and how to show objects in the workbook.

Properties

Name	Type	Optional	Description
DISPLAY_SHAPES			Show all objects
PLACEHOLDERS			Show placeholders
HIDE			Hide all shapes.

constant

DisplayUnitType number

Utility class containing constants. Represents the type of display unit of chart's axis.

Properties

Name	Type	Optional	Description
NONE			Display unit is None.
HUNDREDS			Specifies the values on the chart shall be divided by 100.
THOUSANDS			Specifies the values on the chart shall be divided by 1,000.
TEN_THOUSANDS			Specifies the values on the chart shall be divided by 10,000.
HUNDRED_THOUSANDS			Specifies the values on the chart shall be divided by 100,000.
MILLIONS			Specifies the values on the chart shall be divided by 1,000,000.
TEN_MILLIONS			Specifies the values on the chart shall be divided by 10,000,000.
HUNDRED_MILLIONS			Specifies the values on the chart shall be divided by 100,000,000.
BILLIONS			Specifies the values on the chart shall be divided by 1,000,000,000.
TRILLIONS			Specifies the values on the chart shall be divided by 1,000,000,000,000.
PERCENTAGE			The values on the chart shall be divided by 0.01.
CUST			specifies a custom value for the display unit. NOTE: This member is now obsolete. Instead, please use DisplayUnitType.Custom. This property will be removed 12 months later since January 2023. Aspose apologizes for any inconvenience you may have experienced.
CUSTOM			specifies a custom value for the display unit.

constant

DropButtonStyle number

Utility class containing constants. Represents the symbol displayed on the drop button.

Properties

Name	Type	Optional	Description
PLAIN			Displays a button with no symbol.
ARROW			Displays a button with a down arrow.
ELLIPSIS			Displays a button with an ellipsis (...).
REDUCE			Displays a button with a horizontal line like an underscore character.

constant

DynamicFilterType number

Utility class containing constants. Dynamic filter type.

Properties

Name	Type	Optional	Description
ABOVE_AVERAGE			Shows values that are above average.
BELOW_AVERAGE			Shows values that are below average.
LAST_MONTH			Shows last month's dates.
LAST_QUARTER			Shows last quarter's dates.
LAST_WEEK			Shows last week's dates.
LAST_YEAR			Shows last year's dates.
JANUARY			Shows the dates that are in January, regardless of year.
OCTOBER			Shows the dates that are in October, regardless of year.
NOVEMBER			Shows the dates that are in November, regardless of year.
DECEMBER			Shows the dates that are in December, regardless of year.
FEBRUARY			Shows the dates that are in February, regardless of year.
MARCH			Shows the dates that are in March, regardless of year.
APRIL			Shows the dates that are in April, regardless of year.
MAY			Shows the dates that are in May, regardless of year.
JUNE			Shows the dates that are in June, regardless of year.
JULY			Shows the dates that are in July, regardless of year.
AUGUST			Shows the dates that are in August, regardless of year.
SEPTEMBER			Shows the dates that are in September, regardless of year.
NEXT_MONTH			Shows next month's dates.
NEXT_QUARTER			Shows next quarter's dates.
NEXT_WEEK			Shows next week's dates.
NEXT_YEAR			Shows next year's dates.
NONE			None.
QUARTER_1			Shows the dates that are in the 1st quarter, regardless of year.
QUARTER_2			Shows the dates that are in the 2nd quarter, regardless of year.
QUARTER_3			Shows the dates that are in the 3rd quarter, regardless of year.
QUARTER_4			Shows the dates that are in the 4th quarter, regardless of year.
THIS_MONTH			Shows this month's dates.
THIS_QUARTER			Shows this quarter's dates.
THIS_WEEK			Shows this week's dates.
THIS_YEAR			Shows this year's dates.
TODAY			Shows today's dates.
TOMORROW			Shows tomorrow's dates.
YEAR_TO_DATE			Shows the dates between the beginning of the year and today, inclusive.
YESTERDAY			Shows yesterday's dates.

constant

EmfRenderSetting number

Utility class containing constants. Setting for rendering Emf metafile.

Properties

Name	Type	Optional	Description
EMF_ONLY			Only rendering Emf records.
EMF_PLUS_PREFER			Prefer rendering EmfPlus records.

constant

EncryptionType number

Utility class containing constants. 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.

Properties

Name	Type	Optional	Description
XOR
COMPATIBLE			Office 97/2000 compatible.
ENHANCED_CRYPTOGRAPHIC_PROVIDER_V_1
STRONG_CRYPTOGRAPHIC_PROVIDER

constant

EquationCharacterPositionType number

Utility class containing constants. Specifies the position of a particular subobject within its parent

Properties

Name	Type	Optional	Description
TOP			At the top of the parent object
BOTTOM			At the bottom of the parent object

constant

EquationCombiningCharacterType number

Utility class containing constants. Type of combining characters.

Properties

Name	Type	Optional	Description
UNKNOWN			Use unknown type when not found in existing type.
DOT_ABOVE			"̇" Unicode: u0307 Combining Dot Above
DIAERESIS			"̈" Unicode: u0308 Combining Diaeresis
THREE_DOTS_ABOVE			"⃛" Unicode: u20db Combining Three Dots Above
CIRCUMFLEX_ACCENT			"̂" Unicode: u0302 Combining Circumflex Accent
CARON			"̌" Unicode: u030c Combining Caron
ACUTE_ACCENT			"́" Unicode: u0301 Combining Acute Accent
GRAVE_ACCENT			"̀" Unicode: u0300 Combining Grave Accent
BREVE			"̆" Unicode: u0306 Combining Combining Breve
TILDE			"̃" Unicode: u0303 Combining Tilde
OVERLINE			"̅" Unicode: u0305 Combining Overline
DOUBLE_OVERLINE			"̿" Unicode: u033f Combining Double Overline
TOP_CURLY_BRACKET			"⏞" Unicode: u23de Combining Top Curly Bracket
BOTTOM_CURLY_BRACKET			"⏟" Unicode: u23df Combining Bottom Curly Bracket
LEFT_ARROW_ABOVE			"⃖" Unicode: u20d6 Combining Left Arrow Above
RIGHT_ARROW_ABOVE			"⃗" Unicode: u20d7 Combining Right Arrow Above
LEFT_RIGHT_ARROW_ABOVE			"⃡" Unicode: u20e1 Combining Left Right Arrow Above
LEFT_HARPOON_ABOVE			"⃐" Unicode: u20d0 Combining Left Harpoon Above
RIGHT_HARPOON_ABOVE			"⃑" Unicode: u20d1 Combining Right Harpoon Above
LEFTWARDS_ARROW			"←" Unicode: u2190 Leftwards Arrow
RIGHTWARDS_ARROW			"→" Unicode: u2192 Rightwards Arrow
LEFT_RIGHT_ARROW			"↔" Unicode: u2194 Left Right Arrow
LEFTWARDS_DOUBLE_ARROW			"⇐" Unicode: u21d0 Leftwards Double Arrow
RIGHTWARDS_DOUBLE_ARROW			"⇒" Unicode: u21d2 Rightwards Double Arrow
LEFT_RIGHT_DOUBLE_ARROW			"⇔" Unicode: u21d4 Left Right Double Arrow

constant

EquationDelimiterShapeType number

Utility class containing constants. This specifies the shape of delimiters in the delimiter object.

Properties

Name	Type	Optional	Description
CENTERED			The divider is centered around the entire height of its content.
MATCH			The divider is altered to exactly match their contents' height.

constant

EquationFractionType number

Utility class containing constants. This specifies the display style of the fraction bar.

Properties

Name	Type	Optional	Description
BAR			This specifies that the numerator is above and the denominator below is separated by a bar in the middle.
NO_BAR			This specifies that the numerator is above and the denominator below is not separated by a bar in the middle.
LINEAR			This specifies that the numerator is on the left and the denominator is on the right, separated by a '/' in between.
SKEWED			This specifies that the numerator is on the upper left and the denominator is on the lower right, separated by a "/".

constant

EquationHorizontalJustificationType number

Utility class containing constants. This specifies the default horizontal justification of equations in the document.

Properties

Name	Type	Optional	Description
CENTER			Centered
CENTER_GROUP			Centered as Group
LEFT			Left Justified
RIGHT			Right Justified

constant

EquationLimitLocationType number

Utility class containing constants. Specifies the limit location on an operator.

Properties

Name	Type	Optional	Description
UND_OVR			Specifies that the limit is centered above or below the operator.
SUB_SUP			Specifies that the limit is on the right side of the operator.

constant

EquationMathematicalOperatorType number

Utility class containing constants. Mathematical Operators Type

Properties

Name	Type	Optional	Description
UNKNOWN			Use unknown type when not found in existing type.
FOR_ALL			"∀" Unicode:\u2200
COMPLEMENT			"∁" Unicode:\u2201
PARTIAL_DIFFERENTIAL			"∂" Unicode:\u2202
EXISTS			"∃" Unicode:\u2203
NOT_EXISTS			"∄" Unicode:\u2204
EMPTY_SET			"∅" Unicode:\u2205
INCREMENT			"∆" Unicode:\u2206
NABLA			"∇" Unicode:\u2207
ELEMENT_OF			"∈" Unicode:\u2208
NOT_AN_ELEMENT_OF			"∉" Unicode:\u2209
SMALL_ELEMENT_OF			"∊" Unicode:\u220a
CONTAIN			"∋" Unicode:\u220b
NOT_CONTAIN			"∌" Unicode:\u220c
SMALL_CONTAIN			"∍" Unicode:\u220d
END_OF_PROOF			"∎" Unicode:\u220e
NARY_PRODUCT			"∏" Unicode:\u220f
NARY_COPRODUCT			"∐" Unicode:\u2210
NARY_SUMMATION			"∑" Unicode:\u2211
LOGICAL_AND			"∧" Unicode:\u2227
LOGICAL_OR			"∨" Unicode:\u2228
INTERSECTION			"∩" Unicode:\u2229
UNION			"∪" Unicode:\u222a
INTEGRAL			"∫" Unicode:\u222b
DOUBLE_INTEGRAL			"∬" Unicode:\u222c
TRIPLE_INTEGRAL			"∭" Unicode:\u222d
CONTOUR_INTEGRAL			"∮" Unicode:\u222e
SURFACE_INTEGRAL			"∯" Unicode:\u222f
VOLUME_INTEGRAL			"∰" Unicode:\u2230
CLOCKWISE			"∱" Unicode:\u2231
CLOCKWISE_CONTOUR_INTEGRAL			"∲" Unicode:\u2232
ANTICLOCKWISE_CONTOUR_INTEGRAL			"∳" Unicode:\u2233
NARY_LOGICAL_AND			"⋀" Unicode:\u22c0
NARY_LOGICAL_OR			"⋁" Unicode:\u22c1
NARY_INTERSECTION			"⋂" Unicode:\u22c2
NARY_UNION			"⋃" Unicode:\u22c3

constant

EquationNodeType number

Utility class containing constants. Equation node type. Notice: (1)[1-99] Currently there is only one node in the scope, and its enumeration value is 1. The node it specifies is used to store mathematical text. (2)[100-199] Indicates that the node is a component of some special function nodes. (3)[200-] Indicates that the node has some special functions(Usually with 'Equation' suffix. 'EquationParagraph' is a special case.).

Properties

Name	Type	Optional	Description
UN_KNOW			UnKnow
TEXT			specifies a node that stores math text
BASE			Specifies a component of type 'Base'
DENOMINATOR			Specifies a component of type 'Denominator'
NUMERATOR			Specifies a component of type 'Numerator'
FUNCTION_NAME			Specifies a component of type 'FunctionName'
SUBSCRIPT			Specifies a component of type 'Subscript'
SUPERSCRIPT			Specifies a component of type 'Superscript'
DEGREE			Specifies a component of type 'Degree'
MATRIX_ROW			Specifies a component of type 'MatrixRow'.A single row of the matrix
EQUATION_PARAGRAPH			Specifies a mathematical paragraph(oMathPara).
MATHEMATICAL_EQUATION			Specifies an equation or mathematical expression(OMath).
FRACTION_EQUATION			Specifies fractional equation
FUNCTION_EQUATION			Specifies function equation
DELIMITER_EQUATION			Specifies delimiter equation
NARY_EQUATION			Specifies n-ary operator equation
RADICAL_EQUATION			Specifies the radical equation
SUPERSCRIPT_EQUATION			Specifies superscript equation
SUBSCRIPT_EQUATION			Specifies subscript equation
SUB_SUP_EQUATION			Specifies an equation with superscripts and subscripts to the right of the operands.
PRE_SUB_SUP_EQUATION			Specifies an equation with superscripts and subscripts to the left of the operands.
ACCENT_EQUATION			Specifies accent equation
BAR_EQUATION			Specifies bar equation
BORDER_BOX_EQUATION			Specifies border box equation
BOX_EQUATION			Specifies box equation
GROUP_CHARACTER_EQUATION			Specifies Group-Character equation
MATRIX_EQUATION			Specifies the Matrix equation,

constant

EquationVerticalJustificationType number

Utility class containing constants. This specifies the default vertical justification of equations in the document.

Properties

Name	Type	Optional	Description
TOP			top
CENTER			center
BOTTOM			bottom

constant

ErrorBarDisplayType number

Utility class containing constants. Represents error bar display type.

Properties

Name	Type	Optional	Description
BOTH			Both
MINUS			Minus
NONE			None
PLUS			Plus

constant

ErrorBarType number

Utility class containing constants. Represents error bar amount type.

Properties

Name	Type	Optional	Description
CUSTOM			InnerCustom value type.
FIXED_VALUE			Fixed value type.
PERCENT			Percentage type
ST_DEV			Standard deviation type.
ST_ERROR			Standard error type.

constant

ErrorCheckType number

Utility class containing constants. Represents all error check type.

Properties

Name	Type	Optional	Description
EVALUATION_ERROR			Ignore errors when cells contain formulas that result in an error.
CALC			NOTE: This member is now obsolete. Instead, please use ErrorCheckType.EvaluationError enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
EMPTY_CELL_REF			Ignore errors when formulas refer to empty cells.
NUMBER_STORED_AS_TEXT			Ignore errors when numbers are formatted as text or are preceded by an apostrophe
TEXT_NUMBER			Ignore errors when numbers are formatted as text or are preceded by an apostrophe NOTE: This member is now obsolete. Instead, please use ErrorCheckType.NumberStoredAsText enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
INCONSIST_RANGE			Ignore errors when formulas omit certain cells in a region.
INCONSIST_FORMULA			Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.
TWO_DIGIT_TEXT_YEAR			Ignore errors when formulas contain text formatted cells with years represented as 2 digits.
TEXT_DATE			Ignore errors when formulas contain text formatted cells with years represented as 2 digits. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TwoDigitTextYear enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
UNLOCKED_FORMULA			Ignore errors when unlocked cells contain formulas.
UNPROCTED_FORMULA			Ignore errors when unlocked cells contain formulas. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.UnproctedFormula enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
TABLE_DATA_VALIDATION			Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified.
VALIDATION			Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TableDataValidation enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
CALCULATED_COLUMN			Ignore errors when cells contain a value different from a calculated column formula.

constant

ExceptionType number

Utility class containing constants. Represents custom exception type code.

Properties

Name	Type	Optional	Description
CHART			Invalid chart setting.
DATA_TYPE			Invalid data type setting.
DATA_VALIDATION			Invalid data validation setting.
CONDITIONAL_FORMATTING			Invalid data validation setting.
FILE_FORMAT			Invalid file format.
FORMULA			Invalid formula.
INVALID_DATA			Invalid data.
INVALID_OPERATOR			Invalid operator.
INCORRECT_PASSWORD			Incorrect password.
LICENSE			License related errors.
LIMITATION			Out of MS Excel limitation error.
PAGE_SETUP			Invalid page setup setting.
PIVOT_TABLE			Invalid pivotTable setting.
SHAPE			Invalid drawing object setting.
SPARKLINE			Invalid sparkline object setting.
SHEET_NAME			Invalid worksheet name.
SHEET_TYPE			Invalid worksheet type.
INTERRUPTED			The process is interrupted.
IO			The file is invalid.
PERMISSION			Permission is required to open this file.
UNSUPPORTED_FEATURE			Unsupported feature.
UNSUPPORTED_STREAM			Unsupported stream to be opened.
UNDISCLOSED_INFORMATION			Files contains some undisclosed information.
FILE_CORRUPTED			File content is corrupted.

constant

ExternalLinkType number

Utility class containing constants. Represents the type of external link.

Properties

Name	Type	Optional	Description
DDE_LINK			Represents the DDE link.
EXTERNAL			Represents external link.

constant

FileFormatType number

Utility class containing constants. Represents the file format types.

Properties

Name	Type	Optional	Description
CSV			Comma-Separated Values(CSV) text file.
XLSX			Office Open XML SpreadsheetML file (macro-free).
XLSM			Office Open XML SpreadsheetML Macro-Enabled file.
XLTX			Office Open XML SpreadsheetML Template (macro-free).
XLTM			Office Open XML SpreadsheetML Macro-Enabled Template.
XLAM			Office Open XML SpreadsheetML addinMacro-Enabled file.
TSV			Tab-Separated Values(TSV) text file.
TAB_DELIMITED			Tab-Separated Values(TSV) text file, same with TSV.
HTML			HTML format.
M_HTML			MHTML (Web archive) format.
ODS			Open Document Sheet(ODS) file.
EXCEL_97_TO_2003			Excel97-2003 spreadsheet file.
SPREADSHEET_ML			Excel 2003 XML Data file.
XLSB			The Excel Binary File Format (.xlsb)
UNKNOWN			Represents unrecognized format, cannot be loaded.
PDF			PDF (Adobe Portable Document) format.
XPS			XPS (XML Paper Specification) format.
TIFF			Represents a TIFF file.
SVG			SVG file.
EXCEL_95			Represents an Excel95 xls file.
EXCEL_4			Represents an Excel4.0 xls file. The file format is not supported
EXCEL_3			Represents an Excel3.0 xls file. The file format is not supported
EXCEL_2			Represents an Excel2.1 xls file. The file format is not supported
PPTX			Represents a pptx file. The file format is not supported Only for detecting file type.
DOCX			Represents a docx file. The file format is not supported Only for detecting file type.
DIF			Data Interchange Format.
DOC			Represents a doc file. The file format is not supported Only for detecting file type.
PPT			Represents a ppt file. The file format is not supported Only for detecting file type.
MAPI_MESSAGE			Represents a email file. The file format is not supported Only for detecting file type.
MS_EQUATION			Represents the MS Equation 3.0 object. The file format is not supported Only for detecting file type.
OLE_10_NATIVE			Represents the embedded native object. The file format is not supported Only for detecting file type.
VSD			Represents MS Visio VSD binary format. The file format is not supported Only for detecting file type.
VSDX			Represents MS Visio 2013 VSDX file format. The file format is not supported Only for detecting file type.
DOCM			Represents a docm file. The file format is not supported Only for detecting file type.
DOTX			Represents a dotx file. The file format is not supported Only for detecting file type.
DOTM			Represents a dotm file. The file format is not supported Only for detecting file type.
PPTM			Represents a pptm file. The file format is not supported Only for detecting file type.
POTX			Represents a Potx file. The file format is not supported Only for detecting file type.
POTM			Represents a Potm file. The file format is not supported Only for detecting file type.
PPSX			Represents a ppsx file. The file format is not supported Only for detecting file type.
PPSM			Represents a ppsm file. The file format is not supported Only for detecting file type.
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.
ODT			Represents an ODT file. The file format is not supported Only for detecting file type.
ODP			Represents a ODP file. The file format is not supported Only for detecting file type.
ODF			Represents an ODF file. The file format is not supported Only for detecting file type.
ODG			Represents an ODG file. The file format is not supported Only for detecting file type.
XML			Represents a simple xml file. The file format is not supported Only for detecting file type.
XLT			Excel97-2003 spreadsheet template.
OTT			Represents an OTT file. The file format is not supported Only for detecting file type.
BMP			Represents a BMP file. The file format is not supported Only for detecting file type.
OTS			Represents an ots file.
NUMBERS			Represents Numbers 9.0 file format by Apple Inc. NOTE: This member is now obsolete. Instead, please use NUMBERS_09 property. This property will be removed 6 months later since June 2023. Aspose apologizes for any inconvenience you may have experienced.
NUMBERS_09			Represents Numbers 9.0 file format by Apple Inc.
MARKDOWN			Represents markdown document.
GRAPH_CHART			Represents embedded graph chart.
FODS			Represents OpenDocument Flat XML Spreadsheet (.fods) file format.
SXC			Represents StarOffice Calc Spreadsheet (.sxc) file format.
OTP			Represents a OTP file. The file format is not supported. Only for detecting file type.
NUMBERS_35			Represents Numbers 3.5 file format since 2014 by Apple Inc
EMF			Windows Enhanced Metafile.
WMF			Windows Metafile.
JPG			JPEG JFIF.
PNG			Portable Network Graphics.
GIF			Gif
WEB_P			Webp
JSON			Json
SQL_SCRIPT			Sql
X_HTML			Rrepesents XHtml file.
ONE_NOTE			Rrepesents One Note file. The file format is not supported Only for detecting file type.
MICROSOFT_CABINET			/// Rrepesents Microsoft Cabinet file. The file format is not supported Only for detecting file type.
RTF
EPUB			EPUB
AZW_3			AZW3
OXPS			OXPS (Open XML Paper Specification) format.
G_ZIP			Rrepesents GZip file. The file format is not supported Only for detecting file type.

constant

FillPattern number

Utility class containing constants. Enumerates shape fill pattern types.

Properties

Name	Type	Optional	Description
NONE			Represents no background.
SOLID			Represents solid pattern.
GRAY_5			Represents 5% gray pattern.
GRAY_10			Represents 10% gray pattern.
GRAY_20			Represents 20% gray pattern.
GRAY_30			Represents 30% gray pattern.
GRAY_40			Represents 40% gray pattern.
GRAY_50			Represents 50% gray pattern.
GRAY_60			Represents 60% gray pattern.
GRAY_70			Represents 70% gray pattern.
GRAY_75			Represents 75% gray pattern.
GRAY_80			Represents 80% gray pattern.
GRAY_90			Represents 90% gray pattern.
GRAY_25			Represents 25% gray pattern.
LIGHT_DOWNWARD_DIAGONAL			Represents light downward diagonal pattern.
LIGHT_UPWARD_DIAGONAL			Represents light upward diagonal pattern.
DARK_DOWNWARD_DIAGONAL			Represents dark downward diagonal pattern.
DARK_UPWARD_DIAGONAL			Represents dark upward diagonal pattern.
WIDE_DOWNWARD_DIAGONAL			Represents wide downward diagonal pattern.
WIDE_UPWARD_DIAGONAL			Represents wide upward diagonal pattern.
LIGHT_VERTICAL			Represents light vertical pattern.
LIGHT_HORIZONTAL			Represents light horizontal pattern.
NARROW_VERTICAL			Represents narrow vertical pattern.
NARROW_HORIZONTAL			Represents narrow horizontal pattern.
DARK_VERTICAL			Represents dark vertical pattern.
DARK_HORIZONTAL			Represents dark horizontal pattern.
DASHED_DOWNWARD_DIAGONAL			Represents dashed downward diagonal pattern.
DASHED_UPWARD_DIAGONAL			Represents dashed upward diagonal pattern.
DASHED_VERTICAL			Represents dashed vertical pattern.
DASHED_HORIZONTAL			Represents dashed horizontal pattern.
SMALL_CONFETTI			Represents small confetti pattern.
LARGE_CONFETTI			Represents large confetti pattern.
ZIG_ZAG			Represents zig zag pattern.
WAVE			Represents wave pattern.
DIAGONAL_BRICK			Represents diagonal brick pattern.
HORIZONTAL_BRICK			Represents horizontal brick pattern.
WEAVE			Represents weave pattern.
PLAID			Represents plaid pattern.
DIVOT			Represents divot pattern.
DOTTED_GRID			Represents dotted grid pattern.
DOTTED_DIAMOND			Represents dotted diamond pattern.
SHINGLE			Represents shingle pattern.
TRELLIS			Represents trellis pattern.
SPHERE			Represents sphere pattern.
SMALL_GRID			Represents small grid pattern.
LARGE_GRID			Represents large grid pattern.
SMALL_CHECKER_BOARD			Represents small checker board pattern.
LARGE_CHECKER_BOARD			Represents large checker board pattern.
OUTLINED_DIAMOND			Represents outlined diamond pattern.
SOLID_DIAMOND			Represents solid diamond pattern.
UNKNOWN			Represents unknown pattern.

constant

FillPictureType number

Utility class containing constants. Represents the picture fill type.

Properties

Name	Type	Optional	Description
STRETCH			Stretch
STACK			Stack
STACK_AND_SCALE			StackAndScale

constant

FillType number

Utility class containing constants. Fill format type.

Properties

Name	Type	Optional	Description
AUTOMATIC			Represents automatic formatting type.
NONE			Represents none formatting type.
SOLID			Solid fill format.
GRADIENT			Gradient fill format.
TEXTURE			Texture fill format(includes picture fill).
PATTERN			Pattern fill format.
GROUP			Inherit the fill properties of the group.

constant

FilterOperatorType number

Utility class containing constants. Custom Filter operator type.

Properties

Name	Type	Optional	Description
LESS_OR_EQUAL			Represents LessOrEqual operator.
LESS_THAN			Represents LessThan operator.
EQUAL			Represents Equal operator.
GREATER_THAN			Represents GreaterThan operator.
NOT_EQUAL			Represents NotEqual operator.
GREATER_OR_EQUAL			Represents GreaterOrEqual operator.
NONE			Represents no comparison.
BEGINS_WITH			Begins with the text.
ENDS_WITH			Ends with the text.
CONTAINS			Contains the text.
NOT_CONTAINS			Not contains the text.

constant

FilterType number

Utility class containing constants. The filter type.

Properties

Name	Type	Optional	Description
COLOR_FILTER			Filter by fill color of the cell.
CUSTOM_FILTERS			Custom filter type.
DYNAMIC_FILTER			Dynamic filter type.
MULTIPLE_FILTERS			When multiple values are chosen to filter by, or when a group of date values are chosen to filter by, this element groups those criteria together.
ICON_FILTER			Filter by icon of conditional formatting.
TOP_10			Top 10 filter.
NONE			No filter.

constant

FontSchemeType number

Utility class containing constants. Represents the scheme type of the font.

Properties

Name	Type	Optional	Description
NONE			None
MAJOR			Major scheme.
MINOR			Minor scheme. The font's name will be automatically changed with the language.

constant

FontSourceType number

Utility class containing constants. Specifies the type of a font source.

Properties

Name	Type	Optional	Description
FONT_FILE			represents single font file.
FONTS_FOLDER			represents folder with font files.
MEMORY_FONT			represents single font in memory.

constant

FontUnderlineType number

Utility class containing constants. Enumerates the font underline types.

Properties

Name	Type	Optional	Description
NONE			Represents no underline.
SINGLE			Represents single underline.
DOUBLE			Represents double underline.
ACCOUNTING			Represents single accounting underline.
DOUBLE_ACCOUNTING			Represents double accounting underline.
DASH			Represents Dashed Underline
DASH_DOT_DOT_HEAVY			Represents Thick Dash-Dot-Dot Underline
DASH_DOT_HEAVY			Represents Thick Dash-Dot Underline
DASHED_HEAVY			Represents Thick Dashed Underline
DASH_LONG			Represents Long Dashed Underline
DASH_LONG_HEAVY			Represents Thick Long Dashed Underline
DOT_DASH			Represents Dash-Dot Underline
DOT_DOT_DASH			Represents Dash-Dot-Dot Underline
DOTTED			Represents Dotted Underline
DOTTED_HEAVY			Represents Thick Dotted Underline
HEAVY			Represents Thick Underline
WAVE			Represents Wave Underline
WAVY_DOUBLE			Represents Double Wave Underline
WAVY_HEAVY			Represents Heavy Wave Underline
WORDS			Represents Underline Non-Space Characters Only

constant

FormatConditionType number

Utility class containing constants. Conditional format rule type.

Properties

Name	Type	Optional	Description
CELL_VALUE			This conditional formatting rule compares a cell value to a formula calculated result, using an operator.
EXPRESSION			This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
TOP_10			This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
UNIQUE_VALUES			This conditional formatting rule highlights unique values in the range.
DUPLICATE_VALUES			This conditional formatting rule highlights duplicated values.
CONTAINS_TEXT			This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text.
NOT_CONTAINS_TEXT			This conditional formatting rule highlights cells that do not contain given text. Equivalent of using SEARCH() sheet function to determine whether the cell contains the text or not.
BEGINS_WITH			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.
ENDS_WITH			This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.
CONTAINS_BLANKS			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.
NOT_CONTAINS_BLANKS			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.
CONTAINS_ERRORS			This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
NOT_CONTAINS_ERRORS			This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
TIME_PERIOD			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.
ABOVE_AVERAGE			This conditional formatting rule highlights cells that are above or below the average for all values in the range.
COLOR_SCALE			This conditional formatting rule creates a gradated color scale on the cells.
DATA_BAR			This conditional formatting rule displays a gradated data bar in the range of cells.
ICON_SET			This conditional formatting rule applies icons to cells according to their values.

constant

FormatConditionValueType number

Utility class containing constants. Condition value type.

Properties

Name	Type	Optional	Description
FORMULA			The minimum/ midpoint / maximum value for the gradient is determined by a formula.
MAX			Indicates that the maximum value in the range shall be used as the maximum value for the gradient.
MIN			Indicates that the minimum value in the range shall be used as the minimum value for the gradient.
NUMBER			Indicates that the minimum / midpoint / maximum value for the gradient is specified by a constant numeric value.
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.
PERCENTILE			Value indicates a percentile ranking in the range shall be used as the minimum / midpoint / maximum value for the gradient.
AUTOMATIC_MAX			Indicates that the Automatic maximum value in the range shall be used as the Automatic maximum value for the gradient.
AUTOMATIC_MIN			Indicates that the Automatic minimum value in the range shall be used as the Automatic minimum value for the gradient.

constant

FormatSetType number

Utility class containing constants. Fill format set type.

Properties

Name	Type	Optional	Description
NONE			No Fill format.
IS_GRADIENT_SET			Gradient fill format.
IS_TEXTURE_SET			Texture fill format.
IS_PATTERN_SET			Pattern fill format.

constant

FormattingType number

Utility class containing constants. Represents the type of formatting applied to an Area object or a Line object.

Properties

Name	Type	Optional	Description
AUTOMATIC			Represents automatic formatting type.
CUSTOM			Represents custom formatting type.
NONE			Represents none formatting type.

constant

GradientColorType number

Utility class containing constants. Represents the gradient color type for the specified fill.

Properties

Name	Type	Optional	Description
NONE			No gradient color
ONE_COLOR			One gradient color
PRESET_COLORS			Preset gradient colors
TWO_COLORS			Two gradient colors

constant

GradientDirectionType number

Utility class containing constants. Represents all direction type of gradient.

Properties

Name	Type	Optional	Description
FROM_UPPER_LEFT_CORNER			FromUpperLeftCorner
FROM_UPPER_RIGHT_CORNER			FromUpperRightCorner
FROM_LOWER_LEFT_CORNER			FromLowerLeftCorner
FROM_LOWER_RIGHT_CORNER			FromLowerRightCorner
FROM_CENTER			FromCenter
UNKNOWN			Unknown

constant

GradientFillType number

Utility class containing constants. Represents all Gradient fill type.

Properties

Name	Type	Optional	Description
LINEAR			Linear
RADIAL			Radial
RECTANGLE			Rectangle
PATH			Path

constant

GradientPresetType number

Utility class containing constants. Represents gradient preset color type.

Properties

Name	Type	Optional	Description
BRASS			Brass preset color
CALM_WATER			Calm Water preset color
CHROME			Chrome preset color
CHROME_II			Chrome II preset color
DAYBREAK			Daybreak preset color
DESERT			Desert preset color
EARLY_SUNSET			Early Sunset preset color
FIRE			Fire preset color
FOG			Fog preset color
GOLD			Gold preset color
GOLD_II			Gold II preset color
HORIZON			Horizon preset color
LATE_SUNSET			Late Sunset preset color
MAHOGANY			Mahogany preset color
MOSS			Moss preset color
NIGHTFALL			Nightfall preset color
OCEAN			Ocean preset color
PARCHMENT			Parchment preset color
PEACOCK			Peacock preset color
RAINBOW			Rainbow preset color
RAINBOW_II			Rainbow II preset color
SAPPHIRE			Sapphire preset color
SILVER			Silver preset color
WHEAT			Wheat preset color
UNKNOWN			Unknown preset color. Only for the preset color (which is not same as any known preset color) in the template workbook.

constant

GradientStyleType number

Utility class containing constants. Represents gradient shading style.

Properties

Name	Type	Optional	Description
DIAGONAL_DOWN			Diagonal down shading style
DIAGONAL_UP			Diagonal up shading style
FROM_CENTER			From center shading style
FROM_CORNER			From corner shading style
HORIZONTAL			Horizontal shading style
VERTICAL			Vertical shading style
UNKNOWN			Unknown shading style.Only for the shading style(which is not for any member of the GradientStyleType) in the template file.

constant

GridlineType number

Utility class containing constants. Enumerates grid line Type.

Properties

Name	Type	Optional	Description
DOTTED			Represents dotted line.
HAIR			Represents hair line.

constant

HeaderFooterCommandType number

Utility class containing constants. Represents the command type of header and footer.

Properties

Name	Type	Optional	Description
TEXT			The text.
CURRENT_PAGE			Current page number
PAGECOUNT			Page count
CURRENT_DATE			Current date
CURRENT_TIME			Current time
SHEET_NAME			Sheet name
FILE_NAME			File name without path
FILE_PATH			File path without file name
PICTURE			Picture

constant

HtmlCrossType number

Utility class containing constants. Represents five types of html cross string.

Properties

Name	Type	Optional	Description
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
MS_EXPORT			Display the string like MS Excel exporting html.
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.
CROSS_HIDE_RIGHT			Display HTML cross string and hide the right string when the texts overlap.
FIT_TO_CELL			Only displaying the string within the width of cell.

constant

HtmlExportDataOptions number

Utility class containing constants. Represents the options for exporting html data.

Properties

Name	Type	Optional	Description
TABLE			Export file to html which only contains table part.
ALL			Export all the data to html.

constant

HtmlFormatHandlingType number

Utility class containing constants. Specifies how to handle formatting from the HTML source

Properties

Name	Type	Optional	Description
ALL			Transfer all HTML formatting into the worksheet along with data.
NONE			Bring data in as unformatted text (setting data types still occurs).
RTF			Translate HTML formatting to rich text formatting on the data brought into the worksheet.

constant

HtmlHiddenColDisplayType number

Utility class containing constants. Represents two types of showing the hidden columns in html.

Properties

Name	Type	Optional	Description
HIDDEN			Hidden the hidden columns in html page.
REMOVE			Remove the hidden columns in html page.

constant

HtmlHiddenRowDisplayType number

Utility class containing constants. Represents two types of showing the hidden rows in html.

Properties

Name	Type	Optional	Description
HIDDEN			Hidden the hidden rows in html page.
REMOVE			Remove the hidden rows in html page.

constant

HtmlLinkTargetType number

Utility class containing constants. Represents the type of target attribute in HTML tag.

Properties

Name	Type	Optional	Description
BLANK			Opens the linked document in a new window or tab
PARENT			Opens the linked document in the parent frame
SELF			Opens the linked document in the same frame as it was clicked (this is default)
TOP			Opens the linked document in the full body of the window

constant

IconSetType number

Utility class containing constants. 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.

Properties

Name	Type	Optional	Description
ARROWS_3			3 arrows icon set.
ARROWS_GRAY_3			3 gray arrows icon set.
FLAGS_3			3 flags icon set.
SIGNS_3			3 signs icon set.
SYMBOLS_3			3 symbols icon set (circled).
SYMBOLS_32			3 Symbols icon set (uncircled).
TRAFFIC_LIGHTS_31			3 traffic lights icon set (unrimmed).
TRAFFIC_LIGHTS_32			3 traffic lights icon set with thick black border.
ARROWS_4			4 arrows icon set.
ARROWS_GRAY_4			4 gray arrows icon set.
RATING_4			4 ratings icon set.
RED_TO_BLACK_4			4 'red to black' icon set.
TRAFFIC_LIGHTS_4			4 traffic lights icon set.
ARROWS_5			5 arrows icon set.
ARROWS_GRAY_5			5 gray arrows icon set.
QUARTERS_5			5 quarters icon set.
RATING_5			5 rating icon set.
STARS_3			3 stars set
BOXES_5			5 boxes set
TRIANGLES_3			3 triangles set
NONE			None
CUSTOM_SET			CustomSet. This element is read-only.
SMILIES_3			3 smilies. Only for .ods.
COLOR_SMILIES_3			3 color smilies. Only for .ods.

constant

ImageBinarizationMethod number

Utility class containing constants. Specifies the method used to binarize image.

Properties

Name	Type	Optional	Description
THRESHOLD			Specifies threshold method.
FLOYD_STEINBERG_DITHERING			Specifies dithering using Floyd-Steinberg error diffusion method.

constant

ImageType number

Utility class containing constants. Specifies the type (format) of an image.

Properties

Name	Type	Optional	Description
UNKNOWN			An unknown image type.
EMF			Windows Enhanced Metafile.
WMF			Windows Metafile.
PICT			Macintosh PICT.
JPEG			JPEG JFIF.
PNG			Portable Network Graphics.
BMP			Windows Bitmap
GIF			Gif
TIFF			Tiff
SVG			Svg
SVM			Svm
GLTF			glTF
OFFICE_COMPATIBLE_EMF			Windows Enhanced Metafile which is more compatible with Office.
WEB_P			Weppy image format

constant

InputMethodEditorMode number

Utility class containing constants. Represents the default run-time mode of the Input Method Editor.

Properties

Name	Type	Optional	Description
NO_CONTROL			Does not control IME.
ON			IME on.
OFF			IME off. English mode.
DISABLE			IME off.User can't turn on IME by keyboard.
HIRAGANA			IME on with Full-width hiragana mode.
KATAKANA			IME on with Full-width katakana mode.
KATAKANA_HALF			IME on with Half-width katakana mode.
ALPHA_FULL			IME on with Full-width Alphanumeric mode.
ALPHA			IME on with Half-width Alphanumeric mode.
HANGUL_FULL			IME on with Full-width hangul mode.
HANGUL			IME on with Half-width hangul mode.
HANZI_FULL			IME on with Full-width hanzi mode.
HANZI			IME on with Half-width hanzi mode.

constant

JsonExportHyperlinkType number

Utility class containing constants. Represents type of exporting hyperlinks to json.

Properties

Name	Type	Optional	Description
DISPLAY_STRING			Export display string
ADDRESS			Export url
HTML_STRING			Export as html string.

constant

LabelPositionType number

Utility class containing constants. Represents data label position type.

Properties

Name	Type	Optional	Description
CENTER			Applies only to bar, 2d/3d pie charts
INSIDE_BASE			Applies only to bar, 2d/3d pie charts
INSIDE_END			Applies only to bar charts
OUTSIDE_END			Applies only to bar, 2d/3d pie charts
ABOVE			Applies only to line charts
BELOW			Applies only to line charts
LEFT			Applies only to line charts
RIGHT			Applies only to line charts
BEST_FIT			Applies only to 2d/3d pie charts
MOVED			User moved the data labels, Only for reading chart from template file.

constant

LegendPositionType number

Utility class containing constants. Enumerates the legend position types.

Properties

Name	Type	Optional	Description
BOTTOM			Displays the legend to the bottom of the chart's plot area.
CORNER			Displays the legend to the corner of the chart's plot area.
LEFT			Displays the legend to the left of the chart's plot area.
NOT_DOCKED			Represents that the legend is not docked.
RIGHT			Displays the legend to the right of the chart's plot area.
TOP			Displays the legend to the top of the chart's plot area.

constant

LightRigDirectionType number

Utility class containing constants. Represents the light rig direction type.

Properties

Name	Type	Optional	Description
BOTTOM			Bottom
BOTTOM_LEFT			Bottom left.
BOTTOM_RIGHT			Bottom Right.
LEFT			Left.
RIGHT			Right.
TOP			Top.
TOP_LEFT			Top left.
TOP_RIGHT			Top Right.

constant

LightRigType number

Utility class containing constants. Represents a preset light right that can be applied to a shape

Properties

Name	Type	Optional	Description
BALANCED			Balanced
BRIGHT_ROOM			Bright room
CHILLY			Chilly
CONTRASTING			Contrasting
FLAT			Flat
FLOOD			Flood
FREEZING			Freezing
GLOW			Glow
HARSH			Harsh
LEGACY_FLAT_1			LegacyFlat1
LEGACY_FLAT_2			LegacyFlat2
LEGACY_FLAT_3			LegacyFlat3
LEGACY_FLAT_4			LegacyFlat4
LEGACY_HARSH_1			LegacyHarsh1
LEGACY_HARSH_2			LegacyHarsh2
LEGACY_HARSH_3			LegacyHarsh3
LEGACY_HARSH_4			LegacyHarsh4
LEGACY_NORMAL_1			LegacyNormal1
LEGACY_NORMAL_2			LegacyNormal2
LEGACY_NORMAL_3			LegacyNormal3
LEGACY_NORMAL_4			LegacyNormal4
MORNING			Morning
SOFT			Soft
SUNRISE			Sunrise
SUNSET			Sunset
THREE_POINT			Three point
TWO_POINT			Two point
NONE			No light rig.

constant

LineCapType number

Utility class containing constants. Represents the caps of a line

Properties

Name	Type	Optional	Description
SQUARE			Square protrudes by half line width.
ROUND			Rounded ends.
FLAT			Line ends at end point.
NONE			None cap

constant

LineJoinType number

Utility class containing constants. Represents the join styles of a line.

Properties

Name	Type	Optional	Description
ROUND			Round joint
BEVEL			Bevel joint
MITER			Miter joint
NONE			None joint

constant

LineSpaceSizeType number

Utility class containing constants. Represents the unit type of line space size.

Properties

Name	Type	Optional	Description
PERCENTAGE			Represents in unit of a percentage of the text size.
POINTS			Represents in unit of points.

constant

LineType number

Utility class containing constants. Enumerates the type of Picture border or Chart line.

Properties

Name	Type	Optional	Description
DARK_GRAY			Represents a dark gray line.
DASH			Represent a dash line.
DASH_DOT			Represents a dash-dot line
DASH_DOT_DOT			Represents a dash-dot-dot line.
DOT			Represents a dotted line.
LIGHT_GRAY			Represents a light gray line.
MEDIUM_GRAY			Represents a medium gray line.
SOLID			Represent a solid line.

constant

LoadDataFilterOptions number

Utility class containing constants. Represents the options to filter data when loading workbook from template.

Properties

Name	Type	Optional	Description
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.
ALL			Load all
CELL_BLANK			Load cells whose value is blank
CELL_STRING			Load cells whose value is string
CELL_NUMERIC			Load cells whose value is numeric(including datetime)
CELL_ERROR			Load cells whose value is error
CELL_BOOL			Load cells whose value is bool
CELL_VALUE			Load cells value(all value types) only
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.
CELL_DATA			Load cells data including values, formulas and formatting
CHART			Load charts
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.
DRAWING			Drawing objects(including Chart, Picture, OleObject and all other drawing objects)
MERGED_AREA			Load merged cells
CONDITIONAL_FORMATTING			Load conditional formatting
DATA_VALIDATION			Load data validations
PIVOT_TABLE			Load pivot tables
TABLE			Load tables
HYPERLINKS			Load hyperlinks
SHEET_SETTINGS			Load settings for worksheet
SHEET_DATA			Load all data of worksheet, such as cells data, settings, objects, ...etc.
BOOK_SETTINGS			Load settings for workbook
SETTINGS			Load settings for workbook and worksheet
XML_MAP			Load XmlMap
STRUCTURE			Load structure of the workbook
DOCUMENT_PROPERTIES			Load document properties
DEFINED_NAMES			Load defined Name objects
VBA			Load VBA projects
STYLE			Load styles for cell formatting
PICTURE			Load pictures
OLE_OBJECT			Load OleObjects
REVISION			Load revision logs

constant

LoadFormat number

Utility class containing constants. Represents the load file format.

Properties

Name	Type	Optional	Description
AUTO			Represents recognizing the format automatically.
CSV			Comma-Separated Values(CSV) text file.
XLSX			Represents Office Open XML spreadsheetML workbook or template, with or without macros.
TSV			Tab-Separated Values(TSV) text file.
TAB_DELIMITED			Represents a tab delimited text file, same with TSV.
HTML			Represents a html file.
M_HTML			Represents a mhtml file.
ODS			Open Document Sheet(ODS) file.
EXCEL_97_TO_2003			Represents an Excel97-2003 xls file.
SPREADSHEET_ML			Represents an Excel 2003 xml file.
XLSB			Represents an xlsb file.
OTS			Open Document Template Sheet(OTS) file.
NUMBERS			Represents a numbers file.
FODS			Represents OpenDocument Flat XML Spreadsheet (.fods) file format.
SXC			Represents StarOffice Calc Spreadsheet (.sxc) file format.
XML			Represents a simple xml file.
EPUB			Reprents an EPUB file.
AZW_3			Represents an AZW3 file.
UNKNOWN			Represents unrecognized format, cannot be loaded.
IMAGE			Image
JSON			Json

constant

LoadNumbersTableType number

Utility class containing constants. Indicates type of loading tables when some tables are in a sheet.

Properties

Name	Type	Optional	Description
ONE_TABLE_PER_SHEET
OVERRIDE_OTHER_TABLES
TILE_TABLES

constant

LookAtType number

Utility class containing constants. Represents look at type.

Properties

Name	Type	Optional	Description
CONTAINS			Cell value Contains the find object.
START_WITH			Cell value Starts with the find object.
END_WITH			Cell value ends with the find object.
ENTIRE_CONTENT			Cell value is same as the find object.

constant

LookInType number

Utility class containing constants. Represents look in type.

Properties

Name	Type	Optional	Description
FORMULAS			If the cell contains a formula, find object from formula, else find it from the value.
VALUES			Only find object from the formatted values.
VALUES_EXCLUDE_FORMULA_CELL			Only find object from the values of cells which do not contains formula.
COMMENTS			Only find object from the comments.
ONLY_FORMULAS			Only find object from formulas.
ORIGINAL_VALUES			Only find object from the original values.

constant

MapChartLabelLayout number

Utility class containing constants. Represents the layout of map chart's labels.

Properties

Name	Type	Optional	Description
BEST_FIT_ONLY			Only best fit.
SHOW_ALL			Shows all labels.
NONE			No labels.

constant

MapChartProjectionType number

Utility class containing constants. Represents projection type of the map chart.

Properties

Name	Type	Optional	Description
AUTOMATIC			Automatic
MERCATOR			Mercator
MILLER			Miller
ALBERS			Albers

constant

MapChartRegionType number

Utility class containing constants. Represents the region type of the map chart.

Properties

Name	Type	Optional	Description
AUTOMATIC			Automatic
DATA_ONLY			Only Data.
COUNTRY_REGION_LIST			Country region list.
WORLD			World.

constant

MemorySetting number

Utility class containing constants. Memory usage options.

Properties

Name	Type	Optional	Description
NORMAL			Default option for cells model. This option is applied for all versions.
MEMORY_PREFERENCE			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.

constant

MergeEmptyTdType number

Utility class containing constants. Represents the merge type for empty TD element when exporting file to html.

Properties

Name	Type	Optional	Description
DEFAULT			Display like MS Excel.
NONE			Empty TD elements will not be merged when exporting file to html. This will generate a significantly larger html file.
MERGE_FORCELY			Merging empty TD element forcedly when exporting file to html. The size of html file will be reduced significantly after setting value to true. If you want to import the html file to excel or export perfect grid lines when saving file to html, please keep the default value.

constant

MetadataType number

Utility class containing constants. Represents the type of metadata.

Properties

Name	Type	Optional	Description
ENCRYPTION			Encrypts the file.
DECRYPTION			Decrypts the file.
DOCUMENT_PROPERTIES			Load the properties of the file.

constant

MirrorType number

Utility class containing constants. Represents mirror type of texture fill

Properties

Name	Type	Optional	Description
NONE			None
HORIZONAL			Horizonal
VERTICAL			Vertical
BOTH			Both

constant

MsoArrowheadLength number

Utility class containing constants. Enumerates the line end width of the shape border line.

Properties

Name	Type	Optional	Description
SHORT			Short line end length
MEDIUM			Medium line end length
LONG			Long line end length

constant

MsoArrowheadStyle number

Utility class containing constants. Enumerates the line end type of the shape border line.

Properties

Name	Type	Optional	Description
NONE			No line end type.
ARROW			Arrow line end type.
ARROW_STEALTH			Arrow Stealth line end type.
ARROW_DIAMOND			Arrow Diamond Line end type.
ARROW_OVAL			Arrow Oval line end type.
ARROW_OPEN			Arrow Open line end type.

constant

MsoArrowheadWidth number

Utility class containing constants. Enumerates the line end width of the shape border line.

Properties

Name	Type	Optional	Description
NARROW			Short line end width.
MEDIUM			Medium line end width.
WIDE			Wide line end width.

constant

MsoDrawingType number

Utility class containing constants. Represents office drawing objects type.

Properties

Name	Type	Optional	Description
GROUP			Group
LINE			Line
RECTANGLE			Rectangle
OVAL			Oval
ARC			Arc
CHART			Chart
TEXT_BOX			TextBox
BUTTON			Button
PICTURE			Picture
POLYGON			Polygon
CHECK_BOX			CheckBox
RADIO_BUTTON			RadioButton
LABEL			Label
DIALOG_BOX			DialogBox
SPINNER			Spinner
SCROLL_BAR			ScrollBar
LIST_BOX			ListBox
GROUP_BOX			GroupBox
COMBO_BOX			ComboBox
COMMENT			Comment
OLE_OBJECT			OleObject
CELLS_DRAWING			Only for preserving the drawing object in the template file.
UNKNOWN			Only for preserving the drawing object in the xlsx file.
SLICER			Slicer
WEB_EXTENSION			Web extension
SMART_ART			Smart Art
CUSTOM_XML			Custom xml shape ,such as Ink.
TIMELINE			Timeline
MODEL_3_D			3D Model

constant

MsoLineDashStyle number

Utility class containing constants. Represents style of dash drawing lines.

Properties

Name	Type	Optional	Description
DASH			Represent a dash line.
DASH_DOT			Represents a dash-dot line.
DASH_DOT_DOT			Represents a dash-dot-dot line.
DASH_LONG_DASH			Represents a long dash-short dash line.
DASH_LONG_DASH_DOT			Represents a long dash-short dash-dot line.
ROUND_DOT			Represents a round-dot line.
SOLID			Represent a solid line.
SQUARE_DOT			Represents a square-dot line.
CUSTOM			Custom dash style.

constant

MsoLineStyle number

Utility class containing constants. Represents style of drawing lines.

Properties

Name	Type	Optional	Description
SINGLE			Single line (of width lineWidth)
THICK_BETWEEN_THIN			Three lines, thin, thick, thin
THIN_THICK			Double lines, one thin, one thick
THICK_THIN			Double lines, one thick, one thin
THIN_THIN			Double lines of equal width

constant

MsoPresetTextEffect number

Utility class containing constants. Represents preset text effect type of WordArt.

Properties

Name	Type	Optional	Description
TEXT_EFFECT_1			TextEffect1
TEXT_EFFECT_2			TextEffect2
TEXT_EFFECT_3			TextEffect3
TEXT_EFFECT_4			TextEffect4
TEXT_EFFECT_5			TextEffect5
TEXT_EFFECT_6			TextEffect6
TEXT_EFFECT_7			TextEffect7
TEXT_EFFECT_8			TextEffect8
TEXT_EFFECT_9			TextEffect9
TEXT_EFFECT_10			TextEffect10
TEXT_EFFECT_11			TextEffect11
TEXT_EFFECT_12			TextEffect12
TEXT_EFFECT_13			TextEffect13
TEXT_EFFECT_14			TextEffect14
TEXT_EFFECT_15			TextEffect15
TEXT_EFFECT_16			TextEffect16
TEXT_EFFECT_17			TextEffect17
TEXT_EFFECT_18			TextEffect18
TEXT_EFFECT_19			TextEffect19
TEXT_EFFECT_20			TextEffect20
TEXT_EFFECT_21			TextEffect21
TEXT_EFFECT_22			TextEffect22
TEXT_EFFECT_23			TextEffect23
TEXT_EFFECT_24			TextEffect24
TEXT_EFFECT_25			TextEffect25
TEXT_EFFECT_26			TextEffect26
TEXT_EFFECT_27			TextEffect27
TEXT_EFFECT_28			TextEffect28
TEXT_EFFECT_29			TextEffect29
TEXT_EFFECT_30			TextEffect30

constant

MsoPresetTextEffectShape number

Utility class containing constants. Represents preset text effect shape type of WordArt.

Properties

Name	Type	Optional	Description
PLAIN_TEXT			PlainText
STOP			Stop
TRIANGLE_UP			TriangleUp
TRIANGLE_DOWN			TriangleDown
CHEVRON_UP			ChevronUp
CHEVRON_DOWN			ChevronDown
RING_INSIDE			RingInside
RING_OUTSIDE			RingOutside
ARCH_UP_CURVE			ArchUpCurve
ARCH_DOWN_CURVE			ArchDownCurve
CIRCLE_CURVE			CircleCurve
BUTTON_CURVE			ButtonCurve
ARCH_UP_POUR			ArchUpPour
ARCH_DOWN_POUR			ArchDownPour
CIRCLE_POUR			CirclePour
BUTTON_POUR			ButtonPour
CURVE_UP			CurveUp
CURVE_DOWN			CurveDown
CAN_UP			CanUp
CAN_DOWN			CanDown
WAVE_1			Wave1
WAVE_2			Wave2
DOUBLE_WAVE_1			DoubleWave1
DOUBLE_WAVE_2			DoubleWave2
INFLATE			Inflate
DEFLATE			Deflate
INFLATE_BOTTOM			InflateBottom
DEFLATE_BOTTOM			DeflateBottom
INFLATE_TOP			InflateTop
DEFLATE_TOP			DeflateTop
DEFLATE_INFLATE			DeflateInflate
DEFLATE_INFLATE_DEFLATE			DeflateInflateDeflate
FADE_RIGHT			FadeRight
FADE_LEFT			FadeLeft
FADE_UP			FadeUp
FADE_DOWN			FadeDown
SLANT_UP			SlantUp
SLANT_DOWN			SlantDown
CASCADE_UP			CascadeUp
CASCADE_DOWN			CascadeDown
MIXED			Mixed

constant

NameScopeType number

Utility class containing constants. Represents the scope type of defined names.

Properties

Name	Type	Optional	Description
ALL			All defined names.
WORKBOOK			The defined names in the workbook.
WORKSHEET			The defined names in a worksheet or all worksheets.

constant

NumberCategoryType number

Utility class containing constants. Represents category type of cell's number formatting.

Properties

Name	Type	Optional	Description
GENERAL			General
TEXT			Text
NUMBER			Number
DATE			Date or Date and Time
TIME			Time
FRACTION			Fraction
SCIENTIFIC			Scientific

constant

OLEDBCommandType number

Utility class containing constants. Specifies the OLE DB command type.

Properties

Name	Type	Optional	Description
NONE			The command type is not specified.
CUBE_NAME			Specifies a cube name unsupported
SQL_STATEMENT			Specifies a SQL statement
TABLE_NAME			Specifies a table name
DEFAULT_INFORMATION			Specifies that default information has been given, and it is up to the provider how to interpret. unsupported
WEB_BASED_LIST			Specifies a query which is against a web based List Data Provider. unsupported

constant

OdsCellFieldType number

Utility class containing constants. Represents the cell field type of ods.

Properties

Name	Type	Optional	Description
DATE			Current date.
SHEET_NAME			The name of the sheet.
TITLE			The name of the file.

constant

OdsGeneratorType number

Utility class containing constants. Represents the type of ODS generator.

Properties

Name	Type	Optional	Description
LIBRE_OFFICE			Libre Office
OPEN_OFFICE			Open Office

constant

OdsPageBackgroundGraphicPositionType number

Utility class containing constants. Represents the position.

Properties

Name	Type	Optional	Description
TOP_LEFT			Top left.
TOP_CENTER			Top center.
TOP_RIGHT			Top right.
CENTER_LEFT			Center left.
CENTER_CENTER			Center.
CENTER_RIGHT			Center right.
BOTTOM_LEFT			Bottom left.
BOTTOM_CENTER			Bottom center.
BOTTOM_RIGHT			Bottom right.

constant

OdsPageBackgroundGraphicType number

Utility class containing constants. Represents the type of formatting page background with image.

Properties

Name	Type	Optional	Description
POSITION			Set the image at specific position.
AREA			Stretch the image.
TILE			Repeat and repeat the image.

constant

OdsPageBackgroundType number

Utility class containing constants. Represents the page background type of ods.

Properties

Name	Type	Optional	Description
NONE			No background.
COLOR			Formats the background with color.
GRAPHIC			Formats the background with image.

constant

OoxmlCompliance number

Utility class containing constants. Allows to specify which OOXML specification will be used when saving in the Xlsx format.

Properties

Name	Type	Optional	Description
ECMA_376_2006			ECMA-376 1st Edition, 2006.
ISO_29500_2008_STRICT			ISO/IEC 29500:2008 Strict compliance level.

constant

OoxmlCompressionType number

Utility class containing constants. The Ooxml compression type

Properties

Name	Type	Optional	Description
LEVEL_1			The fastest but least effective compression.
LEVEL_2			A little slower, but better, than level 1.
LEVEL_3			A little slower, but better, than level 2.
LEVEL_4			A little slower, but better, than level 3.
LEVEL_5			A little slower than level 4, but with better compression.
LEVEL_6			A good balance of speed and compression efficiency.
LEVEL_7			Pretty good compression!
LEVEL_8			Better compression than Level7!
LEVEL_9			The "best" compression, where best means greatest reduction in size of the input data stream. This is also the slowest compression.

constant

OpenDocumentFormatVersionType number

Utility class containing constants. Open Document Format version type.

Properties

Name	Type	Optional	Description
NONE			None strict. There are some difference between Excel and ODF. In order to keep the data of Excel file, we can not follow the strict of ODF.
ODF_11			ODF Version 1.1
ODF_12			ODF Version 1.2
ODF_13			ODF Version 1.3

constant

OperatorType number

Utility class containing constants. Represents the operator type of conditional format and data validation.

Properties

Name	Type	Optional	Description
BETWEEN			Represents Between operator of conditional format and data validation.
EQUAL			Represents Equal operator of conditional format and data validation.
GREATER_THAN			Represents GreaterThan operator of conditional format and data validation.
GREATER_OR_EQUAL			Represents GreaterOrEqual operator of conditional format and data validation.
LESS_THAN			Represents LessThan operator of conditional format and data validation.
LESS_OR_EQUAL			Represents LessOrEqual operator of conditional format and data validation.
NONE			Represents no comparison.
NOT_BETWEEN			Represents NotBetween operator of conditional format and data validation.
NOT_EQUAL			Represents NotEqual operator of conditional format and data validation.

constant

PageLayoutAlignmentType number

Utility class containing constants. Enumerates page layout alignment types.

Properties

Name	Type	Optional	Description
BOTTOM			Represents bottom page layout alignment.
CENTER			Represents center page layout alignment.
LEFT			Represents left page layout alignment.
RIGHT			Represents right page layout alignment.
TOP			Represents top page layout alignment.

constant

PageOrientationType number

Utility class containing constants. Represents print orientation constants.

Properties

Name	Type	Optional	Description
LANDSCAPE			Landscape orientation
PORTRAIT			Portrait orientation

constant

PaneStateType number

Utility class containing constants. Represents state of the sheet's pane.

Properties

Name	Type	Optional	Description
FROZEN			Panes are frozen, but were not before being frozen.
FROZEN_SPLIT			Panes are frozen and were split before being frozen.
SPLIT			Panes are split, but not frozen.
NORMAL			Panes are not frozen and not split.

constant

PaperSizeType number

Utility class containing constants. Represents paper size constants.

Properties

Name	Type	Optional	Description
PAPER_LETTER			Letter (8-1/2 in. x 11 in.)
PAPER_LETTER_SMALL			Letter Small (8-1/2 in. x 11 in.)
PAPER_TABLOID			Tabloid (11 in. x 17 in.)
PAPER_LEDGER			Ledger (17 in. x 11 in.)
PAPER_LEGAL			Legal (8-1/2 in. x 14 in.)
PAPER_STATEMENT			Statement (5-1/2 in. x 8-1/2 in.)
PAPER_EXECUTIVE			Executive (7-1/4 in. x 10-1/2 in.)
PAPER_A_3			A3 (297 mm x 420 mm)
PAPER_A_4			A4 (210 mm x 297 mm)
PAPER_A_4_SMALL			A4 Small (210 mm x 297 mm)
PAPER_A_5			A5 (148 mm x 210 mm)
PAPER_B_4			JIS B4 (257 mm x 364 mm)
PAPER_B_5			JIS B5 (182 mm x 257 mm)
PAPER_FOLIO			Folio (8-1/2 in. x 13 in.)
PAPER_QUARTO			Quarto (215 mm x 275 mm)
PAPER_10_X_14			10 in. x 14 in.
PAPER_11_X_17			11 in. x 17 in.
PAPER_NOTE			Note (8-1/2 in. x 11 in.)
PAPER_ENVELOPE_9			Envelope #9 (3-7/8 in. x 8-7/8 in.)
PAPER_ENVELOPE_10			Envelope #10 (4-1/8 in. x 9-1/2 in.)
PAPER_ENVELOPE_11			Envelope #11 (4-1/2 in. x 10-3/8 in.)
PAPER_ENVELOPE_12			Envelope #12 (4-1/2 in. x 11 in.)
PAPER_ENVELOPE_14			Envelope #14 (5 in. x 11-1/2 in.)
PAPER_C_SHEET			C size sheet
PAPER_D_SHEET			D size sheet
PAPER_E_SHEET			E size sheet
PAPER_ENVELOPE_DL			Envelope DL (110 mm x 220 mm)
PAPER_ENVELOPE_C_5			Envelope C5 (162 mm x 229 mm)
PAPER_ENVELOPE_C_3			Envelope C3 (324 mm x 458 mm)
PAPER_ENVELOPE_C_4			Envelope C4 (229 mm x 324 mm)
PAPER_ENVELOPE_C_6			Envelope C6 (114 mm x 162 mm)
PAPER_ENVELOPE_C_65			Envelope C65 (114 mm x 229 mm)
PAPER_ENVELOPE_B_4			Envelope B4 (250 mm x 353 mm)
PAPER_ENVELOPE_B_5			Envelope B5 (176 mm x 250 mm)
PAPER_ENVELOPE_B_6			Envelope B6 (176 mm x 125 mm)
PAPER_ENVELOPE_ITALY			Envelope Italy (110 mm x 230 mm)
PAPER_ENVELOPE_MONARCH			Envelope Monarch (3-7/8 in. x 7-1/2 in.)
PAPER_ENVELOPE_PERSONAL			Envelope (3-5/8 in. x 6-1/2 in.)
PAPER_FANFOLD_US			U.S. Standard Fanfold (14-7/8 in. x 11 in.)
PAPER_FANFOLD_STD_GERMAN			German Standard Fanfold (8-1/2 in. x 12 in.)
PAPER_FANFOLD_LEGAL_GERMAN			German Legal Fanfold (8-1/2 in. x 13 in.)
PAPER_ISOB_4			B4 (ISO) 250 x 353 mm
PAPER_JAPANESE_POSTCARD			Japanese Postcard (100mm × 148mm)
PAPER_9_X_11			9? × 11?
PAPER_10_X_11			10? × 11?
PAPER_15_X_11			15? × 11?
PAPER_ENVELOPE_INVITE			Envelope Invite(220mm × 220mm)
PAPER_LETTER_EXTRA			US Letter Extra 9 \275 x 12 in
PAPER_LEGAL_EXTRA			US Legal Extra 9 \275 x 15 in
PAPER_TABLOID_EXTRA			US Tabloid Extra 11.69 x 18 in
PAPER_A_4_EXTRA			A4 Extra 9.27 x 12.69 in
PAPER_LETTER_TRANSVERSE			Letter Transverse 8 \275 x 11 in
PAPER_A_4_TRANSVERSE			A4 Transverse 210 x 297 mm
PAPER_LETTER_EXTRA_TRANSVERSE			Letter Extra Transverse 9\275 x 12 in
PAPER_SUPER_A			SuperA/SuperA/A4 227 x 356 mm
PAPER_SUPER_B			SuperB/SuperB/A3 305 x 487 mm
PAPER_LETTER_PLUS			US Letter Plus 8.5 x 12.69 in
PAPER_A_4_PLUS			A4 Plus 210 x 330 mm
PAPER_A_5_TRANSVERSE			A5 Transverse 148 x 210 mm
PAPER_JISB_5_TRANSVERSE			B5 (JIS) Transverse 182 x 257 mm
PAPER_A_3_EXTRA			A3 Extra 322 x 445 mm
PAPER_A_5_EXTRA			A5 Extra 174 x 235 mm
PAPER_ISOB_5_EXTRA			B5 (ISO) Extra 201 x 276 mm
PAPER_A_2			A2 420 x 594 mm
PAPER_A_3_TRANSVERSE			A3 Transverse 297 x 420 mm
PAPER_A_3_EXTRA_TRANSVERSE			A3 Extra Transverse 322 x 445 mm
PAPER_JAPANESE_DOUBLE_POSTCARD			Japanese Double Postcard 200 x 148 mm
PAPER_A_6			A6 105 x 148 mm
PAPER_JAPANESE_ENVELOPE_KAKU_2			Japanese Envelope Kaku #2
PAPER_JAPANESE_ENVELOPE_KAKU_3			Japanese Envelope Kaku #3
PAPER_JAPANESE_ENVELOPE_CHOU_3			Japanese Envelope Chou #3
PAPER_JAPANESE_ENVELOPE_CHOU_4			Japanese Envelope Chou #4
PAPER_LETTER_ROTATED			11in × 8.5in
PAPER_A_3_ROTATED			420mm × 297mm
PAPER_A_4_ROTATED			297mm × 210mm
PAPER_A_5_ROTATED			210mm × 148mm
PAPER_JISB_4_ROTATED			B4 (JIS) Rotated 364 x 257 mm
PAPER_JISB_5_ROTATED			B5 (JIS) Rotated 257 x 182 mm
PAPER_JAPANESE_POSTCARD_ROTATED			Japanese Postcard Rotated 148 x 100 mm
PAPER_JAPANESE_DOUBLE_POSTCARD_ROTATED			Double Japanese Postcard Rotated 148 x 200 mm
PAPER_A_6_ROTATED			A6 Rotated 148 x 105 mm
PAPER_JAPANESE_ENVELOPE_KAKU_2_ROTATED			Japanese Envelope Kaku #2 Rotated
PAPER_JAPANESE_ENVELOPE_KAKU_3_ROTATED			Japanese Envelope Kaku #3 Rotated
PAPER_JAPANESE_ENVELOPE_CHOU_3_ROTATED			Japanese Envelope Chou #3 Rotated
PAPER_JAPANESE_ENVELOPE_CHOU_4_ROTATED			Japanese Envelope Chou #4 Rotated
PAPER_JISB_6			B6 (JIS) 128 x 182 mm
PAPER_JISB_6_ROTATED			B6 (JIS) Rotated 182 x 128 mm
PAPER_12_X_11			12 x 11 in
PAPER_JAPANESE_ENVELOPE_YOU_4			Japanese Envelope You #4
PAPER_JAPANESE_ENVELOPE_YOU_4_ROTATED			Japanese Envelope You #4 Rotated
PAPER_PRC_16_K			PRC 16K 146 x 215 mm
PAPER_PRC_32_K			PRC 32K 97 x 151 mm
PAPER_PRC_BIG_32_K			PRC 32K(Big) 97 x 151 mm
PAPER_PRC_ENVELOPE_1			PRC Envelope #1 102 x 165 mm
PAPER_PRC_ENVELOPE_2			PRC Envelope #2 102 x 176 mm
PAPER_PRC_ENVELOPE_3			PRC Envelope #3 125 x 176 mm
PAPER_PRC_ENVELOPE_4			PRC Envelope #4 110 x 208 mm
PAPER_PRC_ENVELOPE_5			PRC Envelope #5 110 x 220 mm
PAPER_PRC_ENVELOPE_6			PRC Envelope #6 120 x 230 mm
PAPER_PRC_ENVELOPE_7			PRC Envelope #7 160 x 230 mm
PAPER_PRC_ENVELOPE_8			PRC Envelope #8 120 x 309 mm
PAPER_PRC_ENVELOPE_9			PRC Envelope #9 229 x 324 mm
PAPER_PRC_ENVELOPE_10			PRC Envelope #10 324 x 458 mm
PAPER_PRC_16_K_ROTATED			PRC 16K Rotated
PAPER_PRC_32_K_ROTATED			PRC 32K Rotated
PAPER_PRC_BIG_32_K_ROTATED			PRC 32K(Big) Rotated
PAPER_PRC_ENVELOPE_1_ROTATED			PRC Envelope #1 Rotated 165 x 102 mm
PAPER_PRC_ENVELOPE_2_ROTATED			PRC Envelope #2 Rotated 176 x 102 mm
PAPER_PRC_ENVELOPE_3_ROTATED			PRC Envelope #3 Rotated 176 x 125 mm
PAPER_PRC_ENVELOPE_4_ROTATED			PRC Envelope #4 Rotated 208 x 110 mm
PAPER_PRC_ENVELOPE_5_ROTATED			PRC Envelope #5 Rotated 220 x 110 mm
PAPER_PRC_ENVELOPE_6_ROTATED			PRC Envelope #6 Rotated 230 x 120 mm
PAPER_PRC_ENVELOPE_7_ROTATED			PRC Envelope #7 Rotated 230 x 160 mm
PAPER_PRC_ENVELOPE_8_ROTATED			PRC Envelope #8 Rotated 309 x 120 mm
PAPER_PRC_ENVELOPE_9_ROTATED			PRC Envelope #9 Rotated 324 x 229 mm
PAPER_PRC_ENVELOPE_10_ROTATED			PRC Envelope #10 Rotated 458 x 324 mm
PAPER_B_3			usual B3(13.9 x 19.7 in)
PAPER_BUSINESS_CARD			Business Card(90mm x 55 mm)
PAPER_THERMAL			Thermal(3 x 11 in)
CUSTOM			Represents the custom paper size.

constant

ParameterType number

Utility class containing constants. Represents all parameters' type or return value type of function.

Properties

Name	Type	Optional	Description
REFERENCE
VALUE
ARRAY

constant

PasteOperationType number

Utility class containing constants. Represents operation type when pasting range.

Properties

Name	Type	Optional	Description
NONE			No operation.
ADD			Add
SUBTRACT			Subtract
MULTIPLY			Multiply
DIVIDE			Divide

constant

PasteType number

Utility class containing constants. Represents the paste special type.

Properties

Name	Type	Optional	Description
ALL			Copies all data of the range.
DEFAULT			It works as "All" behavior of MS Excel.
ALL_EXCEPT_BORDERS			Copies all data of the range without the range.
DEFAULT_EXCEPT_BORDERS			It works as "All except borders" behavior of MS Excel.
COLUMN_WIDTHS			Only copies the widths of the range.
ROW_HEIGHTS			Only copies the heights of the range.
COMMENTS
FORMATS
FORMULAS
FORMULAS_AND_NUMBER_FORMATS
VALIDATION
VALUES
VALUES_AND_FORMATS
VALUES_AND_NUMBER_FORMATS

constant

PdfCompliance number

Utility class containing constants. Allowing user to set PDF conversion's Compatibility

Properties

Name	Type	Optional	Description
NONE			Pdf format compatible with PDF 1.4 NOTE: This member is now obsolete. Instead, please use PDF_14 property. This property will be removed 6 months later since November 2023. Aspose apologizes for any inconvenience you may have experienced.
PDF_14			Pdf format compatible with PDF 1.4
PDF_15			Pdf format compatible with PDF 1.5
PDF_16			Pdf format compatible with PDF 1.6
PDF_17			Pdf format compatible with PDF 1.7
PDF_A_1_B			Pdf format compatible with PDF/A-1b(ISO 19005-1)
PDF_A_1_A			Pdf format compatible with PDF/A-1a(ISO 19005-1)
PDF_A_2_B			Pdf format compatible with PDF/A-2b(ISO 19005-2)
PDF_A_2_U			Pdf format compatible with PDF/A-2u(ISO 19005-2)
PDF_A_2_A			Pdf format compatible with PDF/A-2a(ISO 19005-2)
PDF_A_3_B			Pdf format compatible with PDF/A-3b(ISO 19005-3)
PDF_A_3_U			Pdf format compatible with PDF/A-3u(ISO 19005-3)
PDF_A_3_A			Pdf format compatible with PDF/A-3a(ISO 19005-3)

constant

PdfCompressionCore number

Utility class containing constants. Specifies a type of compression applied to all content in the PDF file except images.

Properties

Name	Type	Optional	Description
NONE			None
RLE			Rle
LZW			Lzw
FLATE			Flate

constant

PdfCustomPropertiesExport number

Utility class containing constants. Specifies the way CustomDocumentPropertyCollection are exported to PDF file.

Properties

Name	Type	Optional	Description
NONE			No custom properties are exported.
STANDARD			Custom properties are exported as entries in Info dictionary. Custom properties with the following names are not exported: "Title", "Author", "Subject", "Keywords", "Creator", "Producer", "CreationDate", "ModDate", "Trapped".

constant

PdfFontEncoding number

Utility class containing constants. Represents pdf embedded font encoding.

Properties

Name	Type	Optional	Description
IDENTITY			Represents use Identity-H encoding for all embedded fonts in pdf.
ANSI_PREFER			Represents prefer to use WinAnsiEncoding for TrueType fonts with characters 32-127, otherwise, Identity-H encoding will be used for embedded fonts in pdf.

constant

PdfOptimizationType number

Utility class containing constants. Specifies a type of optimization.

Properties

Name	Type	Optional	Description
STANDARD			High print quality
MINIMUM_SIZE			File size is more important than print quality Font Arial and Times New Roman with characters 32-127 will not be embedded in pdf. Border lines are optimized for smaller file size.

constant

PivotAreaType number

Utility class containing constants. Indicates the type of rule being used to describe an area or aspect of the PivotTable.

Properties

Name	Type	Optional	Description
NONE			No Pivot area.
NORMAL			Represents a header or item.
DATA			Represents something in the data area.
ALL			Represents the whole PivotTable.
ORIGIN			Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets).
BUTTON			Represents a field button.
TOP_RIGHT			Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets).

constant

PivotConditionFormatRuleType number

Utility class containing constants. Represents PivotTable condition formatting rule type.

Properties

Name	Type	Optional	Description
NONE			Indicates that Top N conditional formatting is not evaluated
ALL			Indicates that Top N conditional formatting is evaluated across the entire scope range.
ROW			Indicates that Top N conditional formatting is evaluated for each row.
COLUMN			Indicates that Top N conditional formatting is evaluated for each column.

constant

PivotConditionFormatScopeType number

Utility class containing constants. Represents PivotTable condition formatting scope type.

Properties

Name	Type	Optional	Description
DATA			Indicates that conditional formatting is applied to the selected data fields.
FIELD			Indicates that conditional formatting is applied to the selected PivotTable field intersections.
SELECTION			Indicates that conditional formatting is applied to the selected cells.

constant

PivotFieldDataDisplayFormat number

Utility class containing constants. Represents data display format in the PivotTable data field.

Properties

Name	Type	Optional	Description
NORMAL			Represents normal display format.
DIFFERENCE_FROM			Represents difference from display format.
PERCENTAGE_OF			Represents percentage of display format.
PERCENTAGE_DIFFERENCE_FROM			Represents percentage difference from display format.
RUNNING_TOTAL_IN			Represents running total in display format.
PERCENTAGE_OF_ROW			Represents percentage of row display format.
PERCENTAGE_OF_COLUMN			Represents percentage of column display format.
PERCENTAGE_OF_TOTAL			Represents percentage of total display format.
INDEX			Represents index display format.
PERCENTAGE_OF_PARENT_ROW_TOTAL			Represents percentage of parent row total display format.
PERCENTAGE_OF_PARENT_COLUMN_TOTAL			Represents percentage of parent column total display format.
PERCENTAGE_OF_PARENT_TOTAL			Represents percentage of parent total display format.
PERCENTAGE_OF_RUNNING_TOTAL_IN			Represents percentage of running total in display format.
RANK_SMALLEST_TO_LARGEST			Represents smallest to largest display format.
RANK_LARGEST_TO_SMALLEST			Represents largest to smallest display format.

constant

PivotFieldGroupType number

Utility class containing constants. Represents the group type of pivot field.

Properties

Name	Type	Optional	Description
NONE			No group
DATE_TIME_RANGE			Grouped by DateTime range.
NUMBERIC_RANGE			Grouped by numberic range.
DISCRETE			Grouped by discrete points.

constant

PivotFieldSubtotalType number

Utility class containing constants. Summary description for PivotFieldSubtotalType.

Properties

Name	Type	Optional	Description
NONE			Represents None subtotal type.
AUTOMATIC			Represents Automatic subtotal type.
SUM			Represents Sum subtotal type.
COUNT			Represents Count subtotal type.
AVERAGE			Represents Average subtotal type.
MAX			Represents Max subtotal type.
MIN			Represents Min subtotal type.
PRODUCT			Represents Product subtotal type.
COUNT_NUMS			Represents Count Nums subtotal type.
STDEV			Represents Stdev subtotal type.
STDEVP			Represents Stdevp subtotal type.
VAR			Represents Var subtotal type.
VARP			Represents Varp subtotal type.

constant

PivotFieldType number

Utility class containing constants. Represents PivotTable field type.

Properties

Name	Type	Optional	Description
UNDEFINED			Presents base pivot field type.
ROW			Presents row pivot field type.
COLUMN			Presents column pivot field type.
PAGE			Presents page pivot field type.
DATA			Presents data pivot field type.

constant

PivotFilterType number

Utility class containing constants. Represents PivotTable Filter type.

Properties

Name	Type	Optional	Description
CAPTION_BEGINS_WITH			Indicates the "begins with" filter for field captions.
CAPTION_BETWEEN			Indicates the "is between" filter for field captions.
CAPTION_CONTAINS			Indicates the "contains" filter for field captions.
CAPTION_ENDS_WITH			Indicates the "ends with" filter for field captions.
CAPTION_EQUAL			Indicates the "equal" filter for field captions.
CAPTION_GREATER_THAN			Indicates the "is greater than" filter for field captions.
CAPTION_GREATER_THAN_OR_EQUAL			Indicates the "is greater than or equal to" filter for field captions.
CAPTION_LESS_THAN			Indicates the "is less than" filter for field captions.
CAPTION_LESS_THAN_OR_EQUAL			Indicates the "is less than or equal to" filter for field captions.
CAPTION_NOT_BEGINS_WITH			Indicates the "does not begin with" filter for field captions.
CAPTION_NOT_BETWEEN			Indicates the "is not between" filter for field captions.
CAPTION_NOT_CONTAINS			Indicates the "does not contain" filter for field captions.
CAPTION_NOT_ENDS_WITH			Indicates the "does not end with" filter for field captions.
CAPTION_NOT_EQUAL			Indicates the "not equal" filter for field captions.
COUNT			Indicates the "count" filter.
DATE_BETWEEN			Indicates the "between" filter for date values.
DATE_EQUAL			Indicates the "equals" filter for date values.
DATE_NEWER_THAN			Indicates the "newer than" filter for date values.
DATE_NEWER_THAN_OR_EQUAL			Indicates the "newer than or equal to" filter for date values.
DATE_NOT_BETWEEN			Indicates the "not between" filter for date values.
DATE_NOT_EQUAL			Indicates the "does not equal" filter for date values.
DATE_OLDER_THAN			Indicates the "older than" filter for date values.
DATE_OLDER_THAN_OR_EQUAL			Indicates the "older than or equal to" filter for date values.
LAST_MONTH			Indicates the "last month" filter for date values.
LAST_QUARTER			Indicates the "last quarter" filter for date values.
LAST_WEEK			Indicates the "last week" filter for date values.
LAST_YEAR			Indicates the "last year" filter for date values.
M_1			Indicates the "January" filter for date values.
M_2			Indicates the "February" filter for date values.
M_3			Indicates the "March" filter for date values.
M_4			Indicates the "April" filter for date values.
M_5			Indicates the "May" filter for date values.
M_6			Indicates the "June" filter for date values.
M_7			Indicates the "July" filter for date values.
M_8			Indicates the "August" filter for date values.
M_9			Indicates the "September" filter for date values.
M_10			Indicates the "October" filter for date values.
M_11			Indicates the "November" filter for date values.
M_12			Indicates the "December" filter for date values.
NEXT_MONTH			Indicates the "next month" filter for date values.
NEXT_QUARTER			Indicates the "next quarter" for date values.
NEXT_WEEK			Indicates the "next week" for date values.
NEXT_YEAR			Indicates the "next year" filter for date values.
PERCENT			Indicates the "percent" filter for numeric values.
Q_1			Indicates the "first quarter" filter for date values.
Q_2			Indicates the "second quarter" filter for date values.
Q_3			Indicates the "third quarter" filter for date values.
Q_4			Indicates the "fourth quarter" filter for date values.
SUM			Indicates the "sum" filter for numeric values.
THIS_MONTH			Indicates the "this month" filter for date values.
THIS_QUARTER			Indicates the "this quarter" filter for date values.
THIS_WEEK			Indicates the "this week" filter for date values.
THIS_YEAR			Indicate the "this year" filter for date values.
TODAY			Indicates the "today" filter for date values.
TOMORROW			Indicates the "tomorrow" filter for date values.
UNKNOWN			Indicates the PivotTable filter is unknown to the application.
VALUE_BETWEEN			Indicates the "Value between" filter for text and numeric values.
VALUE_EQUAL			Indicates the "value equal" filter for text and numeric values.
VALUE_GREATER_THAN			Indicates the "value greater than" filter for text and numeric values.
VALUE_GREATER_THAN_OR_EQUAL			Indicates the "value greater than or equal to" filter for text and numeric values.
VALUE_LESS_THAN			Indicates the "value less than" filter for text and numeric values.
VALUE_LESS_THAN_OR_EQUAL			Indicates the "value less than or equal to" filter for text and numeric values.
VALUE_NOT_BETWEEN			Indicates the "value not between" filter for text and numeric values.
VALUE_NOT_EQUAL			Indicates the "value not equal" filter for text and numeric values.
YEAR_TO_DATE			Indicates the "year-to-date" filter for date values.
YESTERDAY			Indicates the "yesterday" filter for date values.

constant

PivotGroupByType number

Utility class containing constants. Represents group by type.

Properties

Name	Type	Optional	Description
RANGE_OF_VALUES			Group by numbers. NOTE: This method is now obsolete. Instead, please use PivotGroupByType.Numbers enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced.
NUMBERS			Group by numbers.
SECONDS			Presents Seconds groupby type.
MINUTES			Presents Minutes groupby type.
HOURS			Presents Hours groupby type.
DAYS			Presents Days groupby type.
MONTHS			Presents Months groupby type.
QUARTERS			Presents Quarters groupby type.
YEARS			Presents Years groupby type.

constant

PivotItemPosition number

Utility class containing constants. Represents PivotTable base item Next/Previous/All position in the base field .

Properties

Name	Type	Optional	Description
PREVIOUS			Represents the previous pivot item in the PivotField.
NEXT			Represents the next pivot item in the PivotField.
CUSTOM			Represents a pivot item index, as specified by Pivot Items, that specifies a pivot item in the PivotField. only read

constant

PivotMissingItemLimitType number

Utility class containing constants. Represents number of items to retain per field.

Properties

Name	Type	Optional	Description
AUTOMATIC			The default number of unique items per PivotField allowed.
MAX			The maximum number of unique items per PivotField allowed (>32,500).
NONE			No unique items per PivotField allowed.

constant

PivotTableAutoFormatType number

Utility class containing constants. Represents PivotTable auto format type.

Properties

Name	Type	Optional	Description
NONE			Represents None format type.
CLASSIC			Represents Classic auto format type.
REPORT_1			Represents Report1 format type.
REPORT_2			Represents Report2 format type.
REPORT_3			Represents Report3 format type.
REPORT_4			Represents Report4 format type.
REPORT_5			Represents Report5 format type.
REPORT_6			Represents Report6 format type.
REPORT_7			Represents Report7 format type.
REPORT_8			Represents Report8 format type.
REPORT_9			Represents Report9 format type.
REPORT_10			Represents Report10 format type.
TABLE_1			Represents Table1 format type.
TABLE_2			Represents Table2 format type.
TABLE_3			Represents Table3 format type.
TABLE_4			Represents Table4 format type.
TABLE_5			Represents Table5 format type.
TABLE_6			Represents Table6 format type.
TABLE_7			Represents Table7 format type.
TABLE_8			Represents Table8 format type.
TABLE_9			Represents Table9 format type.
TABLE_10			Represents Table10 format type.

constant

PivotTableSelectionType number

Utility class containing constants. Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.

Properties

Name	Type	Optional	Description
DATA_AND_LABEL			Data and labels
DATA_ONLY			Only selects data
LABEL_ONLY			Only selects labels

constant

PivotTableStyleType number

Utility class containing constants. Represents the pivot table style type.

Properties

Name	Type	Optional	Description
NONE
PIVOT_TABLE_STYLE_LIGHT_1
PIVOT_TABLE_STYLE_LIGHT_2
PIVOT_TABLE_STYLE_LIGHT_3
PIVOT_TABLE_STYLE_LIGHT_4
PIVOT_TABLE_STYLE_LIGHT_5
PIVOT_TABLE_STYLE_LIGHT_6
PIVOT_TABLE_STYLE_LIGHT_7
PIVOT_TABLE_STYLE_LIGHT_8
PIVOT_TABLE_STYLE_LIGHT_9
PIVOT_TABLE_STYLE_LIGHT_10
PIVOT_TABLE_STYLE_LIGHT_11
PIVOT_TABLE_STYLE_LIGHT_12
PIVOT_TABLE_STYLE_LIGHT_13
PIVOT_TABLE_STYLE_LIGHT_14
PIVOT_TABLE_STYLE_LIGHT_15
PIVOT_TABLE_STYLE_LIGHT_16
PIVOT_TABLE_STYLE_LIGHT_17
PIVOT_TABLE_STYLE_LIGHT_18
PIVOT_TABLE_STYLE_LIGHT_19
PIVOT_TABLE_STYLE_LIGHT_20
PIVOT_TABLE_STYLE_LIGHT_21
PIVOT_TABLE_STYLE_LIGHT_22
PIVOT_TABLE_STYLE_LIGHT_23
PIVOT_TABLE_STYLE_LIGHT_24
PIVOT_TABLE_STYLE_LIGHT_25
PIVOT_TABLE_STYLE_LIGHT_26
PIVOT_TABLE_STYLE_LIGHT_27
PIVOT_TABLE_STYLE_LIGHT_28
PIVOT_TABLE_STYLE_MEDIUM_1
PIVOT_TABLE_STYLE_MEDIUM_2
PIVOT_TABLE_STYLE_MEDIUM_3
PIVOT_TABLE_STYLE_MEDIUM_4
PIVOT_TABLE_STYLE_MEDIUM_5
PIVOT_TABLE_STYLE_MEDIUM_6
PIVOT_TABLE_STYLE_MEDIUM_7
PIVOT_TABLE_STYLE_MEDIUM_8
PIVOT_TABLE_STYLE_MEDIUM_9
PIVOT_TABLE_STYLE_MEDIUM_10
PIVOT_TABLE_STYLE_MEDIUM_11
PIVOT_TABLE_STYLE_MEDIUM_12
PIVOT_TABLE_STYLE_MEDIUM_13
PIVOT_TABLE_STYLE_MEDIUM_14
PIVOT_TABLE_STYLE_MEDIUM_15
PIVOT_TABLE_STYLE_MEDIUM_16
PIVOT_TABLE_STYLE_MEDIUM_17
PIVOT_TABLE_STYLE_MEDIUM_18
PIVOT_TABLE_STYLE_MEDIUM_19
PIVOT_TABLE_STYLE_MEDIUM_20
PIVOT_TABLE_STYLE_MEDIUM_21
PIVOT_TABLE_STYLE_MEDIUM_22
PIVOT_TABLE_STYLE_MEDIUM_23
PIVOT_TABLE_STYLE_MEDIUM_24
PIVOT_TABLE_STYLE_MEDIUM_25
PIVOT_TABLE_STYLE_MEDIUM_26
PIVOT_TABLE_STYLE_MEDIUM_27
PIVOT_TABLE_STYLE_MEDIUM_28
PIVOT_TABLE_STYLE_DARK_1
PIVOT_TABLE_STYLE_DARK_2
PIVOT_TABLE_STYLE_DARK_3
PIVOT_TABLE_STYLE_DARK_4
PIVOT_TABLE_STYLE_DARK_5
PIVOT_TABLE_STYLE_DARK_6
PIVOT_TABLE_STYLE_DARK_7
PIVOT_TABLE_STYLE_DARK_8
PIVOT_TABLE_STYLE_DARK_9
PIVOT_TABLE_STYLE_DARK_10
PIVOT_TABLE_STYLE_DARK_11
PIVOT_TABLE_STYLE_DARK_12
PIVOT_TABLE_STYLE_DARK_13
PIVOT_TABLE_STYLE_DARK_14
PIVOT_TABLE_STYLE_DARK_15
PIVOT_TABLE_STYLE_DARK_16
PIVOT_TABLE_STYLE_DARK_17
PIVOT_TABLE_STYLE_DARK_18
PIVOT_TABLE_STYLE_DARK_19
PIVOT_TABLE_STYLE_DARK_20
PIVOT_TABLE_STYLE_DARK_21
PIVOT_TABLE_STYLE_DARK_22
PIVOT_TABLE_STYLE_DARK_23
PIVOT_TABLE_STYLE_DARK_24
PIVOT_TABLE_STYLE_DARK_25
PIVOT_TABLE_STYLE_DARK_26
PIVOT_TABLE_STYLE_DARK_27
PIVOT_TABLE_STYLE_DARK_28
CUSTOM

constant

PlacementType number

Utility class containing constants. Represents the way the drawing object is attached to the cells below it.

Properties

Name	Type	Optional	Description
FREE_FLOATING			Don't move or size with cells.
MOVE			Move but don't size with cells.
MOVE_AND_SIZE			Move and size with cells.

constant

PlotDataByType number

Utility class containing constants. Represents the type of data plot by row or column.

Properties

Name	Type	Optional	Description
ROW			By row.
COLUMN			By column.

constant

PlotEmptyCellsType number

Utility class containing constants. Represents all plot empty cells type of a chart.

Properties

Name	Type	Optional	Description
NOT_PLOTTED			Not plotted(leave gap)
ZERO			Zero
INTERPOLATED			Interpolated

constant

PresetCameraType number

Utility class containing constants. Represent different algorithmic methods for setting all camera properties, including position.

Properties

Name	Type	Optional	Description
ISOMETRIC_BOTTOM_DOWN
ISOMETRIC_BOTTOM_UP
ISOMETRIC_LEFT_DOWN
ISOMETRIC_LEFT_UP
ISOMETRIC_OFF_AXIS_1_LEFT
ISOMETRIC_OFF_AXIS_1_RIGHT
ISOMETRIC_OFF_AXIS_1_TOP
ISOMETRIC_OFF_AXIS_2_LEFT
ISOMETRIC_OFF_AXIS_2_RIGHT
ISOMETRIC_OFF_AXIS_2_TOP
ISOMETRIC_OFF_AXIS_3_BOTTOM
ISOMETRIC_OFF_AXIS_3_LEFT
ISOMETRIC_OFF_AXIS_3_RIGHT
ISOMETRIC_OFF_AXIS_4_BOTTOM
ISOMETRIC_OFF_AXIS_4_LEFT
ISOMETRIC_OFF_AXIS_4_RIGHT
ISOMETRIC_RIGHT_DOWN
ISOMETRIC_RIGHT_UP
ISOMETRIC_TOP_DOWN
ISOMETRIC_TOP_UP
LEGACY_OBLIQUE_BOTTOM
LEGACY_OBLIQUE_BOTTOM_LEFT
LEGACY_OBLIQUE_BOTTOM_RIGHT
LEGACY_OBLIQUE_FRONT
LEGACY_OBLIQUE_LEFT
LEGACY_OBLIQUE_RIGHT
LEGACY_OBLIQUE_TOP
LEGACY_OBLIQUE_TOP_LEFT
LEGACY_OBLIQUE_TOP_RIGHT
LEGACY_PERSPECTIVE_BOTTOM
LEGACY_PERSPECTIVE_BOTTOM_LEFT
LEGACY_PERSPECTIVE_BOTTOM_RIGHT
LEGACY_PERSPECTIVE_FRONT
LEGACY_PERSPECTIVE_LEFT
LEGACY_PERSPECTIVE_RIGHT
LEGACY_PERSPECTIVE_TOP
LEGACY_PERSPECTIVE_TOP_LEFT
LEGACY_PERSPECTIVE_TOP_RIGHT
OBLIQUE_BOTTOM
OBLIQUE_BOTTOM_LEFT
OBLIQUE_BOTTOM_RIGHT
OBLIQUE_LEFT
OBLIQUE_RIGHT
OBLIQUE_TOP
OBLIQUE_TOP_LEFT
OBLIQUE_TOP_RIGHT
ORTHOGRAPHIC_FRONT
PERSPECTIVE_ABOVE
PERSPECTIVE_ABOVE_LEFT_FACING
PERSPECTIVE_ABOVE_RIGHT_FACING
PERSPECTIVE_BELOW
PERSPECTIVE_CONTRASTING_LEFT_FACING
PERSPECTIVE_CONTRASTING_RIGHT_FACING
PERSPECTIVE_FRONT
PERSPECTIVE_HEROIC_EXTREME_LEFT_FACING
PERSPECTIVE_HEROIC_EXTREME_RIGHT_FACING
PERSPECTIVE_HEROIC_LEFT_FACING
PERSPECTIVE_HEROIC_RIGHT_FACING
PERSPECTIVE_LEFT
PERSPECTIVE_RELAXED
PERSPECTIVE_RELAXED_MODERATELY
PERSPECTIVE_RIGHT

constant

PresetMaterialType number

Utility class containing constants. Describes surface appearance of a shape.

Properties

Name	Type	Optional	Description
CLEAR			Clear
DARK_EDGE			Dark edge
FLAT			Flat
LEGACY_MATTE			Legacy matte
LEGACY_METAL			Legacy metal
LEGACY_PLASTIC			Legacy plastic
LEGACY_WIREFRAME			Legacy wireframe
MATTE			Matte
METAL			Metal
PLASTIC			Plastic
POWDER			Powder
SOFT_EDGE			Soft edge
SOFT_METAL			Soft metal
TRANSLUCENT_POWDER			Translucent powder
WARM_MATTE			Warm matte

constant

PresetShadowType number

Utility class containing constants. Represents preset shadow type.

Properties

Name	Type	Optional	Description
NO_SHADOW			No shadow.
CUSTOM			Custom shadow.
OFFSET_DIAGONAL_BOTTOM_RIGHT			Outer shadow offset diagonal bottom right.
OFFSET_BOTTOM			Outer shadow offset bottom.
OFFSET_DIAGONAL_BOTTOM_LEFT			Outer shadow offset diagonal bottom left.
OFFSET_RIGHT			Outer shadow offset right.
OFFSET_CENTER			Outer shadow offset center.
OFFSET_LEFT			Outer shadow offset left.
OFFSET_DIAGONAL_TOP_RIGHT			Outer shadow offset diagonal top right.
OFFSET_TOP			Outer shadow offset top.
OFFSET_DIAGONAL_TOP_LEFT			Outer shadow offset diagonal top left.
INSIDE_DIAGONAL_TOP_LEFT			Inner shadow inside diagonal top Left.
INSIDE_TOP			Inner shadow inside top.
INSIDE_DIAGONAL_TOP_RIGHT			Inner shadow inside diagonal top right.
INSIDE_LEFT			Inner shadow inside left.
INSIDE_CENTER			Inner shadow inside center.
INSIDE_RIGHT			Inner shadow inside right.
INSIDE_DIAGONAL_BOTTOM_LEFT			Inner shadow inside diagonal bottom left.
INSIDE_BOTTOM			Inner shadow inside bottom.
INSIDE_DIAGONAL_BOTTOM_RIGHT			Inner shadow inside diagonal bottom right.
PERSPECTIVE_DIAGONAL_UPPER_LEFT			Outer shadow perspective diagonal upper left.
PERSPECTIVE_DIAGONAL_UPPER_RIGHT			Outer shadow perspective diagonal upper right.
BELOW			Outer shadow below.
PERSPECTIVE_DIAGONAL_LOWER_LEFT			Outer shadow perspective diagonal lower left.
PERSPECTIVE_DIAGONAL_LOWER_RIGHT			Outer shadow perspective diagonal lower right.

constant

PresetThemeGradientType number

Utility class containing constants. Represents the preset theme gradient type.

Properties

Name	Type	Optional	Description
LIGHT_GRADIENT			Light gradient
TOP_SPOTLIGHT			Top spotlight
MEDIUM_GRADIENT			Medium gradient
BOTTOM_SPOTLIGHT			Bottom spotlight
RADIAL_GRADIENT			Radial gradient

constant

PresetWordArtStyle number

Utility class containing constants. Represents the preset WordArt styles.

Properties

Name	Type	Optional	Description
WORD_ART_STYLE_1			Fill - Black, Text 1, Shadow
WORD_ART_STYLE_2			Fill - Blue, Accent 1, Shadow
WORD_ART_STYLE_3			Fill - Orange, Accent 2, Outline - Accent 2
WORD_ART_STYLE_4			Fill - White, Outline - Accent 1, Shadow
WORD_ART_STYLE_5			Fill - Gold, Accent 4, Soft Bevel
WORD_ART_STYLE_6			Gradient Fill - Gray
WORD_ART_STYLE_7			Gradient Fill - Blue, Accent 1, Reflection
WORD_ART_STYLE_8			Gradient Fill - Gold, Accent 4, Outline - Accent 4
WORD_ART_STYLE_9			Fill - White, Outline - Accent 1, Glow - Accent 1
WORD_ART_STYLE_10			Fill - Gray-50%, Accent 3, Sharp Bevel
WORD_ART_STYLE_11			Fill - Black, Text 1, Outline - Background 1, Hard Shadow - Background 1
WORD_ART_STYLE_12			Fill - Black, Text 1, Outline - Background 1, Hard Shadow - Accent 1
WORD_ART_STYLE_13			Fill - Blue, Accent 1, Outline - Background 1, Hard Shadow - Accent 1
WORD_ART_STYLE_14			Fill - White, Outline - Accent 2, Hard Shadow - Accent 2
WORD_ART_STYLE_15			Fill - Gray-25%, Background 2, Inner Shadow
WORD_ART_STYLE_16			Pattern Fill - White, Text 2, Dark Upward Diagonal, Shadow
WORD_ART_STYLE_17			Pattern Fill - Gray-50%, Accent 3, Narrow Horizontal, Inner Shadow
WORD_ART_STYLE_18			Fill - Blue, Accent 1, 50%, Hard Shadow - Accent 1
WORD_ART_STYLE_19			Pattern Fill - Blue, Accent 1, Light Downward Diagonal, Outline - Accent 1
WORD_ART_STYLE_20			Pattern Fill - Blue-Gray, Text 2, Dark Upward Diagonal, Hard Shadow - Text 2

constant

PrintCommentsType number

Utility class containing constants. Represents the way comments are printed with the sheet.

Properties

Name	Type	Optional	Description
PRINT_IN_PLACE			Represents to print comments as displayed on sheet.
PRINT_NO_COMMENTS			Represents not to print comments.
PRINT_SHEET_END			Represents to print comments at end of sheet.

constant

PrintErrorsType number

Utility class containing constants. Represents print errors constants.

Properties

Name	Type	Optional	Description
PRINT_ERRORS_BLANK			Represents not to print errors.
PRINT_ERRORS_DASH			Represents to print errors as "--".
PRINT_ERRORS_DISPLAYED			Represents to print errors as displayed.
PRINT_ERRORS_NA			Represents to print errors as "#N/A".

constant

PrintOrderType number

Utility class containing constants. Represent print order constants.

Properties

Name	Type	Optional	Description
DOWN_THEN_OVER			Down, then over
OVER_THEN_DOWN			Over, then down

constant

PrintSizeType number

Utility class containing constants. Represents the printed chart size.

Properties

Name	Type	Optional	Description
FULL			Use full page.
FIT			Scale to fit page.
CUSTOM			Custom.

constant

PrintingPageType number

Utility class containing constants. Indicates which pages will not be printed.

Properties

Name	Type	Optional	Description
DEFAULT			Prints all pages.
IGNORE_BLANK			Don't print the pages which the cells are blank.
IGNORE_STYLE			Don't print the pages which cells only contain styles.

constant

PropertyType number

Utility class containing constants. Specifies data type of a document property.

Properties

Name	Type	Optional	Description
BOOLEAN			The property is a boolean value.
DATE_TIME			The property is a date time value.
DOUBLE			The property is a floating number.
NUMBER			The property is an integer number.
STRING			The property is a string value.
BLOB			The property is a byte array.

constant

ProtectionType number

Utility class containing constants. Represents workbook/worksheet protection type.

Properties

Name	Type	Optional	Description
ALL			Represents to protect all.
CONTENTS			Represents to protect contents, used in Worksheet protection.
OBJECTS			Represents to protect objects, used in Worksheet protection.
SCENARIOS			Represents to protect scenarios, used in Worksheet protection.
STRUCTURE			Represents to protect structure, used in Workbook protection.
WINDOWS			Represents to protect window, used in Workbook protection.
NONE			Represents no protection. Only for Reading property.

constant

QuartileCalculationType number

Utility class containing constants. Represents quartile calculation methods.

Properties

Name	Type	Optional	Description
EXCLUSIVE			The quartile calculation includes the median when splitting the dataset into quartiles.
INCLUSIVE			The quartile calculation excludes the median when splitting the dataset into quartiles.

constant

ReConnectionMethodType number

Utility class containing constants. Specifies what the spreadsheet application should do when a connection fails.

Properties

Name	Type	Optional	Description
REQUIRED			On refresh use the existing connection information and if it ends up being invalid then get updated connection information, if available from the external connection file.
ALWAYS			On every refresh get updated connection information from the external connection file, if available, and use that instead of the existing connection information. In this case the data refresh will fail if the external connection file is unavailable.
NEVER			Never get updated connection information from the external connection file even if it is available and even if the existing connection information is invalid

constant

RectangleAlignmentType number

Utility class containing constants. Represents how to position two rectangles relative to each other.

Properties

Name	Type	Optional	Description
BOTTOM			Bottom
BOTTOM_LEFT			BottomLeft
BOTTOM_RIGHT			BottomRight
CENTER			Center
LEFT			Left
RIGHT			Right
TOP			Top
TOP_LEFT			TopLeft
TOP_RIGHT			TopRight

constant

ReflectionEffectType number

Utility class containing constants. Represents the effect type of reflection.

Properties

Name	Type	Optional	Description
NONE			No reflection effect.
CUSTOM			Custom reflection effect.
TIGHT_REFLECTION_TOUCHING			Tight reflection, touching.
HALF_REFLECTION_TOUCHING			Half reflection, touching.
FULL_REFLECTION_TOUCHING			Full reflection, touching.
TIGHT_REFLECTION_4_PT_OFFSET			Tight reflection, 4 pt offset.
HALF_REFLECTION_4_PT_OFFSET			Half reflection, 4 pt offset.
FULL_REFLECTION_4_PT_OFFSET			Full reflection, 4 pt offset.
TIGHT_REFLECTION_8_PT_OFFSET			Tight reflection, 8 pt offset.
HALF_REFLECTION_8_PT_OFFSET			Half reflection, 8 pt offset.
FULL_REFLECTION_8_PT_OFFSET			Full reflection, 8 pt offset.

constant

RenameStrategy number

Utility class containing constants. Strategy option for duplicate names of columns. When processing data with headers, some scenarios require the headers to be no duplication for all columns. For example, when exporting data to a datatable and the header is required to be taken as datatable's column name, duplicated values of the header are invalid. For such kind of situations, user may determine how to handle them by specifying this strategy.

Properties

Name	Type	Optional	Description
EXCEPTION			Throws exception.
DIGIT			Named with digit. Duplicated names will become ...1, ...2, etc.
LETTER			Named with letter.. Duplicated names will become ...A, ...B, etc.

constant

ReserveMissingPivotItemType number

Utility class containing constants. Represents how to keep the missing pivot items.

Properties

Name	Type	Optional	Description
DEFAULT			Removes old missint pivot items and reserves visible items which the current data source does not contain as missing items.
ALL			Reserves all missing items.
NONE			Removes all missing pivot items.

constant

ResourceLoadingType number

Utility class containing constants. Represents how to loading the linked resource.

Properties

Name	Type	Optional	Description
DEFAULT			Loads this resource as usual.
SKIP			Skips loading of this resource.
USER_PROVIDED			Use stream provided by user

constant

RevisionActionType number

Utility class containing constants. Represents the type of revision action.

Properties

Name	Type	Optional	Description
ADD			Add revision.
DELETE			Delete revision.
DELETE_COLUMN			Column delete revision.
DELETE_ROW			Row delete revision.
INSERT_COLUMN			Column insert revision.
INSERT_ROW			Row insert revision.

constant

RevisionType number

Utility class containing constants. Represents the revision type.

Properties

Name	Type	Optional	Description
CUSTOM_VIEW			Custom view.
DEFINED_NAME			Defined name.
CHANGE_CELLS			Cells change.
AUTO_FORMAT			Auto format.
MERGE_CONFLICT			Merge conflict.
COMMENT			Comment.
FORMAT			Format.
INSERT_SHEET			Insert worksheet.
MOVE_CELLS			Move cells.
UNDO			Undo.
QUERY_TABLE			Query table.
INSERT_DELETE			Inserting or deleting.
RENAME_SHEET			Rename worksheet.
UNKNOWN			Unknown.

constant

SaveFormat number

Utility class containing constants. Represents the format in which the workbook is saved.

Properties

Name	Type	Optional	Description
CSV			Comma-Separated Values(CSV) text file.
XLSX			Represents an xlsx file.
XLSM			Represents an xlsm file which enable macros.
XLTX			Represents an xltx file.
XLTM			Represents an xltm file which enable macros.
XLAM			Represents an xltm file which enable addin macros.
TSV			Tab-Separated Values(TSV) text file.
TAB_DELIMITED			Represents a tab delimited text file, same with TSV.
HTML			Represents a html file.
M_HTML			Represents a mhtml file.
ODS			Open Document Sheet(ODS) file.
EXCEL_97_TO_2003			Represents an Excel97-2003 xls file.
SPREADSHEET_ML			Represents an Excel 2003 xml file.
XLSB			Represents an xlsb file.
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.
UNKNOWN			Represents unrecognized format, cannot be saved.
PDF			Represents a Pdf file.
XPS			XPS (XML Paper Specification) format.
TIFF			Represents a TIFF file.
SVG			SVG file.
DIF			Data Interchange Format.
OTS			Open Document Template Sheet(OTS) file.
XLT			Excel 97-2003 template file.
XML			Represents a simple xml file.
NUMBERS			Represents a numbers file. Not supported.
MARKDOWN			Represents markdown document.
FODS			Represents OpenDocument Flat XML Spreadsheet (.fods) file format.
SXC			Represents StarOffice Calc Spreadsheet (.sxc) file format.
PPTX			Represents .pptx file.
DOCX			Represents .docx file.
EMF			Windows Enhanced Metafile.
JPG			JPEG JFIF.
PNG			Portable Network Graphics.
BMP			Windows Bitmap
GIF			Gif
JSON			Json
SQL_SCRIPT			Sql
X_HTML			Rrepesents XHtml file.
EPUB			Represents Epub file.

constant

SelectionType number

Utility class containing constants. The selection type of list box.

Properties

Name	Type	Optional	Description
SINGLE			Sigle selection type.
MULTI			Multiple selection type.
EXTEND			Extend selection type.

constant

ShapeAnchorType number

Utility class containing constants. Represents the anchor type.

Properties

Name	Type	Optional	Description
TWO_CELL_ANCHOR			Represents a two cell anchor placeholder
ONE_CELL_ANCHOR			Represents a one cell anchor placeholder

constant

ShapeLockType number

Utility class containing constants. Represents type of the property to be locked.

Properties

Name	Type	Optional	Description
GROUP			Group
ADJUST_HANDLES			AdjustHandles
TEXT			Text
POINTS			Points
CROP			Crop
SELECTION			Selection
MOVE			Move
ASPECT_RATIO			AspectRatio
ROTATION			Rotation
UNGROUP			Ungroup
RESIZE			Resize
SHAPE_TYPE			ShapeType
ARROWHEAD			Arrowhead

constant

ShapePathType number

Utility class containing constants. Represents path segment type.

Properties

Name	Type	Optional	Description
LINE_TO			Straight line segment
CUBIC_BEZIER_CURVE_TO			Cubic Bezier curve
MOVE_TO			Start a new path
CLOSE			If the starting POINT and the end POINT are not the same, a single straight line is drawn to connect the starting POINT and ending POINT of the path.
END			The end of the current path
ESCAPE			Escape
ARC_TO			An arc
UNKNOWN			Unknown

constant

SheetType number

Utility class containing constants. Specifies the worksheet type.

Properties

Name	Type	Optional	Description
VB			Visual Basic module
WORKSHEET
CHART			Chart
BIFF_4_MACRO			BIFF4 Macro sheet
INTERNATIONAL_MACRO			International Macro sheet
OTHER
DIALOG			Dialog worksheet

constant

ShiftType number

Utility class containing constants. Represent the shift options when deleting a range of cells.

Properties

Name	Type	Optional	Description
DOWN			Shift cells down.
LEFT			Shift cells left.
NONE			Do not shift cells.
RIGHT			Shift cells right.
UP			Shift cells up.

constant

ShowDropButtonType number

Utility class containing constants. Specifies when to show the drop button

Properties

Name	Type	Optional	Description
NEVER			Never show the drop button.
FOCUS			Show the drop button when the control has the focus.
ALWAYS			Always show the drop button.

constant

SlicerCacheCrossFilterType number

Utility class containing constants. Represent the type of SlicerCacheCrossFilterType

Properties

Name	Type	Optional	Description
NONE			The table style element of the slicer style for slicer items with no data is not applied to slicer items with no data, and slicer items with no data are not sorted separately in the list of slicer items in the slicer view
SHOW_ITEMS_WITH_DATA_AT_TOP			The table style element of the slicer style for slicer items with no data is applied to slicer items with no data, and slicer items with no data are sorted at the bottom in the list of slicer items in the slicer view
SHOW_ITEMS_WITH_NO_DATA			The table style element of the slicer style for slicer items with no data is applied to slicer items with no data, and slicer items with no data are not sorted separately in the list of slicer items in the slicer view.

constant

SlicerCacheItemSortType number

Utility class containing constants. Specify the sort type of SlicerCacheItem

Properties

Name	Type	Optional	Description
ASCENDING			Ascending sort type
DESCENDING			Descending sort type

constant

SlicerStyleType number

Utility class containing constants. Specify the style of slicer view

Properties

Name	Type	Optional	Description
SLICER_STYLE_LIGHT_1			built-in light style one
SLICER_STYLE_LIGHT_2			built-in light style two
SLICER_STYLE_LIGHT_3			built-in light style three
SLICER_STYLE_LIGHT_4			built-in light style four
SLICER_STYLE_LIGHT_5			built-in light style five
SLICER_STYLE_LIGHT_6			built-in light style six
SLICER_STYLE_OTHER_1			built-in style other one
SLICER_STYLE_OTHER_2			built-in style other two
SLICER_STYLE_DARK_1			built-in dark style one
SLICER_STYLE_DARK_2			built-in dark style tow
SLICER_STYLE_DARK_3			built-in dark style three
SLICER_STYLE_DARK_4			built-in dark style four
SLICER_STYLE_DARK_5			built-in dark style five
SLICER_STYLE_DARK_6			built-in dark style six
CUSTOM			user-defined style, unsupported for now unsupported

constant

SlideViewType number

Utility class containing constants. Represents the type when exporting to slides.

Properties

Name	Type	Optional	Description
VIEW			Exporting as view in MS Excel.
PRINT			Exporting as printing.

constant

SmartTagShowType number

Utility class containing constants. Represents the show type of the smart tag.

Properties

Name	Type	Optional	Description
ALL			Indicates that smart tags are enabled and shown
NO_SMART_TAG_INDICATOR			Indicates that the smart tags are enabled but the indicator not be shown.
NONE			Indicates that smart tags are disabled and not displayed.

constant

SortOnType number

Utility class containing constants. Sorted value type.

Properties

Name	Type	Optional	Description
VALUE			Sorts by cells' value.
CELL_COLOR			Sorts by cells' color.
FONT_COLOR			Sorts by cells' font color.
ICON			Sorts by conditional icon.

constant

SortOrder number

Utility class containing constants. Represents sort order for the data range.

Properties

Name	Type	Optional	Description
ASCENDING
DESCENDING

constant

SparklineAxisMinMaxType number

Utility class containing constants. Represents the minimum and maximum value types for the sparkline vertical axis.

Properties

Name	Type	Optional	Description
AUTO_INDIVIDUAL			Automatic for each sparkline.
GROUP			Same for all sparklines in the group.
CUSTOM			Custom value for sparkline.

constant

SparklinePresetStyleType number

Utility class containing constants. Represents the preset style types for sparkline.

Properties

Name	Type	Optional	Description
STYLE_1			Style 1
STYLE_2			Style 2
STYLE_3			Style 3
STYLE_4			Style 4
STYLE_5			Style 5
STYLE_6			Style 6
STYLE_7			Style 7
STYLE_8			Style 8
STYLE_9			Style 9
STYLE_10			Style 10
STYLE_11			Style 11
STYLE_12			Style 12
STYLE_13			Style 13
STYLE_14			Style 14
STYLE_15			Style 15
STYLE_16			Style 16
STYLE_17			Style 17
STYLE_18			Style 18
STYLE_19			Style 19
STYLE_20			Style 20
STYLE_21			Style 21
STYLE_22			Style 22
STYLE_23			Style 23
STYLE_24			Style 24
STYLE_25			Style 25
STYLE_26			Style 26
STYLE_27			Style 27
STYLE_28			Style 28
STYLE_29			Style 29
STYLE_30			Style 30
STYLE_31			Style 31
STYLE_32			Style 32
STYLE_33			Style 33
STYLE_34			Style 34
STYLE_35			Style 35
STYLE_36			Style 36
CUSTOM			No preset style.

constant

SparklineType number

Utility class containing constants. Represents the sparkline types.

Properties

Name	Type	Optional	Description
LINE			Line sparkline.
COLUMN			Column sparkline.
STACKED			Win/Loss sparkline.

constant

SqlDataType number

Utility class containing constants. Specifies SQL data type of the parameter. Only valid for ODBC sources.

Properties

Name	Type	Optional	Description
SQL_UNSIGNED_OFFSET			sql unsigned offset
SQL_SIGNED_OFFSET			sql signed offset
SQL_GUID			sql guid
SQL_W_LONG_VARCHAR			sql wide long variable char
SQL_W_VARCHAR			sql wide variable char
SQL_W_CHAR			sql wide char
SQL_BIT			sql bit
SQL_TINY_INT			sql tiny int
SQL_BIG_INT			sql big int
SQL_LONG_VAR_BINARY			sql long variable binary
SQL_VAR_BINARY			sql variable binary
SQL_BINARY			sql binary
SQL_LONG_VAR_CHAR			sql long variable char
SQL_UNKNOWN_TYPE			sql unknown type
SQL_CHAR			sql char
SQL_NUMERIC			sql numeric
SQL_DECIMAL			sql decimal
SQL_INTEGER			sql integer
SQL_SMALL_INT			sql small int
SQL_FLOAT			sql float
SQL_REAL			sql real
SQL_DOUBLE			sql double
SQL_TYPE_DATE			sql date type
SQL_TYPE_TIME			sql time type
SQL_TYPE_TIMESTAMP			sql timestamp type
SQL_VAR_CHAR			sql variable char
SQL_INTERVAL_YEAR			sql interval year
SQL_INTERVAL_MONTH			sql interval month
SQL_INTERVAL_DAY			sql interval day
SQL_INTERVAL_HOUR			sql interval hour
SQL_INTERVAL_MINUTE			sql interval minute
SQL_INTERVAL_SECOND			sql interval second
SQL_INTERVAL_YEAR_TO_MONTH			sql interval year to month
SQL_INTERVAL_DAY_TO_HOUR			sql interval day to hour
SQL_INTERVAL_DAY_TO_MINUTE			sql interval day to minute
SQL_INTERVAL_DAY_TO_SECOND			sql interval day to second
SQL_INTERVAL_HOUR_TO_MINUTE			sql interval hour to minute
SQL_INTERVAL_HOUR_TO_SECOND			sql interval hour to second
SQL_INTERVAL_MINUTE_TO_SECOND			sql interval minute to second

constant

SqlScriptOperatorType number

Utility class containing constants. Represents the type of operating data.

Properties

Name	Type	Optional	Description
INSERT			Insert data.
UPDATE			Update data.
DELETE			Delete data.

constant

StyleModifyFlag number

Utility class containing constants. The style modified flags.

Properties

Name	Type	Optional	Description
LEFT_BORDER			Indicates whether left border has been modified for the style.
RIGHT_BORDER			Indicates whether right border has been modified for the style.
TOP_BORDER			Indicates whether top border has been modified for the style.
BOTTOM_BORDER			Indicates whether bottom border has been modified for the style.
DIAGONAL_DOWN_BORDER			Indicates whether diagonal-down border has been modified for the style.
DIAGONAL_UP_BORDER			Indicates whether diagonal-up border has been modified for the style.
DIAGONAL			Indicates whether one or more diagonal borders(DIAGONAL_DOWN_BORDER, DIAGONAL_UP_BORDER) have been modified for the style.
HORIZONTAL_BORDER			Indicates whether horizontal border has been modified for the style. Only for dynamic style, such as conditional formatting.
VERTICAL_BORDER			Indicates whether vertical border has been modified for the style. Only for dynamic style, such as conditional formatting.
BORDERS			Indicates whether one or more borders(LEFT_BORDER, RIGHT_BORDER, TOP_BORDER, BOTTOM_BORDER, DIAGONAL, HORIZONTAL_BORDER, VERTICAL_BORDER) have been modified for the style.
NUMBER_FORMAT			Indicates whether numberformat has been modified.
HORIZONTAL_ALIGNMENT			Indicates whether horizontal alignment has been modified.
VERTICAL_ALIGNMENT			Indicates whether vertical alignment has been modified.
INDENT			Indicates whether indent property has been modified.
ROTATION			Indicates whether rotation property has been modified.
WRAP_TEXT			Indicates whether wrap text property has been modified.
SHRINK_TO_FIT			Indicates whether shrink to fit property has been modified.
TEXT_DIRECTION			Indicates whether text direction property has been modified.
RELATIVE_INDENT			Indicates whether relative indent property has been modified for the style. Only for dynamic style, such as conditional formatting.
ALIGNMENT_SETTINGS			Indicates whether one or more alignment-related properties(HORIZONTAL_ALIGNMENT, VERTICAL_ALIGNMENT, ROTATION, WRAP_TEXT, WRAP_TEXT, INDENT, SHRINK_TO_FIT, TEXT_DIRECTION, RELATIVE_INDENT) have been modified.
PATTERN			Indicates whether pattern of the shading has been modified.
FOREGROUND_COLOR			Indicates whether foreground color has been modified.
BACKGROUND_COLOR			Indicates whether background color has been modified.
CELL_SHADING			Indicates whether one or more shading-related properties(PATTERN, FOREGROUND_COLOR, BACKGROUND_COLOR) have been modified.
LOCKED			Indicates whether locked property has been modified.
HIDE_FORMULA			Indicates whether hide formula has been modified.
PROTECTION_SETTINGS			Indicates whether one or more protection-related properties(LOCKED, HIDE_FORMULA) have been modified.
FONT_SIZE			Indicates whether font size has been modified.
FONT_NAME			Indicates whether font name has been modified.
FONT_COLOR			Indicates whether font color has been modified.
FONT_WEIGHT			Indicates whether font weight has been modified.
FONT_ITALIC			Indicates whether italic property of font has been modified.
FONT_UNDERLINE			Indicates whether underline property of font has been modified.
FONT_STRIKE			Indicates whether strike property font has been modified.
FONT_SCRIPT			Indicates whether subscript or superscript property of font has been modified.
FONT_FAMILY			Indicates whether font family has been modified.
FONT_CHARSET			Indicates whether charset of the font has been modified.
FONT_SCHEME			unused.
FONT_DIRTY			unused.
FONT_SPELLING_ERROR			unused.
FONT_U_FILL_TX			unused.
FONT_SPACING			unused.
FONT_KERNING			unused.
FONT_EQUALIZE			unused.
FONT_CAP			unused.
FONT_VERTICAL_TEXT
FONT			Indicates whether one or more properties have been modified for the font of the style.
ALL			Indicates whether one or more properties have been modified for the style.

constant

TableDataSourceType number

Utility class containing constants. Represents the table's data source type.

Properties

Name	Type	Optional	Description
WORKSHEET			Excel Worksheet Table
SHARE_POINT			Read-write SharePoint linked List
XML			XML mapper Table
QUERY_TABLE			Query Table

constant

TableStyleElementType number

Utility class containing constants. Represents the Table or PivotTable style element type.

Properties

Name	Type	Optional	Description
BLANK_ROW			Table style element that applies to PivotTable's blank rows.
FIRST_COLUMN			Table style element that applies to table's first column.
FIRST_COLUMN_STRIPE			Table style element that applies to table's first column stripes.
FIRST_COLUMN_SUBHEADING			Table style element that applies to PivotTable's first column subheading.
FIRST_HEADER_CELL			Table style element that applies to table's first header row cell.
FIRST_ROW_STRIPE			Table style element that applies to table's first row stripes.
FIRST_ROW_SUBHEADING			Table style element that applies to PivotTable's first row subheading.
FIRST_SUBTOTAL_COLUMN			Table style element that applies to PivotTable's first subtotal column.
FIRST_SUBTOTAL_ROW			Table style element that applies to pivot table's first subtotal row.
GRAND_TOTAL_COLUMN			Table style element that applies to pivot table's grand total column.
GRAND_TOTAL_ROW			Table style element that applies to pivot table's grand total row.
FIRST_TOTAL_CELL			Table style element that applies to table's first total row cell.
HEADER_ROW			Table style element that applies to table's header row.
LAST_COLUMN			Table style element that applies to table's last column.
LAST_HEADER_CELL			Table style element that applies to table's last header row cell.
LAST_TOTAL_CELL			Table style element that applies to table's last total row cell.
PAGE_FIELD_LABELS			Table style element that applies to pivot table's page field labels.
PAGE_FIELD_VALUES			Table style element that applies to pivot table's page field values.
SECOND_COLUMN_STRIPE			Table style element that applies to table's second column stripes.
SECOND_COLUMN_SUBHEADING			Table style element that applies to pivot table's second column subheading.
SECOND_ROW_STRIPE			Table style element that applies to table's second row stripes.
SECOND_ROW_SUBHEADING			Table style element that applies to pivot table's second row subheading.
SECOND_SUBTOTAL_COLUMN			Table style element that applies to PivotTable's second subtotal column.
SECOND_SUBTOTAL_ROW			Table style element that applies to PivotTable's second subtotal row.
THIRD_COLUMN_SUBHEADING			Table style element that applies to PivotTable's third column subheading.
THIRD_ROW_SUBHEADING			Table style element that applies to PivotTable's third row subheading.
THIRD_SUBTOTAL_COLUMN			Table style element that applies to pivot table's third subtotal column.
THIRD_SUBTOTAL_ROW			Table style element that applies to PivotTable's third subtotal row.
TOTAL_ROW			Table style element that applies to table's total row.
WHOLE_TABLE			Table style element that applies to table's entire content.

constant

TableStyleType number

Utility class containing constants. Represents the built-in table style type.

Properties

Name	Type	Optional	Description
NONE
TABLE_STYLE_LIGHT_1
TABLE_STYLE_LIGHT_2
TABLE_STYLE_LIGHT_3
TABLE_STYLE_LIGHT_4
TABLE_STYLE_LIGHT_5
TABLE_STYLE_LIGHT_6
TABLE_STYLE_LIGHT_7
TABLE_STYLE_LIGHT_8
TABLE_STYLE_LIGHT_9
TABLE_STYLE_LIGHT_10
TABLE_STYLE_LIGHT_11
TABLE_STYLE_LIGHT_12
TABLE_STYLE_LIGHT_13
TABLE_STYLE_LIGHT_14
TABLE_STYLE_LIGHT_15
TABLE_STYLE_LIGHT_16
TABLE_STYLE_LIGHT_17
TABLE_STYLE_LIGHT_18
TABLE_STYLE_LIGHT_19
TABLE_STYLE_LIGHT_20
TABLE_STYLE_LIGHT_21
TABLE_STYLE_MEDIUM_1
TABLE_STYLE_MEDIUM_2
TABLE_STYLE_MEDIUM_3
TABLE_STYLE_MEDIUM_4
TABLE_STYLE_MEDIUM_5
TABLE_STYLE_MEDIUM_6
TABLE_STYLE_MEDIUM_7
TABLE_STYLE_MEDIUM_8
TABLE_STYLE_MEDIUM_9
TABLE_STYLE_MEDIUM_10
TABLE_STYLE_MEDIUM_11
TABLE_STYLE_MEDIUM_12
TABLE_STYLE_MEDIUM_13
TABLE_STYLE_MEDIUM_14
TABLE_STYLE_MEDIUM_15
TABLE_STYLE_MEDIUM_16
TABLE_STYLE_MEDIUM_17
TABLE_STYLE_MEDIUM_18
TABLE_STYLE_MEDIUM_19
TABLE_STYLE_MEDIUM_20
TABLE_STYLE_MEDIUM_21
TABLE_STYLE_MEDIUM_22
TABLE_STYLE_MEDIUM_23
TABLE_STYLE_MEDIUM_24
TABLE_STYLE_MEDIUM_25
TABLE_STYLE_MEDIUM_26
TABLE_STYLE_MEDIUM_27
TABLE_STYLE_MEDIUM_28
TABLE_STYLE_DARK_1
TABLE_STYLE_DARK_2
TABLE_STYLE_DARK_3
TABLE_STYLE_DARK_4
TABLE_STYLE_DARK_5
TABLE_STYLE_DARK_6
TABLE_STYLE_DARK_7
TABLE_STYLE_DARK_8
TABLE_STYLE_DARK_9
TABLE_STYLE_DARK_10
TABLE_STYLE_DARK_11
CUSTOM

constant

TargetModeType number

Utility class containing constants. Represents the type of target mode.

Properties

Name	Type	Optional	Description
EXTERNAL			External link
FILE_PATH			Local and full paths to files or folders.
EMAIL			Email.
CELL_REFERENCE			Link on cell or named range.

constant

TextAlignmentType number

Utility class containing constants. Enumerates text alignment types.

Properties

Name	Type	Optional	Description
GENERAL			Represents general text alignment.
BOTTOM			Represents bottom text alignment.
CENTER			Represents center text alignment.
CENTER_ACROSS			Represents center across text alignment.
DISTRIBUTED			Represents distributed text alignment.
FILL			Represents fill text alignment.
JUSTIFY			Represents justify text alignment.
LEFT			Represents left text alignment.
RIGHT			Represents right text alignment.
TOP			Represents top text alignment.
JUSTIFIED_LOW			Aligns the text with an adjusted kashida length for Arabic text.
THAI_DISTRIBUTED			Distributes Thai text specially, because each character is treated as a word.

constant

TextAutonumberScheme number

Utility class containing constants. Represents all automatic number scheme.

Properties

Name	Type	Optional	Description
NONE
ALPHA_LC_PAREN_BOTH			(a), (b), (c), …
ALPHA_LC_PAREN_R			a), b), c), …
ALPHA_LC_PERIOD			a., b., c., …
ALPHA_UC_PAREN_BOTH			(A), (B), (C), …
ALPHA_UC_PAREN_R			A), B), C), …
ALPHA_UC_PERIOD			A., B., C., …
ARABIC_1_MINUS			Bidi Arabic 1 (AraAlpha) with ANSI minus symbol
ARABIC_2_MINUS			Bidi Arabic 2 (AraAbjad) with ANSI minus symbol
ARABIC_DB_PERIOD			Dbl-byte Arabic numbers w/ double-byte period
ARABIC_DB_PLAIN			Dbl-byte Arabic numbers
ARABIC_PAREN_BOTH			(1), (2), (3), …
ARABIC_PAREN_R			1), 2), 3), …
ARABIC_PERIOD			1., 2., 3., …
ARABIC_PLAIN			1, 2, 3, …
CIRCLE_NUM_DB_PLAIN			Dbl-byte circle numbers (1-10 circle[0x2460-], 11-arabic numbers)
CIRCLE_NUM_WD_BLACK_PLAIN			Wingdings black circle numbers
CIRCLE_NUM_WD_WHITE_PLAIN			Wingdings white circle numbers (0-10 circle[0x0080-],11- arabic numbers)
EA_1_CHS_PERIOD			EA: Simplified Chinese w/ single-byte period
EA_1_CHS_PLAIN			EA: Simplified Chinese (TypeA 1-99, TypeC 100-)
EA_1_CHT_PERIOD			EA: Traditional Chinese w/ single-byte period
EA_1_CHT_PLAIN			EA: Traditional Chinese (TypeA 1-19, TypeC 20-)
EA_1_JPN_CHS_DB_PERIOD			EA: Japanese w/ double-byte period
EA_1_JPN_KOR_PERIOD			EA: Japanese/Korean w/ single-byte period
EA_1_JPN_KOR_PLAIN			EA: Japanese/Korean (TypeC 1-)
HEBREW_2_MINUS			Bidi Hebrew 2 with ANSI minus symbol
HINDI_ALPHA_1_PERIOD			Hindi alphabet period - consonants
HINDI_ALPHA_PERIOD			Hindi alphabet period - vowels
HINDI_NUM_PAREN_R			/// Hindi numerical parentheses - right
HINDI_NUM_PERIOD			Hindi numerical period
ROMAN_LC_PAREN_BOTH			(i), (ii), (iii), …
ROMAN_LC_PAREN_R			i), ii), iii), …
ROMAN_LC_PERIOD			i., ii., iii., …
ROMAN_UC_PAREN_BOTH			(I), (II), (III), …
ROMAN_UC_PAREN_R			I), II), III), …
ROMAN_UC_PERIOD			I., II., III., …
THAI_ALPHA_PAREN_BOTH			Thai alphabet parentheses - both
THAI_ALPHA_PAREN_R			Thai alphabet parentheses - right
THAI_ALPHA_PERIOD			Thai alphabet period
THAI_NUM_PAREN_BOTH			Thai numerical parentheses - both
THAI_NUM_PAREN_R			Thai numerical parentheses - right
THAI_NUM_PERIOD			Thai numerical period

constant

TextCapsType number

Utility class containing constants. This type specifies the cap types of the text.

Properties

Name	Type	Optional	Description
NONE			None caps
ALL			Apply all caps on the text.
SMALL			Apply small caps to the text.

constant

TextCrossType number

Utility class containing constants. Enumerates displaying text type when the text width is larger than cell width.

Properties

Name	Type	Optional	Description
DEFAULT			Display text like in Microsoft Excel.
CROSS_KEEP			Display all the text by crossing other cells and keep text of crossed cells.
CROSS_OVERRIDE			Display all the text by crossing other cells and override text of crossed cells.
STRICT_IN_CELL			Only display the text within the width of cell.

constant

TextDirectionType number

Utility class containing constants. Represents the direction of the text flow for this paragraph.

Properties

Name	Type	Optional	Description
CONTEXT
LEFT_TO_RIGHT
RIGHT_TO_LEFT

constant

TextFontAlignType number

Utility class containing constants. Represents the different types of font alignment.

Properties

Name	Type	Optional	Description
AUTOMATIC			When the text flow is horizontal or simple vertical same as fontBaseline but for other vertical modes same as fontCenter.
BOTTOM			The letters are anchored to the very bottom of a single line.
BASELINE			The letters are anchored to the bottom baseline of a single line.
CENTER			The letters are anchored between the two baselines of a single line.
TOP			The letters are anchored to the top baseline of a single line.

constant

TextNodeType number

Utility class containing constants. Represents the node type.

Properties

Name	Type	Optional	Description
TEXT_RUN			Represents the text node.
TEXT_PARAGRAPH			Represents the text paragraph.
EQUATION			Represents the equation text.

constant

TextOrientationType number

Utility class containing constants. Enumerates text orientation types.

Properties

Name	Type	Optional	Description
CLOCK_WISE			Rotates text with 90 degrees clockwise.
COUNTER_CLOCK_WISE			Rotates text with 90 degrees counterclockwise.
NO_ROTATION			Represents the default value.
TOP_TO_BOTTOM			Displays text from top to bottom of the cell. Stacked text.

constant

TextOverflowType number

Utility class containing constants. Represents the way the text vertical or horizontal overflow.

Properties

Name	Type	Optional	Description
CLIP			Pay attention to top and bottom barriers. Provide no indication that there is text which is not visible.
ELLIPSIS			Pay attention to top and bottom barriers. Use an ellipsis to denote that there is text which is not visible. Only for vertical overflow.
OVERFLOW			Overflow the text and pay no attention to top and bottom barriers.

constant

TextStrikeType number

Utility class containing constants. This type specifies the strike type.

Properties

Name	Type	Optional	Description
SINGLE			A single strikethrough applied on the text.
DOUBLE			A double strikethrough applied on the text.
NONE			No strike is applied to the text.

constant

TextTabAlignmentType number

Utility class containing constants. Represents the text tab alignment types.

Properties

Name	Type	Optional	Description
CENTER			The text at this tab stop is center aligned.
DECIMAL			At this tab stop, the decimals are lined up.
LEFT			The text at this tab stop is left aligned.
RIGHT			The text at this tab stop is right aligned.

constant

TextVerticalType number

Utility class containing constants. Represents the text direct type.

Properties

Name	Type	Optional	Description
VERTICAL			East Asian Vertical display.
HORIZONTAL			Horizontal text.
VERTICAL_LEFT_TO_RIGHT			Displayed vertical and the text flows top down then LEFT to RIGHT
VERTICAL_90			Each line is 90 degrees rotated clockwise
VERTICAL_270			Each line is 270 degrees rotated clockwise
STACKED			Determines if all of the text is vertical
STACKED_RIGHT_TO_LEFT			Specifies that vertical WordArt should be shown from right to left rather than left to right.

constant

TextureType number

Utility class containing constants. Represents the preset texture type.

Properties

Name	Type	Optional	Description
BLUE_TISSUE_PAPER			Represents Blue Tissue Paper texture type.
BOUQUET			Represents Bouquet texture type.
BROWN_MARBLE			Represents Brown Marble texture type.
CANVAS			Represents Canvas texture type.
CORK			Represents Cork texture type.
DENIM			Represents Denim texture type.
FISH_FOSSIL			Represents Fish Fossil texture type.
GRANITE			Represents Granite texture type.
GREEN_MARBLE			Represents Green Marble texture type.
MEDIUM_WOOD			Represents Medium Wood texture type.
NEWSPRINT			Represents Newsprint texture type.
OAK			Represents Oak texture type.
PAPER_BAG			Represents Paper Bag texture type.
PAPYRUS			Represents Papyrus texture type.
PARCHMENT			Represents Parchment texture type.
PINK_TISSUE_PAPER			Represents Pink Tissue Paper texture type.
PURPLE_MESH			Represents Purple Mesh texture type.
RECYCLED_PAPER			Represents Recycled Paper texture type.
SAND			Represents Sand texture type.
STATIONERY			Represents Stationery texture type.
WALNUT			Represents Walnut Droplets texture type.
WATER_DROPLETS			Represents Water Droplets texture type.
WHITE_MARBLE			Represents White Marble texture type.
WOVEN_MAT			Represents Woven Mat texture type.
UNKNOWN			Represents Unknown texture type.

constant

ThemeColorType number

Utility class containing constants. Enumerates the theme color types.

Properties

Name	Type	Optional	Description
BACKGROUND_1
TEXT_1
BACKGROUND_2
TEXT_2
ACCENT_1
ACCENT_2
ACCENT_3
ACCENT_4
ACCENT_5
ACCENT_6
HYPERLINK
FOLLOWED_HYPERLINK
STYLE_COLOR			Inner used. A color used in theme definitions which means to use the color of the style.

constant

TickLabelAlignmentType number

Utility class containing constants. Represents the text alignment type for the tick labels on the axis

Properties

Name	Type	Optional	Description
CENTER			Represents the text shall be centered.
LEFT			Represents the text shall be left justified.
RIGHT			Represents the text shall be right justified.

constant

TickLabelPositionType number

Utility class containing constants. Represents the position type of tick-mark labels on the specified axis.

Properties

Name	Type	Optional	Description
HIGH			Position type is high.
LOW			Position type is low.
NEXT_TO_AXIS			Position type is next to axis.
NONE			Position type is none.

constant

TickMarkType number

Utility class containing constants. Represents the tick mark type for the specified axis.

Properties

Name	Type	Optional	Description
CROSS			Tick mark type is Cross.
INSIDE			Tick mark type is Inside.
NONE			Tick mark type is None.
OUTSIDE			Tick mark type is Outside

constant

TiffCompression number

Utility class containing constants. Specifies what type of compression to apply when saving images into TIFF format file.

Properties

Name	Type	Optional	Description
COMPRESSION_NONE			Specifies no compression.
COMPRESSION_RLE			Specifies the RLE compression scheme.
COMPRESSION_LZW			Specifies the LZW compression scheme.
COMPRESSION_CCITT_3			Specifies the CCITT3 compression scheme.
COMPRESSION_CCITT_4			Specifies the CCITT4 compression scheme.

constant

TimePeriodType number

Utility class containing constants. 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.

Properties

Name	Type	Optional	Description
TODAY			Today's date.
YESTERDAY			Yesterday's date.
TOMORROW			Tomorrow's date.
LAST_7_DAYS			A date in the last seven days.
THIS_MONTH			A date occurring in this calendar month.
LAST_MONTH			A date occurring in the last calendar month.
NEXT_MONTH			A date occurring in the next calendar month.
THIS_WEEK			A date occurring this week.
LAST_WEEK			A date occurring last week.
NEXT_WEEK			A date occurring next week.
THIS_YEAR			A date occurring this year. Only for .ods.
LAST_YEAR			A date occurring last year. Only for .ods.
NEXT_YEAR			A date occurring next year. Only for .ods.

constant

TimeUnit number

Utility class containing constants. Represents the base unit for the category axis.

Properties

Name	Type	Optional	Description
DAYS			Days
MONTHS			Months
YEARS			Years

constant

TotalsCalculation number

Utility class containing constants. Determines the type of calculation in the Totals row of the list column.

Properties

Name	Type	Optional	Description
SUM			Represents Sum totals calculation.
COUNT			Represents Count totals calculation.
AVERAGE			Represents Average totals calculation.
MAX			Represents Max totals calculation.
MIN			Represents Min totals calculation.
VAR			Represents Var totals calculation.
COUNT_NUMS			Represents Count Nums totals calculation.
STD_DEV			Represents StdDev totals calculation.
NONE			Represents No totals calculation.
CUSTOM			Represents custom calculation.

constant

TrendlineType number

Utility class containing constants. Represents the trendline type.

Properties

Name	Type	Optional	Description
EXPONENTIAL			Exponential
LINEAR			Linear
LOGARITHMIC			Logarithmic
MOVING_AVERAGE			MovingAverage
POLYNOMIAL			Polynomial
POWER			Power

constant

TxtLoadStyleStrategy number

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

Properties

Name	Type	Optional	Description
NONE			Does not set style for the parsed value.
BUILT_IN			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.
EXACT_FORMAT			Set the exact custom format for the parsed value to make the formatted value be same with the original input one.

constant

TxtValueQuoteType number

Utility class containing constants. Specifies the type of using quotation marks for values in text format files.

Properties

Name	Type	Optional	Description
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.
ALWAYS			All values will be quoted always.
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.
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.

constant

UpdateLinksType number

Utility class containing constants. Represents how to update links to other workbooks when the workbook is opened.

Properties

Name	Type	Optional	Description
USER_SET			Prompt user to update.
NEVER			Do not update, and do not prompt user.
ALWAYS			Always update.

constant

ValidationAlertType number

Utility class containing constants. Represents the data validation alert style.

Properties

Name	Type	Optional	Description
INFORMATION			Information alert style.
STOP			Stop alert style.
WARNING			Warning alert style.

constant

ValidationType number

Utility class containing constants. Represents data validation type.

Properties

Name	Type	Optional	Description
ANY_VALUE			Any value validation type.
WHOLE_NUMBER			Whole number validation type.
DECIMAL			Decimal validation type.
LIST			List validation type.
DATE			Date validation type.
TIME			Time validation type.
TEXT_LENGTH			Text length validation type.
CUSTOM			Custom validation type.

constant

VbaModuleType number

Utility class containing constants. Represents the type of VBA module.

Properties

Name	Type	Optional	Description
PROCEDURAL			Represents a procedural module.
DOCUMENT			Represents a document module.
CLASS			Represents a class module.
DESIGNER			Represents a designer module.

constant

VbaProjectReferenceType number

Utility class containing constants. Represents the type of VBA project reference.

Properties

Name	Type	Optional	Description
REGISTERED			Specifies a reference to an Automation type library.
CONTROL			Specifies a reference to a twiddled type library and its extended type library.
PROJECT			Specifies a reference to an external VBA project.

constant

ViewType number

Utility class containing constants. Represents the view type of the worksheet.

Properties

Name	Type	Optional	Description
NORMAL_VIEW
PAGE_BREAK_PREVIEW
PAGE_LAYOUT_VIEW

constant

VisibilityType number

Utility class containing constants. Represents the states for sheet visibility.

Properties

Name	Type	Optional	Description
VISIBLE			Indicates the sheet is visible.
HIDDEN			Indicates the sheet is hidden, but can be shown by the user via the user interface.
VERY_HIDDEN			Indicates the sheet is hidden and cannot be shown in the user interface (UI). This state is only available programmatically.

constant

WebExtensionStoreType number

Utility class containing constants. Represents the store type of web extension.

Properties

Name	Type	Optional	Description
OMEX			Specifies that the store type is Office.com.
SP_CATALOG			Specifies that the store type is SharePoint corporate catalog.
SP_APP			Specifies that the store type is a SharePoint web application.
EXCHANGE			Specifies that the store type is an Exchange server.
FILE_SYSTEM			Specifies that the store type is a file system share.
REGISTRY			Specifies that the store type is the system registry.
EX_CATALOG			Specifies that the store type is Centralized Deployment via Exchange.

constant

WeightType number

Utility class containing constants. Enumerates the weight types for a picture border or a chart line.

Properties

Name	Type	Optional	Description
HAIR_LINE			Represents the weight of hair line.
MEDIUM_LINE			Represents the weight of medium line.
SINGLE_LINE			Represents the weight of single line.
WIDE_LINE			Represents the weight of wide line.

constant

XAdESType number

Utility class containing constants. Type of XML Advanced Electronic Signature (XAdES).

Properties

Name	Type	Optional	Description
NONE			XAdES is off.
X_AD_ES			Basic XAdES.