Globals

Properties

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

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_WAVE_3

 

 

A wavy text shape. NOTE: This enum is now obsolete. Instead, please use AutoShape.TextDoubleWave1. This property will be removed 12 months later since April 2016. Aspose apologizes for any inconvenience you may have experienced.

TEXT_WAVE_4

 

 

A wavy text shape. NOTE: This enum is now obsolete. Instead, please use AutoShape.TextDoubleWave2. This property will be removed 12 months later since April 2016. Aspose apologizes for any inconvenience you may have experienced.

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 type

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

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_BOOL

 

 

Cell value is boolean.

IS_DATE_TIME

 

 

Cell value is datetime.

IS_ERROR

 

 

Cell contains error value

IS_NULL

 

 

Blank cell.

IS_NUMERIC

 

 

Cell value is numeric.

IS_STRING

 

 

Cell value is string.

IS_UNKNOWN

 

 

Cell value type is unknown.

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.

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

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

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

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.

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

DataLablesSeparatorType  number

Utility class containing constants. Represents the separator type of DataLabels. NOTE: This member is now obsolete. Instead, please use DataLabelsSeparatorType enum. This property will be removed 12 months later since September 2020. Aspose apologizes for any inconvenience you may have experienced.

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.

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.

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

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

CALC

 

 

check for calculation errors

EMPTY_CELL_REF

 

 

check for references to empty cells

TEXT_NUMBER

 

 

check the format of numeric values

INCONSIST_RANGE

 

 

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

INCONSIST_FORMULA

 

 

check formulas that are inconsistent with formulas in neighboring cells.

TEXT_DATE

 

 

check the format of date/time values

UNPROCTED_FORMULA

 

 

check for unprotected formulas

VALIDATION

 

 

whether to perform data validation

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.

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 SpreadsheetML file.

EXCEL_2003_XML

 

 

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

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.

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 The file format is not supported. Only for detecting file type.

EMF

 

 

Windows Enhanced Metafile.

WMF

 

 

Windows Metafile.

JPG

 

 

JPEG JFIF.

PNG

 

 

Portable Network Graphics.

GIF

 

 

Gif

JSON

 

 

Json

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

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.

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

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.

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

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

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

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

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

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.

NUMBERS

 

 

Represents a numbers file.

FODS

 

 

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

SXC

 

 

Represents StarOffice Calc Spreadsheet (.sxc) file format.

UNKNOWN

 

 

Represents unrecognized format, cannot be loaded.

IMAGE

 

 

Image

JSON

 

 

Json

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

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.

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

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

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

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_NUMBER_FORMATS

 

 

constant

PdfCompliance  number

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

Properties

Name Type Optional Description

NONE

 

 

Normal pdf format

PDF_A_1_B

 

 

Pdf format compatible with PDFA-1b

PDF_A_1_A

 

 

Pdf format compatible with PDFA-1a

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

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

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 PivotTable groupby type.

Properties

Name Type Optional Description

RANGE_OF_VALUES

 

 

Presents range of values groupby type.

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

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

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

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

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

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

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.

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. Renames strategy when columns contains the duplicate names.

Properties

Name Type Optional Description

EXCEPTION

 

 

Throws exception.

DIGIT

 

 

Named with digit.

LETTER

 

 

Named with letter.

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

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.

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

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

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

StyleModifyFlag  number

Utility class containing constants. The style modified flags.

Properties

Name Type Optional Description

ALL

 

 

BORDERS

 

 

LEFT_BORDER

 

 

RIGHT_BORDER

 

 

TOP_BORDER

 

 

BOTTOM_BORDER

 

 

HORIZONTAL_BORDER

 

 

Only for dynamic style,such as conditional formatting.

VERTICAL_BORDER

 

 

Only for dynamic style,such as conditional formatting.

DIAGONAL

 

 

DIAGONAL_DOWN_BORDER

 

 

DIAGONAL_UP_BORDER

 

 

FONT

 

 

FONT_SIZE

 

 

FONT_NAME

 

 

FONT_FAMILY

 

 

FONT_CHARSET

 

 

FONT_COLOR

 

 

FONT_WEIGHT

 

 

FONT_ITALIC

 

 

FONT_UNDERLINE

 

 

FONT_STRIKE

 

 

FONT_SUBSCRIPT

 

 

NOTE: This member is now obsolete. Instead, please use FontScript. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.

FONT_SUPERSCRIPT

 

 

NOTE: This member is now obsolete. Instead, please use FontScript. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.

FONT_SCRIPT

 

 

NUMBER_FORMAT

 

 

HORIZONTAL_ALIGNMENT

 

 

VERTICAL_ALIGNMENT

 

 

INDENT

 

 

ROTATION

 

 

WRAP_TEXT

 

 

SHRINK_TO_FIT

 

 

TEXT_DIRECTION

 

 

CELL_SHADING

 

 

PATTERN

 

 

FOREGROUND_COLOR

 

 

BACKGROUND_COLOR

 

 

LOCKED

 

 

HIDE_FORMULA

 

 

ALIGNMENT_SETTINGS

 

 

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

PROTECTION_SETTINGS

 

 

Includes Locked, HideFormula

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.

RELATIVE_INDENT

 

 

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

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.

GENERAL

 

 

Represents general 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

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

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

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

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

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.

VISIBLE

 

 

Indicates the sheet is visible.

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.