Globals
Properties
- AccessCacheOptions
- AdjustFontSizeForRowType
- AutoFillType
- AutoFitMergedCellsType
- AutoFitWrappedTextType
- AutoShapeType
- AxisType
- BackgroundMode
- BackgroundType
- Bar3DShapeType
- BevelPresetType
- BevelType
- BorderType
- BubbleSizeRepresents
- BuiltinStyleType
- BulletType
- CalcModeType
- CalculationPrecisionStrategy
- CategoryType
- CellBorderType
- CellValueFormatStrategy
- CellValueType
- CellsUnitType
- ChartLineFormattingType
- ChartMarkerType
- ChartSplitType
- ChartTextDirectionType
- ChartType
- CheckValueType
- ColorDepth
- ColorType
- CommentTitleType
- ConsolidationFunction
- ControlBorderType
- ControlCaptionAlignmentType
- ControlListStyle
- ControlMatchEntryType
- ControlMousePointerType
- ControlPictureAlignmentType
- ControlPicturePositionType
- ControlPictureSizeMode
- ControlScrollBarType
- ControlScrollOrientation
- ControlSpecialEffectType
- ControlType
- CopyFormatType
- CountryCode
- CredentialsMethodType
- CrossType
- DataBarAxisPosition
- DataBarBorderType
- DataBarFillType
- DataBarNegativeColorType
- DataLabelShapeType
- DataLabelsSeparatorType
- DateTimeGroupingType
- DefaultEditLanguage
- DirectoryType
- DisplayDrawingObjects
- DisplayUnitType
- DropButtonStyle
- DynamicFilterType
- EmfRenderSetting
- EncryptionType
- EquationCharacterPositionType
- EquationCombiningCharacterType
- EquationDelimiterShapeType
- EquationFractionType
- EquationHorizontalJustificationType
- EquationLimitLocationType
- EquationMathematicalOperatorType
- EquationNodeType
- EquationVerticalJustificationType
- ErrorBarDisplayType
- ErrorBarType
- ErrorCheckType
- ExceptionType
- ExternalLinkType
- FileFormatType
- FillPattern
- FillPictureType
- FillType
- FilterOperatorType
- FilterType
- FontSchemeType
- FontSourceType
- FontUnderlineType
- FormatConditionType
- FormatConditionValueType
- FormatSetType
- FormattingType
- GradientColorType
- GradientDirectionType
- GradientFillType
- GradientPresetType
- GradientStyleType
- GridlineType
- HeaderFooterCommandType
- HtmlCrossType
- HtmlExportDataOptions
- HtmlFormatHandlingType
- HtmlHiddenColDisplayType
- HtmlHiddenRowDisplayType
- HtmlLinkTargetType
- IconSetType
- ImageBinarizationMethod
- ImageType
- InputMethodEditorMode
- JsonExportHyperlinkType
- LabelPositionType
- LegendPositionType
- LightRigDirectionType
- LightRigType
- LineCapType
- LineJoinType
- LineSpaceSizeType
- LineType
- LoadDataFilterOptions
- LoadFormat
- LoadNumbersTableType
- LookAtType
- LookInType
- MapChartLabelLayout
- MapChartProjectionType
- MapChartRegionType
- MemorySetting
- MergeEmptyTdType
- MetadataType
- MirrorType
- MsoArrowheadLength
- MsoArrowheadStyle
- MsoArrowheadWidth
- MsoDrawingType
- MsoLineDashStyle
- MsoLineStyle
- MsoPresetTextEffect
- MsoPresetTextEffectShape
- NameScopeType
- NumberCategoryType
- OLEDBCommandType
- OdsCellFieldType
- OdsGeneratorType
- OdsPageBackgroundGraphicPositionType
- OdsPageBackgroundGraphicType
- OdsPageBackgroundType
- OoxmlCompliance
- OoxmlCompressionType
- OpenDocumentFormatVersionType
- OperatorType
- PageLayoutAlignmentType
- PageOrientationType
- PaneStateType
- PaperSizeType
- ParameterType
- PasteOperationType
- PasteType
- PdfCompliance
- PdfCompressionCore
- PdfCustomPropertiesExport
- PdfFontEncoding
- PdfOptimizationType
- PivotAreaType
- PivotConditionFormatRuleType
- PivotConditionFormatScopeType
- PivotFieldDataDisplayFormat
- PivotFieldGroupType
- PivotFieldSubtotalType
- PivotFieldType
- PivotFilterType
- PivotGroupByType
- PivotItemPosition
- PivotItemPositionType
- PivotMissingItemLimitType
- PivotTableAutoFormatType
- PivotTableSelectionType
- PivotTableStyleType
- PlacementType
- PlotDataByType
- PlotEmptyCellsType
- PresetCameraType
- PresetMaterialType
- PresetShadowType
- PresetThemeGradientType
- PresetWordArtStyle
- PrintCommentsType
- PrintErrorsType
- PrintOrderType
- PrintSizeType
- PrintingPageType
- PropertyType
- ProtectionType
- QuartileCalculationType
- ReConnectionMethodType
- RectangleAlignmentType
- ReflectionEffectType
- RenameStrategy
- ReserveMissingPivotItemType
- ResourceLoadingType
- RevisionActionType
- RevisionType
- SaveFormat
- SelectionType
- ShapeAnchorType
- ShapeLockType
- ShapePathType
- SheetType
- ShiftType
- ShowDropButtonType
- SlicerCacheCrossFilterType
- SlicerCacheItemSortType
- SlicerStyleType
- SlideViewType
- SmartTagShowType
- SortOnType
- SortOrder
- SparklineAxisMinMaxType
- SparklinePresetStyleType
- SparklineType
- SqlDataType
- SqlScriptOperatorType
- StyleModifyFlag
- TableDataSourceType
- TableStyleElementType
- TableStyleType
- TargetModeType
- TextAlignmentType
- TextAutonumberScheme
- TextCapsType
- TextCrossType
- TextDirectionType
- TextFontAlignType
- TextNodeType
- TextOrientationType
- TextOverflowType
- TextStrikeType
- TextTabAlignmentType
- TextVerticalType
- TextureType
- ThemeColorType
- TickLabelAlignmentType
- TickLabelPositionType
- TickMarkType
- TiffCompression
- TimePeriodType
- TimeUnit
- TotalsCalculation
- TrendlineType
- TxtLoadStyleStrategy
- TxtValueQuoteType
- UpdateLinksType
- ValidationAlertType
- ValidationType
- VbaModuleType
- VbaProjectReferenceType
- ViewType
- VisibilityType
- WebExtensionStoreType
- WeightType
- XAdESType
Properties
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. |
AdjustFontSizeForRowType number
Utility class containing constants. Represents which kind of rows should be ajusted.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
No adjsut. |
EMPTY_ROWS |
|
|
If the row is empty, change font size to fit row height. |
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, |
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. |
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. |
AutoShapeType number
Utility class containing constants. Represents all built-in auto shape type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NOT_PRIMITIVE |
|
|
|
RECTANGLE |
|
|
|
ROUNDED_RECTANGLE |
|
|
|
OVAL |
|
|
|
DIAMOND |
|
|
|
ISOSCELES_TRIANGLE |
|
|
|
RIGHT_TRIANGLE |
|
|
|
PARALLELOGRAM |
|
|
|
TRAPEZOID |
|
|
|
HEXAGON |
|
|
|
OCTAGON |
|
|
|
CROSS |
|
|
|
STAR_5 |
|
|
|
RIGHT_ARROW |
|
|
|
HOME_PLATE |
|
|
|
CUBE |
|
|
|
BALLOON |
|
|
|
SEAL |
|
|
|
ARC |
|
|
|
LINE |
|
|
|
PLAQUE |
|
|
|
CAN |
|
|
|
DONUT |
|
|
|
TEXT_SIMPLE |
|
|
|
TEXT_OCTAGON |
|
|
|
TEXT_HEXAGON |
|
|
|
TEXT_CURVE |
|
|
|
TEXT_WAVE |
|
|
|
TEXT_RING |
|
|
|
TEXT_ON_CURVE |
|
|
|
MSOSPT_TEXT_ON_RING |
|
|
|
STRAIGHT_CONNECTOR |
|
|
|
BENT_CONNECTOR_2 |
|
|
|
ELBOW_CONNECTOR |
|
|
|
BENT_CONNECTOR_4 |
|
|
|
BENT_CONNECTOR_5 |
|
|
|
CURVED_CONNECTOR_2 |
|
|
|
CURVED_CONNECTOR |
|
|
|
CURVED_CONNECTOR_4 |
|
|
|
CURVED_CONNECTOR_5 |
|
|
|
LINE_CALLOUT_NO_BORDER_2 |
|
|
|
LINE_CALLOUT_NO_BORDER_3 |
|
|
|
LINE_CALLOUT_NO_BORDER_4 |
|
|
|
LINE_CALLOUT_WITH_ACCENT_BAR_2 |
|
|
|
LINE_CALLOUT_WITH_ACCENT_BAR_3 |
|
|
|
LINE_CALLOUT_WITH_ACCENT_BAR_4 |
|
|
|
LINE_CALLOUT_WITH_BORDER_2 |
|
|
|
LINE_CALLOUT_WITH_BORDER_3 |
|
|
|
LINE_CALLOUT_WITH_BORDER_4 |
|
|
|
LINE_CALLOUT_WITH_BORDER_AND_ACCENT_BAR_2 |
|
|
|
LINE_CALLOUT_WITH_BORDER_AND_ACCENT_BAR_3 |
|
|
|
LINE_CALLOUT_WITH_BORDER_AND_ACCENT_BAR_4 |
|
|
|
DOWN_RIBBON |
|
|
|
UP_RIBBON |
|
|
|
CHEVRON |
|
|
|
REGULAR_PENTAGON |
|
|
|
NO_SYMBOL |
|
|
|
STAR_8 |
|
|
|
STAR_16 |
|
|
|
STAR_32 |
|
|
|
RECTANGULAR_CALLOUT |
|
|
|
ROUNDED_RECTANGULAR_CALLOUT |
|
|
|
OVAL_CALLOUT |
|
|
|
WAVE |
|
|
|
FOLDED_CORNER |
|
|
|
LEFT_ARROW |
|
|
|
DOWN_ARROW |
|
|
|
UP_ARROW |
|
|
|
LEFT_RIGHT_ARROW |
|
|
|
UP_DOWN_ARROW |
|
|
|
EXPLOSION_1 |
|
|
|
EXPLOSION_2 |
|
|
|
LIGHTNING_BOLT |
|
|
|
HEART |
|
|
|
PICTURE_FRAME |
|
|
|
QUAD_ARROW |
|
|
|
LEFT_ARROW_CALLOUT |
|
|
|
RIGHT_ARROW_CALLOUT |
|
|
|
UP_ARROW_CALLOUT |
|
|
|
DOWN_ARROW_CALLOUT |
|
|
|
LEFT_RIGHT_ARROW_CALLOUT |
|
|
|
UP_DOWN_ARROW_CALLOUT |
|
|
|
QUAD_ARROW_CALLOUT |
|
|
|
BEVEL |
|
|
|
LEFT_BRACKET |
|
|
|
RIGHT_BRACKET |
|
|
|
LEFT_BRACE |
|
|
|
RIGHT_BRACE |
|
|
|
LEFT_UP_ARROW |
|
|
|
BENT_UP_ARROW |
|
|
|
BENT_ARROW |
|
|
|
STAR_24 |
|
|
|
STRIPED_RIGHT_ARROW |
|
|
|
NOTCHED_RIGHT_ARROW |
|
|
|
BLOCK_ARC |
|
|
|
SMILEY_FACE |
|
|
|
VERTICAL_SCROLL |
|
|
|
HORIZONTAL_SCROLL |
|
|
|
CIRCULAR_ARROW |
|
|
|
NOTCHED_CIRCULAR_ARROW |
|
|
A value that SHOULD NOT be used. |
U_TURN_ARROW |
|
|
|
CURVED_RIGHT_ARROW |
|
|
|
CURVED_LEFT_ARROW |
|
|
|
CURVED_UP_ARROW |
|
|
|
CURVED_DOWN_ARROW |
|
|
|
CLOUD_CALLOUT |
|
|
|
CURVED_DOWN_RIBBON |
|
|
|
CURVED_UP_RIBBON |
|
|
|
FLOW_CHART_PROCESS |
|
|
|
FLOW_CHART_DECISION |
|
|
|
FLOW_CHART_DATA |
|
|
|
FLOW_CHART_PREDEFINED_PROCESS |
|
|
|
FLOW_CHART_INTERNAL_STORAGE |
|
|
|
FLOW_CHART_DOCUMENT |
|
|
|
FLOW_CHART_MULTIDOCUMENT |
|
|
|
FLOW_CHART_TERMINATOR |
|
|
|
FLOW_CHART_PREPARATION |
|
|
|
FLOW_CHART_MANUAL_INPUT |
|
|
|
FLOW_CHART_MANUAL_OPERATION |
|
|
|
FLOW_CHART_CONNECTOR |
|
|
|
FLOW_CHART_CARD |
|
|
|
FLOW_CHART_PUNCHED_TAPE |
|
|
|
FLOW_CHART_SUMMING_JUNCTION |
|
|
|
FLOW_CHART_OR |
|
|
|
FLOW_CHART_COLLATE |
|
|
|
FLOW_CHART_SORT |
|
|
|
FLOW_CHART_EXTRACT |
|
|
|
FLOW_CHART_MERGE |
|
|
|
FLOW_CHART_OFFLINE_STORAGE |
|
|
|
FLOW_CHART_STORED_DATA |
|
|
|
FLOW_CHART_SEQUENTIAL_ACCESS_STORAGE |
|
|
|
FLOW_CHART_MAGNETIC_DISK |
|
|
|
FLOW_CHART_DIRECT_ACCESS_STORAGE |
|
|
|
FLOW_CHART_DISPLAY |
|
|
|
FLOW_CHART_DELAY |
|
|
|
TEXT_PLAIN_TEXT |
|
|
A plain text shape. |
TEXT_STOP |
|
|
An octagonal text shape. |
TEXT_TRIANGLE |
|
|
A triangular text shape pointing upwards. |
TEXT_TRIANGLE_INVERTED |
|
|
A triangular text shape pointing downwards. |
TEXT_CHEVRON |
|
|
A chevron text shape pointing upwards. |
TEXT_CHEVRON_INVERTED |
|
|
A chevron text shape pointing downwards. |
TEXT_RING_INSIDE |
|
|
A circular text shape, as if reading an inscription on the inside of a ring. |
TEXT_RING_OUTSIDE |
|
|
A circular text shape, as if reading an inscription on the outside of a ring. |
TEXT_ARCH_UP_CURVE |
|
|
An upward arching curved text shape. |
TEXT_ARCH_DOWN_CURVE |
|
|
A downward arching curved text shape. |
TEXT_CIRCLE_CURVE |
|
|
A circular text shape. |
TEXT_BUTTON_CURVE |
|
|
A text shape that resembles a button. |
TEXT_ARCH_UP_POUR |
|
|
An upward arching text shape. |
TEXT_ARCH_DOWN_POUR |
|
|
A downward arching text shape. |
TEXT_CIRCLE_POUR |
|
|
A circular text shape. |
TEXT_BUTTON_POUR |
|
|
A text shape that resembles a button. |
TEXT_CURVE_UP |
|
|
An upward curving text shape. |
TEXT_CURVE_DOWN |
|
|
A downward curving text shape. |
TEXT_CASCADE_UP |
|
|
A cascading text shape pointed upwards. |
TEXT_CASCADE_DOWN |
|
|
A cascading text shape pointed downwards. |
TEXT_WAVE_1 |
|
|
A wavy text shape. |
TEXT_WAVE_2 |
|
|
A wavy text shape. |
TEXT_DOUBLE_WAVE_1 |
|
|
A wavy text shape. |
TEXT_DOUBLE_WAVE_2 |
|
|
A wavy text shape. |
TEXT_INFLATE |
|
|
A text shape that expands vertically in the middle. |
TEXT_DEFLATE |
|
|
A text shape that shrinks vertically in the middle. |
TEXT_INFLATE_BOTTOM |
|
|
A text shape that expands downward in the middle. |
TEXT_DEFLATE_BOTTOM |
|
|
A text shape that shrinks upwards in the middle. |
TEXT_INFLATE_TOP |
|
|
A text shape that expands upward in the middle. |
TEXT_DEFLATE_TOP |
|
|
A text shape that shrinks downward in the middle. |
TEXT_DEFLATE_INFLATE |
|
|
A text shape where lower lines expand upward. Upper lines shrink to compensate. |
TEXT_DEFLATE_INFLATE_DEFLATE |
|
|
A text shape where lines in the center expand vertically. Upper and lower lines shrink to compensate. |
TEXT_FADE_RIGHT |
|
|
A text shape that shrinks vertically on the right side. |
TEXT_FADE_LEFT |
|
|
A text shape that shrinks vertically on the left side. |
TEXT_FADE_UP |
|
|
A text shape that shrinks horizontally on top. |
TEXT_FADE_DOWN |
|
|
A text shape that shrinks horizontally on bottom. |
TEXT_SLANT_UP |
|
|
An upward slanted text shape. |
TEXT_SLANT_DOWN |
|
|
A downward slanted text shape. |
TEXT_CAN_UP |
|
|
A text shape that is curved upwards as if being read on the side of a can. |
TEXT_CAN_DOWN |
|
|
A text shape that is curved downwards as if being read on the side of a can. |
FLOW_CHART_ALTERNATE_PROCESS |
|
|
|
FLOW_CHART_OFFPAGE_CONNECTOR |
|
|
|
LINE_CALLOUT_NO_BORDER_1 |
|
|
|
LINE_CALLOUT_WITH_ACCENT_BAR_1 |
|
|
|
LINE_CALLOUT_WITH_BORDER_1 |
|
|
|
LINE_CALLOUT_WITH_BORDER_AND_ACCENT_BAR_1 |
|
|
|
LEFT_RIGHT_UP_ARROW |
|
|
|
SUN |
|
|
|
MOON |
|
|
|
DOUBLE_BRACKET |
|
|
A shape enclosed in brackets. |
DOUBLE_BRACE |
|
|
A shape enclosed in braces. |
STAR_4 |
|
|
|
DOUBLE_WAVE |
|
|
|
BLANK_ACTION_BUTTON |
|
|
|
HOME_ACTION_BUTTON |
|
|
|
HELP_ACTION_BUTTON |
|
|
|
INFORMATION_ACTION_BUTTON |
|
|
|
FORWARD_NEXT_ACTION_BUTTON |
|
|
|
BACK_PREVIOUS_ACTION_BUTTON |
|
|
|
END_ACTION_BUTTON |
|
|
|
BEGINNING_ACTION_BUTTON |
|
|
|
RETURN_ACTION_BUTTON |
|
|
|
DOCUMENT_ACTION_BUTTON |
|
|
|
SOUND_ACTION_BUTTON |
|
|
|
MOVIE_ACTION_BUTTON |
|
|
|
HOST_CONTROL |
|
|
This value SHOULD NOT be used. |
TEXT_BOX |
|
|
|
HEPTAGON |
|
|
|
DECAGON |
|
|
|
DODECAGON |
|
|
|
STAR_6 |
|
|
|
STAR_7 |
|
|
|
STAR_10 |
|
|
|
STAR_12 |
|
|
|
ROUND_SINGLE_CORNER_RECTANGLE |
|
|
|
ROUND_SAME_SIDE_CORNER_RECTANGLE |
|
|
|
ROUND_DIAGONAL_CORNER_RECTANGLE |
|
|
|
SNIP_ROUND_SINGLE_CORNER_RECTANGLE |
|
|
|
SNIP_SINGLE_CORNER_RECTANGLE |
|
|
|
SNIP_SAME_SIDE_CORNER_RECTANGLE |
|
|
|
SNIP_DIAGONAL_CORNER_RECTANGLE |
|
|
|
TEARDROP |
|
|
|
PIE |
|
|
|
HALF_FRAME |
|
|
|
L_SHAPE |
|
|
|
DIAGONAL_STRIPE |
|
|
|
CHORD |
|
|
|
CLOUD |
|
|
|
MATH_PLUS |
|
|
|
MATH_MINUS |
|
|
|
MATH_MULTIPLY |
|
|
|
MATH_DIVIDE |
|
|
|
MATH_EQUAL |
|
|
|
MATH_NOT_EQUAL |
|
|
|
LINE_INV |
|
|
|
NON_ISOSCELES_TRAPEZOID |
|
|
|
PIE_WEDGE |
|
|
|
LEFT_CIRCULAR_ARROW |
|
|
|
LEFT_RIGHT_CIRCULAR_ARROW |
|
|
|
SWOOSH_ARROW |
|
|
|
LEFT_RIGHT_RIBBON |
|
|
|
TEXT_NO_SHAPE |
|
|
|
GEAR_6 |
|
|
|
GEAR_9 |
|
|
|
FUNNEL |
|
|
|
CORNER_TABS |
|
|
|
SQUARE_TABS |
|
|
|
PLAQUE_TABS |
|
|
|
CHART_X |
|
|
|
CHART_STAR |
|
|
|
CHART_PLUS |
|
|
|
FRAME |
|
|
|
MODEL_3_D |
|
|
|
ROUND_CALLOUT |
|
|
There is no such type in Excel |
TEXT_ARCH_LEFT_POUR |
|
|
There is no such type in Excel |
TEXT_ARCH_RIGHT_POUR |
|
|
There is no such type in Excel |
TEXT_ARCH_LEFT_CURVE |
|
|
There is no such type in Excel |
TEXT_ARCH_RIGHT_CURVE |
|
|
There is no such type in Excel |
UNKNOWN |
|
|
AxisType number
Utility class containing constants. Represents the axis type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CATEGORY |
|
|
Category axis |
VALUE |
|
|
Value axis |
SERIES |
|
|
Series axis |
BackgroundMode number
Utility class containing constants. Represents the display mode of the background.
Properties
Name | Type | Optional | Description |
---|---|---|---|
AUTOMATIC |
|
|
Automatic |
OPAQUE |
|
|
Opaque |
TRANSPARENT |
|
|
Transparent |
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. |
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 |
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 |
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 |
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. |
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. |
BuiltinStyleType number
Utility class containing constants. Represents all built-in style types.
Properties
Name | Type | Optional | Description |
---|---|---|---|
TWENTY_PERCENT_ACCENT_1 |
|
|
|
TWENTY_PERCENT_ACCENT_2 |
|
|
|
TWENTY_PERCENT_ACCENT_3 |
|
|
|
TWENTY_PERCENT_ACCENT_4 |
|
|
|
TWENTY_PERCENT_ACCENT_5 |
|
|
|
TWENTY_PERCENT_ACCENT_6 |
|
|
|
FORTY_PERCENT_ACCENT_1 |
|
|
|
FORTY_PERCENT_ACCENT_2 |
|
|
|
FORTY_PERCENT_ACCENT_3 |
|
|
|
FORTY_PERCENT_ACCENT_4 |
|
|
|
FORTY_PERCENT_ACCENT_5 |
|
|
|
FORTY_PERCENT_ACCENT_6 |
|
|
|
SIXTY_PERCENT_ACCENT_1 |
|
|
|
SIXTY_PERCENT_ACCENT_2 |
|
|
|
SIXTY_PERCENT_ACCENT_3 |
|
|
|
SIXTY_PERCENT_ACCENT_4 |
|
|
|
SIXTY_PERCENT_ACCENT_5 |
|
|
|
SIXTY_PERCENT_ACCENT_6 |
|
|
|
ACCENT_1 |
|
|
|
ACCENT_2 |
|
|
|
ACCENT_3 |
|
|
|
ACCENT_4 |
|
|
|
ACCENT_5 |
|
|
|
ACCENT_6 |
|
|
|
BAD |
|
|
|
CALCULATION |
|
|
|
CHECK_CELL |
|
|
|
COMMA |
|
|
|
COMMA_1 |
|
|
|
CURRENCY |
|
|
|
CURRENCY_1 |
|
|
|
EXPLANATORY_TEXT |
|
|
|
GOOD |
|
|
|
HEADER_1 |
|
|
|
HEADER_2 |
|
|
|
HEADER_3 |
|
|
|
HEADER_4 |
|
|
|
HYPERLINK |
|
|
|
FOLLOWED_HYPERLINK |
|
|
|
INPUT |
|
|
|
LINKED_CELL |
|
|
|
NEUTRAL |
|
|
|
NORMAL |
|
|
|
NOTE |
|
|
|
OUTPUT |
|
|
|
PERCENT |
|
|
|
TITLE |
|
|
|
TOTAL |
|
|
|
WARNING_TEXT |
|
|
|
ROW_LEVEL |
|
|
|
COLUMN_LEVEL |
|
|
BulletType number
Utility class containing constants. Represents the type of the bullet.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
No bullet. |
CHARACTER |
|
|
Character bullet. |
PICTURE |
|
|
Image bullet. |
AUTO_NUMBERED |
|
|
Automatic numbered bullet. |
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 |
|
|
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. |
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 |
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. |
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. |
CellValueType number
Utility class containing constants. Specifies a cell value type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
IS_UNKNOWN |
|
|
Cell value type is unknown. |
IS_NULL |
|
|
Blank cell. Corresponding value should be null. |
IS_NUMERIC |
|
|
Cell value is numeric. Corresponding value must be int or double. |
IS_DATE_TIME |
|
|
Cell value is datetime. Corresponding value must be DateTime. |
IS_STRING |
|
|
Cell value is string. Corresponding value must be string. |
IS_BOOL |
|
|
Cell value is boolean. Corresponding value must be bool. |
IS_ERROR |
|
|
Cell contains error value. Corresponding value must be error string. |
CellsUnitType number
Utility class containing constants. Specifies the unit of measurement.
Properties
Name | Type | Optional | Description |
---|---|---|---|
PIXEL |
|
|
Measurement is in pixels. |
POINT |
|
|
Measurement is in points. A point represents 1/72 of an inch. |
INCH |
|
|
Measurement is in inches. |
CM |
|
|
Measurement is in centimeters. |
CHARACTER |
|
|
In unit of characters. Only for width. |
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 |
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 |
ChartSplitType number
Utility class containing constants. Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.
Properties
Name | Type | Optional | Description |
---|---|---|---|
POSITION |
|
|
Represents the data points shall be split between the pie and the second chart by putting the last Split Position of the data points in the second chart |
VALUE |
|
|
Represents the data points shall be split between the pie and the second chart by putting the data points with value less than Split Position in the second chart. |
PERCENT_VALUE |
|
|
Represents the data points shall be split between the pie and the second chart by putting the points with percentage less than Split Position percent in the second chart. |
CUSTOM |
|
|
Represents the data points shall be split between the pie and the second chart according to the Custom Split values. |
AUTO |
|
|
Represents the data points shall be split using the default mechanism for this chart type. NOTE: This member is now obsolete. Instead, please use Series.IsAutoSplit property. This property will be removed 12 months later since September 2023. Aspose apologizes for any inconvenience you may have experienced. |
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. |
ChartType number
Utility class containing constants. Enumerates all chart types used in Excel.
Properties
Name | Type | Optional | Description |
---|---|---|---|
AREA |
|
|
Represents Area Chart. |
AREA_STACKED |
|
|
Represents Stacked Area Chart. |
AREA_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Area Chart. |
AREA_3_D |
|
|
Represents 3D Area Chart. |
AREA_3_D_STACKED |
|
|
Represents 3D Stacked Area Chart. |
AREA_3_D_100_PERCENT_STACKED |
|
|
Represents 3D 100% Stacked Area Chart. |
BAR |
|
|
Represents Bar Chart: Clustered Bar Chart. |
BAR_STACKED |
|
|
Represents Stacked Bar Chart. |
BAR_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Bar Chart. |
BAR_3_D_CLUSTERED |
|
|
Represents 3D Clustered Bar Chart. |
BAR_3_D_STACKED |
|
|
Represents 3D Stacked Bar Chart. |
BAR_3_D_100_PERCENT_STACKED |
|
|
Represents 3D 100% Stacked Bar Chart. |
BUBBLE |
|
|
Represents Bubble Chart. |
BUBBLE_3_D |
|
|
Represents 3D Bubble Chart. |
COLUMN |
|
|
Represents Column Chart: Clustered Column Chart. |
COLUMN_STACKED |
|
|
Represents Stacked Column Chart. |
COLUMN_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Column Chart. |
COLUMN_3_D |
|
|
Represents 3D Column Chart. |
COLUMN_3_D_CLUSTERED |
|
|
Represents 3D Clustered Column Chart. |
COLUMN_3_D_STACKED |
|
|
Represents 3D Stacked Column Chart. |
COLUMN_3_D_100_PERCENT_STACKED |
|
|
Represents 3D 100% Stacked Column Chart. |
CONE |
|
|
Represents Cone Chart. |
CONE_STACKED |
|
|
Represents Stacked Cone Chart. |
CONE_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Cone Chart. |
CONICAL_BAR |
|
|
Represents Conical Bar Chart. |
CONICAL_BAR_STACKED |
|
|
Represents Stacked Conical Bar Chart. |
CONICAL_BAR_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Conical Bar Chart. |
CONICAL_COLUMN_3_D |
|
|
Represents 3D Conical Column Chart. |
CYLINDER |
|
|
Represents Cylinder Chart. |
CYLINDER_STACKED |
|
|
Represents Stacked Cylinder Chart. |
CYLINDER_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Cylinder Chart. |
CYLINDRICAL_BAR |
|
|
Represents Cylindrical Bar Chart. |
CYLINDRICAL_BAR_STACKED |
|
|
Represents Stacked Cylindrical Bar Chart. |
CYLINDRICAL_BAR_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Cylindrical Bar Chart. |
CYLINDRICAL_COLUMN_3_D |
|
|
Represents 3D Cylindrical Column Chart. |
DOUGHNUT |
|
|
Represents Doughnut Chart. |
DOUGHNUT_EXPLODED |
|
|
Represents Exploded Doughnut Chart. |
LINE |
|
|
Represents Line Chart. |
LINE_STACKED |
|
|
Represents Stacked Line Chart. |
LINE_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Line Chart. |
LINE_WITH_DATA_MARKERS |
|
|
Represents Line Chart with data markers. |
LINE_STACKED_WITH_DATA_MARKERS |
|
|
Represents Stacked Line Chart with data markers. |
LINE_100_PERCENT_STACKED_WITH_DATA_MARKERS |
|
|
Represents 100% Stacked Line Chart with data markers. |
LINE_3_D |
|
|
Represents 3D Line Chart. |
PIE |
|
|
Represents Pie Chart. |
PIE_3_D |
|
|
Represents 3D Pie Chart. |
PIE_PIE |
|
|
Represents Pie of Pie Chart. |
PIE_EXPLODED |
|
|
Represents Exploded Pie Chart. |
PIE_3_D_EXPLODED |
|
|
Represents 3D Exploded Pie Chart. |
PIE_BAR |
|
|
Represents Bar of Pie Chart. |
PYRAMID |
|
|
Represents Pyramid Chart. |
PYRAMID_STACKED |
|
|
Represents Stacked Pyramid Chart. |
PYRAMID_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Pyramid Chart. |
PYRAMID_BAR |
|
|
Represents Pyramid Bar Chart. |
PYRAMID_BAR_STACKED |
|
|
Represents Stacked Pyramid Bar Chart. |
PYRAMID_BAR_100_PERCENT_STACKED |
|
|
Represents 100% Stacked Pyramid Bar Chart. |
PYRAMID_COLUMN_3_D |
|
|
Represents 3D Pyramid Column Chart. |
RADAR |
|
|
Represents Radar Chart. |
RADAR_WITH_DATA_MARKERS |
|
|
Represents Radar Chart with data markers. |
RADAR_FILLED |
|
|
Represents Filled Radar Chart. |
SCATTER |
|
|
Represents Scatter Chart. |
SCATTER_CONNECTED_BY_CURVES_WITH_DATA_MARKER |
|
|
Represents Scatter Chart connected by curves, with data markers. |
SCATTER_CONNECTED_BY_CURVES_WITHOUT_DATA_MARKER |
|
|
Represents Scatter Chart connected by curves, without data markers. |
SCATTER_CONNECTED_BY_LINES_WITH_DATA_MARKER |
|
|
Represents Scatter Chart connected by lines, with data markers. |
SCATTER_CONNECTED_BY_LINES_WITHOUT_DATA_MARKER |
|
|
Represents Scatter Chart connected by lines, without data markers. |
STOCK_HIGH_LOW_CLOSE |
|
|
Represents High-Low-Close Stock Chart. |
STOCK_OPEN_HIGH_LOW_CLOSE |
|
|
Represents Open-High-Low-Close Stock Chart. |
STOCK_VOLUME_HIGH_LOW_CLOSE |
|
|
Represents Volume-High-Low-Close Stock Chart. |
STOCK_VOLUME_OPEN_HIGH_LOW_CLOSE |
|
|
Represents Volume-Open-High-Low-Close Stock Chart. |
SURFACE_3_D |
|
|
Represents Surface Chart: 3D Surface Chart. |
SURFACE_WIREFRAME_3_D |
|
|
Represents Wireframe 3D Surface Chart. |
SURFACE_CONTOUR |
|
|
Represents Contour Chart. |
SURFACE_CONTOUR_WIREFRAME |
|
|
Represents Wireframe Contour Chart. |
BOX_WHISKER |
|
|
The series is laid out as box and whisker. |
FUNNEL |
|
|
The series is laid out as a funnel. |
PARETO_LINE |
|
|
The series is laid out as pareto lines. |
SUNBURST |
|
|
The series is laid out as a sunburst. |
TREEMAP |
|
|
The series is laid out as a treemap. |
WATERFALL |
|
|
The series is laid out as a waterfall. |
HISTOGRAM |
|
|
The series is laid out as a histogram. |
MAP |
|
|
The series is laid out as a region map. |
RADIAL_HISTOGRAM |
|
|
The series is laid out as a radial historgram. It is used only for rendering |
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 |
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 |
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. |
CommentTitleType number
Utility class containing constants. Represents comment title type while rendering when comment is set to display at end of sheet.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CELL |
|
|
Represents comment title cell. |
COMMENT |
|
|
Represents comment title comment. |
NOTE |
|
|
Represents comment title note. |
REPLY |
|
|
Represents comment title reply. |
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. |
ControlBorderType number
Utility class containing constants. Represents the border type of the ActiveX control.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
No border. |
SINGLE |
|
|
The single line. |
ControlCaptionAlignmentType number
Utility class containing constants. Represents the position of the Caption relative to the control.
Properties
Name | Type | Optional | Description |
---|---|---|---|
LEFT |
|
|
The left of the control. |
RIGHT |
|
|
The right of the control. |
ControlListStyle number
Utility class containing constants. Represents the visual appearance of the list in a ListBox or ComboBox.
Properties
Name | Type | Optional | Description |
---|---|---|---|
PLAIN |
|
|
Displays a list in which the background of an item is highlighted when it is selected. |
OPTION |
|
|
Displays a list in which an option button or a checkbox next to each entry displays the selection state of that item. |
ControlMatchEntryType number
Utility class containing constants. Represents how a ListBox or ComboBox searches its list as the user types.
Properties
Name | Type | Optional | Description |
---|---|---|---|
FIRST_LETTER |
|
|
The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter. |
COMPLETE |
|
|
As each character is typed, the control searches for an entry matching all characters entered. |
NONE |
|
|
The list will not be searched when characters are typed. |
ControlMousePointerType number
Utility class containing constants. Represents the type of icon displayed as the mouse pointer for the control.
Properties
Name | Type | Optional | Description |
---|---|---|---|
DEFAULT |
|
|
Standard pointer. |
ARROW |
|
|
Arrow. |
CROSS |
|
|
Cross-hair pointer. |
I_BEAM |
|
|
I-beam. |
SIZE_NESW |
|
|
Double arrow pointing northeast and southwest. |
SIZE_NS |
|
|
Double arrow pointing north and south. |
SIZE_NWSE |
|
|
Double arrow pointing northwest and southeast. |
SIZE_WE |
|
|
Double arrow pointing west and east. |
UP_ARROW |
|
|
Up arrow. |
HOUR_GLASS |
|
|
Hourglass. |
NO_DROP |
|
|
"Not” symbol (circle with a diagonal line) on top of the object being dragged. |
APP_STARTING |
|
|
Arrow with an hourglass. |
HELP |
|
|
Arrow with a question mark. |
SIZE_ALL |
|
|
"Size-all” cursor (arrows pointing north, south, east, and west). |
CUSTOM |
|
|
Uses the icon specified by the MouseIcon property. |
ControlPictureAlignmentType number
Utility class containing constants. Represents the alignment of the picture inside the Form or Image.
Properties
Name | Type | Optional | Description |
---|---|---|---|
TOP_LEFT |
|
|
The top left corner. |
TOP_RIGHT |
|
|
The top right corner. |
CENTER |
|
|
The center. |
BOTTOM_LEFT |
|
|
The bottom left corner. |
BOTTOM_RIGHT |
|
|
The bottom right corner. |
ControlPicturePositionType number
Utility class containing constants. Represents the location of the control's picture relative to its caption.
Properties
Name | Type | Optional | Description |
---|---|---|---|
LEFT_TOP |
|
|
The picture appears to the left of the caption. The caption is aligned with the top of the picture. |
LEFT_CENTER |
|
|
The picture appears to the left of the caption. The caption is centered relative to the picture. |
LEFT_BOTTOM |
|
|
The picture appears to the left of the caption. The caption is aligned with the bottom of the picture. |
RIGHT_TOP |
|
|
The picture appears to the right of the caption. The caption is aligned with the top of the picture. |
RIGHT_CENTER |
|
|
The picture appears to the right of the caption. The caption is centered relative to the picture. |
RIGHT_BOTTOM |
|
|
The picture appears to the right of the caption. The caption is aligned with the bottom of the picture. |
ABOVE_LEFT |
|
|
The picture appears above the caption. The caption is aligned with the left edge of the picture. |
ABOVE_CENTER |
|
|
The picture appears above the caption. The caption is centered below the picture. |
ABOVE_RIGHT |
|
|
The picture appears above the caption. The caption is aligned with the right edge of the picture. |
BELOW_LEFT |
|
|
The picture appears below the caption. The caption is aligned with the left edge of the picture. |
BELOW_CENTER |
|
|
The picture appears below the caption. The caption is centered above the picture. |
BELOW_RIGHT |
|
|
The picture appears below the caption. The caption is aligned with the right edge of the picture. |
CENTER |
|
|
The picture appears in the center of the control. The caption is centered horizontally and vertically on top of the picture. |
ControlPictureSizeMode number
Utility class containing constants. Represents how to display the picture.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CLIP |
|
|
Crops any part of the picture that is larger than the control's boundaries. |
STRETCH |
|
|
Stretches the picture to fill the control's area. This setting distorts the picture in either the horizontal or vertical direction. |
ZOOM |
|
|
Enlarges the picture, but does not distort the picture in either the horizontal or vertical direction. |
ControlScrollBarType number
Utility class containing constants. Represents the type of scroll bar.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
Displays no scroll bars. |
HORIZONTAL |
|
|
Displays a horizontal scroll bar. |
BARS_VERTICAL |
|
|
Displays a vertical scroll bar. |
BARS_BOTH |
|
|
Displays both a horizontal and a vertical scroll bar. |
ControlScrollOrientation number
Utility class containing constants. Represents type of scroll orientation
Properties
Name | Type | Optional | Description |
---|---|---|---|
AUTO |
|
|
Control is rendered horizontally when the control's width is greater than its height. Control is rendered vertically otherwise. |
VERTICAL |
|
|
Control is rendered vertically. |
HORIZONTAL |
|
|
Control is rendered horizontally. |
ControlSpecialEffectType number
Utility class containing constants. Represents the type of special effect.
Properties
Name | Type | Optional | Description |
---|---|---|---|
FLAT |
|
|
Flat |
RAISED |
|
|
Raised |
SUNKEN |
|
|
Sunken |
ETCHED |
|
|
Etched |
BUMP |
|
|
Bump |
ControlType number
Utility class containing constants. Represents all type of ActiveX control.
Properties
Name | Type | Optional | Description |
---|---|---|---|
COMMAND_BUTTON |
|
|
Button |
COMBO_BOX |
|
|
ComboBox |
CHECK_BOX |
|
|
CheckBox |
LIST_BOX |
|
|
ListBox |
TEXT_BOX |
|
|
TextBox |
SPIN_BUTTON |
|
|
Spinner |
RADIO_BUTTON |
|
|
RadioButton |
LABEL |
|
|
Label |
IMAGE |
|
|
Image |
TOGGLE_BUTTON |
|
|
ToggleButton |
SCROLL_BAR |
|
|
ScrollBar |
BAR_CODE |
|
|
ScrollBar Unsupported. |
UNKNOWN |
|
|
Unknown |
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. |
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 |
CredentialsMethodType number
Utility class containing constants. Specifies Credentials method used for server access.
Properties
Name | Type | Optional | Description |
---|---|---|---|
INTEGRATED |
|
|
Integrated Authentication |
NONE |
|
|
No Credentials |
PROMPT |
|
|
Prompt Credentials |
STORED |
|
|
Stored Credentials |
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. |
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. |
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. |
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. |
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. |
DataLabelShapeType number
Utility class containing constants. Specifies the preset shape geometry that is to be used for a chart.
Properties
Name | Type | Optional | Description |
---|---|---|---|
RECT |
|
|
Represents the rectangle shape. |
ROUND_RECT |
|
|
Represents the round rectangle shape. |
ELLIPSE |
|
|
Represents the ellipse shape. |
RIGHT_ARROW_CALLOUT |
|
|
Represents the right arrow callout shape. |
DOWN_ARROW_CALLOUT |
|
|
Represents the down arrow callout shape. |
LEFT_ARROW_CALLOUT |
|
|
Represents the left arrow callout shape. |
UP_ARROW_CALLOUT |
|
|
Represents the up arrow callout shape. |
WEDGE_RECT_CALLOUT |
|
|
Represents the wedge rectangle callout shape. |
WEDGE_ROUND_RECT_CALLOUT |
|
|
Represents the wedge round rectangle callout shape. |
WEDGE_ELLIPSE_CALLOUT |
|
|
Represents the wedge ellipse callout shape. |
LINE_CALLOUT |
|
|
Represents the line callout shape. |
BENT_LINE_CALLOUT |
|
|
Represents the bent line callout shape. |
LINE_WITH_ACCENT_BAR_CALLOUT |
|
|
Represents the line with accent bar callout shape. |
BENT_LINE_WITH_ACCENT_BAR_CALLOUT |
|
|
Represents the bent line with accent bar callout shape. |
LINE |
|
|
This type is only used for special file processing |
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 |
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. |
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. |
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. |
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. |
DisplayUnitType number
Utility class containing constants. Represents the type of display unit of chart's axis.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
Display unit is None. |
HUNDREDS |
|
|
Specifies the values on the chart shall be divided by 100. |
THOUSANDS |
|
|
Specifies the values on the chart shall be divided by 1,000. |
TEN_THOUSANDS |
|
|
Specifies the values on the chart shall be divided by 10,000. |
HUNDRED_THOUSANDS |
|
|
Specifies the values on the chart shall be divided by 100,000. |
MILLIONS |
|
|
Specifies the values on the chart shall be divided by 1,000,000. |
TEN_MILLIONS |
|
|
Specifies the values on the chart shall be divided by 10,000,000. |
HUNDRED_MILLIONS |
|
|
Specifies the values on the chart shall be divided by 100,000,000. |
BILLIONS |
|
|
Specifies the values on the chart shall be divided by 1,000,000,000. |
TRILLIONS |
|
|
Specifies the values on the chart shall be divided by 1,000,000,000,000. |
PERCENTAGE |
|
|
The values on the chart shall be divided by 0.01. |
CUST |
|
|
specifies a custom value for the display unit. NOTE: This member is now obsolete. Instead, please use DisplayUnitType.Custom. This property will be removed 12 months later since January 2023. Aspose apologizes for any inconvenience you may have experienced. |
CUSTOM |
|
|
specifies a custom value for the display unit. |
DropButtonStyle number
Utility class containing constants. Represents the symbol displayed on the drop button.
Properties
Name | Type | Optional | Description |
---|---|---|---|
PLAIN |
|
|
Displays a button with no symbol. |
ARROW |
|
|
Displays a button with a down arrow. |
ELLIPSIS |
|
|
Displays a button with an ellipsis (...). |
REDUCE |
|
|
Displays a button with a horizontal line like an underscore character. |
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. |
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. |
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 |
|
|
XOR encryption algorithm. |
COMPATIBLE |
|
|
Office 97/2000 compatible. |
ENHANCED_CRYPTOGRAPHIC_PROVIDER_V_1 |
|
|
Enhanced encryption. |
STRONG_CRYPTOGRAPHIC_PROVIDER |
|
|
Strong encryption algorithm. |
EquationCharacterPositionType number
Utility class containing constants. Specifies the position of a particular subobject within its parent
Properties
Name | Type | Optional | Description |
---|---|---|---|
TOP |
|
|
At the top of the parent object |
BOTTOM |
|
|
At the bottom of the parent object |
EquationCombiningCharacterType number
Utility class containing constants. Type of combining characters.
Properties
Name | Type | Optional | Description |
---|---|---|---|
UNKNOWN |
|
|
Use unknown type when not found in existing type. |
DOT_ABOVE |
|
|
"̇" Unicode: u0307 Combining Dot Above |
DIAERESIS |
|
|
"̈" Unicode: u0308 Combining Diaeresis |
THREE_DOTS_ABOVE |
|
|
"⃛" Unicode: u20db Combining Three Dots Above |
CIRCUMFLEX_ACCENT |
|
|
"̂" Unicode: u0302 Combining Circumflex Accent |
CARON |
|
|
"̌" Unicode: u030c Combining Caron |
ACUTE_ACCENT |
|
|
"́" Unicode: u0301 Combining Acute Accent |
GRAVE_ACCENT |
|
|
"̀" Unicode: u0300 Combining Grave Accent |
BREVE |
|
|
"̆" Unicode: u0306 Combining Combining Breve |
TILDE |
|
|
"̃" Unicode: u0303 Combining Tilde |
OVERLINE |
|
|
"̅" Unicode: u0305 Combining Overline |
DOUBLE_OVERLINE |
|
|
"̿" Unicode: u033f Combining Double Overline |
TOP_CURLY_BRACKET |
|
|
"⏞" Unicode: u23de Combining Top Curly Bracket |
BOTTOM_CURLY_BRACKET |
|
|
"⏟" Unicode: u23df Combining Bottom Curly Bracket |
LEFT_ARROW_ABOVE |
|
|
"⃖" Unicode: u20d6 Combining Left Arrow Above |
RIGHT_ARROW_ABOVE |
|
|
"⃗" Unicode: u20d7 Combining Right Arrow Above |
LEFT_RIGHT_ARROW_ABOVE |
|
|
"⃡" Unicode: u20e1 Combining Left Right Arrow Above |
LEFT_HARPOON_ABOVE |
|
|
"⃐" Unicode: u20d0 Combining Left Harpoon Above |
RIGHT_HARPOON_ABOVE |
|
|
"⃑" Unicode: u20d1 Combining Right Harpoon Above |
LEFTWARDS_ARROW |
|
|
"←" Unicode: u2190 Leftwards Arrow |
RIGHTWARDS_ARROW |
|
|
"→" Unicode: u2192 Rightwards Arrow |
LEFT_RIGHT_ARROW |
|
|
"↔" Unicode: u2194 Left Right Arrow |
LEFTWARDS_DOUBLE_ARROW |
|
|
"⇐" Unicode: u21d0 Leftwards Double Arrow |
RIGHTWARDS_DOUBLE_ARROW |
|
|
"⇒" Unicode: u21d2 Rightwards Double Arrow |
LEFT_RIGHT_DOUBLE_ARROW |
|
|
"⇔" Unicode: u21d4 Left Right Double Arrow |
EquationDelimiterShapeType number
Utility class containing constants. This specifies the shape of delimiters in the delimiter object.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CENTERED |
|
|
The divider is centered around the entire height of its content. |
MATCH |
|
|
The divider is altered to exactly match their contents' height. |
EquationFractionType number
Utility class containing constants. This specifies the display style of the fraction bar.
Properties
Name | Type | Optional | Description |
---|---|---|---|
BAR |
|
|
This specifies that the numerator is above and the denominator below is separated by a bar in the middle. |
NO_BAR |
|
|
This specifies that the numerator is above and the denominator below is not separated by a bar in the middle. |
LINEAR |
|
|
This specifies that the numerator is on the left and the denominator is on the right, separated by a '/' in between. |
SKEWED |
|
|
This specifies that the numerator is on the upper left and the denominator is on the lower right, separated by a "/". |
EquationHorizontalJustificationType number
Utility class containing constants. This specifies the default horizontal justification of equations in the document.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CENTER |
|
|
Centered |
CENTER_GROUP |
|
|
Centered as Group |
LEFT |
|
|
Left Justified |
RIGHT |
|
|
Right Justified |
EquationLimitLocationType number
Utility class containing constants. Specifies the limit location on an operator.
Properties
Name | Type | Optional | Description |
---|---|---|---|
UND_OVR |
|
|
Specifies that the limit is centered above or below the operator. |
SUB_SUP |
|
|
Specifies that the limit is on the right side of the operator. |
EquationMathematicalOperatorType number
Utility class containing constants. Mathematical Operators Type
Properties
Name | Type | Optional | Description |
---|---|---|---|
UNKNOWN |
|
|
Use unknown type when not found in existing type. |
FOR_ALL |
|
|
"∀" Unicode:\u2200 |
COMPLEMENT |
|
|
"∁" Unicode:\u2201 |
PARTIAL_DIFFERENTIAL |
|
|
"∂" Unicode:\u2202 |
EXISTS |
|
|
"∃" Unicode:\u2203 |
NOT_EXISTS |
|
|
"∄" Unicode:\u2204 |
EMPTY_SET |
|
|
"∅" Unicode:\u2205 |
INCREMENT |
|
|
"∆" Unicode:\u2206 |
NABLA |
|
|
"∇" Unicode:\u2207 |
ELEMENT_OF |
|
|
"∈" Unicode:\u2208 |
NOT_AN_ELEMENT_OF |
|
|
"∉" Unicode:\u2209 |
SMALL_ELEMENT_OF |
|
|
"∊" Unicode:\u220a |
CONTAIN |
|
|
"∋" Unicode:\u220b |
NOT_CONTAIN |
|
|
"∌" Unicode:\u220c |
SMALL_CONTAIN |
|
|
"∍" Unicode:\u220d |
END_OF_PROOF |
|
|
"∎" Unicode:\u220e |
NARY_PRODUCT |
|
|
"∏" Unicode:\u220f |
NARY_COPRODUCT |
|
|
"∐" Unicode:\u2210 |
NARY_SUMMATION |
|
|
"∑" Unicode:\u2211 |
LOGICAL_AND |
|
|
"∧" Unicode:\u2227 |
LOGICAL_OR |
|
|
"∨" Unicode:\u2228 |
INTERSECTION |
|
|
"∩" Unicode:\u2229 |
UNION |
|
|
"∪" Unicode:\u222a |
INTEGRAL |
|
|
"∫" Unicode:\u222b |
DOUBLE_INTEGRAL |
|
|
"∬" Unicode:\u222c |
TRIPLE_INTEGRAL |
|
|
"∭" Unicode:\u222d |
CONTOUR_INTEGRAL |
|
|
"∮" Unicode:\u222e |
SURFACE_INTEGRAL |
|
|
"∯" Unicode:\u222f |
VOLUME_INTEGRAL |
|
|
"∰" Unicode:\u2230 |
CLOCKWISE |
|
|
"∱" Unicode:\u2231 |
CLOCKWISE_CONTOUR_INTEGRAL |
|
|
"∲" Unicode:\u2232 |
ANTICLOCKWISE_CONTOUR_INTEGRAL |
|
|
"∳" Unicode:\u2233 |
NARY_LOGICAL_AND |
|
|
"⋀" Unicode:\u22c0 |
NARY_LOGICAL_OR |
|
|
"⋁" Unicode:\u22c1 |
NARY_INTERSECTION |
|
|
"⋂" Unicode:\u22c2 |
NARY_UNION |
|
|
"⋃" Unicode:\u22c3 |
EquationNodeType number
Utility class containing constants. Equation node type. Notice: (1)[1-99] Currently there is only one node in the scope, and its enumeration value is 1. The node it specifies is used to store mathematical text. (2)[100-199] Indicates that the node is a component of some special function nodes. (3)[200-] Indicates that the node has some special functions(Usually with 'Equation' suffix. 'EquationParagraph' is a special case.).
Properties
Name | Type | Optional | Description |
---|---|---|---|
UN_KNOW |
|
|
UnKnow |
TEXT |
|
|
specifies a node that stores math text |
BASE |
|
|
Specifies a component of type 'Base' |
DENOMINATOR |
|
|
Specifies a component of type 'Denominator' |
NUMERATOR |
|
|
Specifies a component of type 'Numerator' |
FUNCTION_NAME |
|
|
Specifies a component of type 'FunctionName' |
SUBSCRIPT |
|
|
Specifies a component of type 'Subscript' |
SUPERSCRIPT |
|
|
Specifies a component of type 'Superscript' |
DEGREE |
|
|
Specifies a component of type 'Degree' |
MATRIX_ROW |
|
|
Specifies a component of type 'MatrixRow'.A single row of the matrix |
EQUATION_PARAGRAPH |
|
|
Specifies a mathematical paragraph(oMathPara). |
MATHEMATICAL_EQUATION |
|
|
Specifies an equation or mathematical expression(OMath). |
FRACTION_EQUATION |
|
|
Specifies fractional equation |
FUNCTION_EQUATION |
|
|
Specifies function equation |
DELIMITER_EQUATION |
|
|
Specifies delimiter equation |
NARY_EQUATION |
|
|
Specifies n-ary operator equation |
RADICAL_EQUATION |
|
|
Specifies the radical equation |
SUPERSCRIPT_EQUATION |
|
|
Specifies superscript equation |
SUBSCRIPT_EQUATION |
|
|
Specifies subscript equation |
SUB_SUP_EQUATION |
|
|
Specifies an equation with superscripts and subscripts to the right of the operands. |
PRE_SUB_SUP_EQUATION |
|
|
Specifies an equation with superscripts and subscripts to the left of the operands. |
ACCENT_EQUATION |
|
|
Specifies accent equation |
BAR_EQUATION |
|
|
Specifies bar equation |
BORDER_BOX_EQUATION |
|
|
Specifies border box equation |
BOX_EQUATION |
|
|
Specifies box equation |
GROUP_CHARACTER_EQUATION |
|
|
Specifies Group-Character equation |
MATRIX_EQUATION |
|
|
Specifies the Matrix equation, |
EquationVerticalJustificationType number
Utility class containing constants. This specifies the default vertical justification of equations in the document.
Properties
Name | Type | Optional | Description |
---|---|---|---|
TOP |
|
|
top |
CENTER |
|
|
center |
BOTTOM |
|
|
bottom |
ErrorBarDisplayType number
Utility class containing constants. Represents error bar display type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
BOTH |
|
|
Both |
MINUS |
|
|
Minus |
NONE |
|
|
None |
PLUS |
|
|
Plus |
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. |
ErrorCheckType number
Utility class containing constants. Represents all error check type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
EVALUATION_ERROR |
|
|
Ignore errors when cells contain formulas that result in an error. |
CALC |
|
|
NOTE: This member is now obsolete. Instead, please use ErrorCheckType.EvaluationError enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced. |
EMPTY_CELL_REF |
|
|
Ignore errors when formulas refer to empty cells. |
NUMBER_STORED_AS_TEXT |
|
|
Ignore errors when numbers are formatted as text or are preceded by an apostrophe |
TEXT_NUMBER |
|
|
Ignore errors when numbers are formatted as text or are preceded by an apostrophe NOTE: This member is now obsolete. Instead, please use ErrorCheckType.NumberStoredAsText enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced. |
INCONSIST_RANGE |
|
|
Ignore errors when formulas omit certain cells in a region. |
INCONSIST_FORMULA |
|
|
Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region. |
TWO_DIGIT_TEXT_YEAR |
|
|
Ignore errors when formulas contain text formatted cells with years represented as 2 digits. |
TEXT_DATE |
|
|
Ignore errors when formulas contain text formatted cells with years represented as 2 digits. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TwoDigitTextYear enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced. |
UNLOCKED_FORMULA |
|
|
Ignore errors when unlocked cells contain formulas. |
UNPROCTED_FORMULA |
|
|
Ignore errors when unlocked cells contain formulas. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.UnproctedFormula enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced. |
TABLE_DATA_VALIDATION |
|
|
Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified. |
VALIDATION |
|
|
Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified. NOTE: This member is now obsolete. Instead, please use ErrorCheckType.TableDataValidation enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced. |
CALCULATED_COLUMN |
|
|
Ignore errors when cells contain a value different from a calculated column formula. |
ExceptionType number
Utility class containing constants. Represents custom exception type code.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CHART |
|
|
Invalid chart setting. |
DATA_TYPE |
|
|
Invalid data type setting. |
DATA_VALIDATION |
|
|
Invalid data validation setting. |
CONDITIONAL_FORMATTING |
|
|
Invalid data validation setting. |
FILE_FORMAT |
|
|
Invalid file format. |
FORMULA |
|
|
Invalid formula. |
INVALID_DATA |
|
|
Invalid data. |
INVALID_OPERATOR |
|
|
Invalid operator. |
INCORRECT_PASSWORD |
|
|
Incorrect password. |
LICENSE |
|
|
License related errors. |
LIMITATION |
|
|
Out of MS Excel limitation error. |
PAGE_SETUP |
|
|
Invalid page setup setting. |
PIVOT_TABLE |
|
|
Invalid pivotTable setting. |
SHAPE |
|
|
Invalid drawing object setting. |
SPARKLINE |
|
|
Invalid sparkline object setting. |
SHEET_NAME |
|
|
Invalid worksheet name. |
SHEET_TYPE |
|
|
Invalid worksheet type. |
INTERRUPTED |
|
|
The process is interrupted. |
IO |
|
|
The file is invalid. |
PERMISSION |
|
|
Permission is required to open this file. |
UNSUPPORTED_FEATURE |
|
|
Unsupported feature. |
UNSUPPORTED_STREAM |
|
|
Unsupported stream to be opened. |
UNDISCLOSED_INFORMATION |
|
|
Files contains some undisclosed information. |
FILE_CORRUPTED |
|
|
File content is corrupted. |
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. |
FileFormatType number
Utility class containing constants. Represents the file format types.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CSV |
|
|
Comma-Separated Values(CSV) text file. |
XLSX |
|
|
Office Open XML SpreadsheetML file (macro-free). |
XLSM |
|
|
Office Open XML SpreadsheetML Macro-Enabled file. |
XLTX |
|
|
Office Open XML SpreadsheetML Template (macro-free). |
XLTM |
|
|
Office Open XML SpreadsheetML Macro-Enabled Template. |
XLAM |
|
|
Office Open XML SpreadsheetML addinMacro-Enabled file. |
TSV |
|
|
Tab-Separated Values(TSV) text file. |
TAB_DELIMITED |
|
|
Tab-Separated Values(TSV) text file, same with TSV. |
HTML |
|
|
HTML format. |
M_HTML |
|
|
MHTML (Web archive) format. |
ODS |
|
|
Open Document Sheet(ODS) file. |
EXCEL_97_TO_2003 |
|
|
Excel97-2003 spreadsheet file. |
SPREADSHEET_ML |
|
|
Excel 2003 XML Data file. |
XLSB |
|
|
The Excel Binary File Format (.xlsb) |
UNKNOWN |
|
|
Represents unrecognized format, cannot be loaded. |
|
|
|
PDF (Adobe Portable Document) format. |
XPS |
|
|
XPS (XML Paper Specification) format. |
TIFF |
|
|
Represents a TIFF file. |
SVG |
|
|
SVG file. |
EXCEL_95 |
|
|
Represents an Excel95 xls file. |
EXCEL_4 |
|
|
Represents an Excel4.0 xls file. The file format is not supported |
EXCEL_3 |
|
|
Represents an Excel3.0 xls file. The file format is not supported |
EXCEL_2 |
|
|
Represents an Excel2.1 xls file. The file format is not supported |
PPTX |
|
|
Represents a pptx file. The file format is not supported Only for detecting file type. |
DOCX |
|
|
Represents a docx file. The file format is not supported Only for detecting file type. |
DIF |
|
|
Data Interchange Format. |
DOC |
|
|
Represents a doc file. The file format is not supported Only for detecting file type. |
PPT |
|
|
Represents a ppt file. The file format is not supported Only for detecting file type. |
MAPI_MESSAGE |
|
|
Represents a email file. The file format is not supported Only for detecting file type. |
MS_EQUATION |
|
|
Represents the MS Equation 3.0 object. The file format is not supported Only for detecting file type. |
OLE_10_NATIVE |
|
|
Represents the embedded native object. The file format is not supported Only for detecting file type. |
VSD |
|
|
Represents MS Visio VSD binary format. The file format is not supported Only for detecting file type. |
VSDX |
|
|
Represents MS Visio 2013 VSDX file format. The file format is not supported Only for detecting file type. |
DOCM |
|
|
Represents a docm file. The file format is not supported Only for detecting file type. |
DOTX |
|
|
Represents a dotx file. The file format is not supported Only for detecting file type. |
DOTM |
|
|
Represents a dotm file. The file format is not supported Only for detecting file type. |
PPTM |
|
|
Represents a pptm file. The file format is not supported Only for detecting file type. |
POTX |
|
|
Represents a Potx file. The file format is not supported Only for detecting file type. |
POTM |
|
|
Represents a Potm file. The file format is not supported Only for detecting file type. |
PPSX |
|
|
Represents a ppsx file. The file format is not supported Only for detecting file type. |
PPSM |
|
|
Represents a ppsm file. The file format is not supported Only for detecting file type. |
OOXML |
|
|
Represents office open xml file(such as xlsx, docx,pptx, etc). The file format is not supported Only for detecting file type. If the office open xml file is encrypted, it could not be detected as xlsx ,docx, pptx,etc. |
ODT |
|
|
Represents an ODT file. The file format is not supported Only for detecting file type. |
ODP |
|
|
Represents a ODP file. The file format is not supported Only for detecting file type. |
ODF |
|
|
Represents an ODF file. The file format is not supported Only for detecting file type. |
ODG |
|
|
Represents an ODG file. The file format is not supported Only for detecting file type. |
XML |
|
|
Represents a simple xml file. The file format is not supported Only for detecting file type. |
XLT |
|
|
Excel97-2003 spreadsheet template. |
OTT |
|
|
Represents an OTT file. The file format is not supported Only for detecting file type. |
BMP |
|
|
Represents a BMP file. The file format is not supported Only for detecting file type. |
OTS |
|
|
Represents an ots file. |
NUMBERS |
|
|
Represents Numbers 9.0 file format by Apple Inc. NOTE: This member is now obsolete. Instead, please use NUMBERS_09 property. This property will be removed 6 months later since June 2023. Aspose apologizes for any inconvenience you may have experienced. |
NUMBERS_09 |
|
|
Represents Numbers 9.0 file format by Apple Inc. |
MARKDOWN |
|
|
Represents markdown document. |
GRAPH_CHART |
|
|
Represents embedded graph chart. |
FODS |
|
|
Represents OpenDocument Flat XML Spreadsheet (.fods) file format. |
SXC |
|
|
Represents StarOffice Calc Spreadsheet (.sxc) file format. |
OTP |
|
|
Represents a OTP file. The file format is not supported. Only for detecting file type. |
NUMBERS_35 |
|
|
Represents Numbers 3.5 file format since 2014 by Apple Inc |
EMF |
|
|
Windows Enhanced Metafile. |
WMF |
|
|
Windows Metafile. |
JPG |
|
|
JPEG JFIF. |
PNG |
|
|
Portable Network Graphics. |
GIF |
|
|
Gif |
WEB_P |
|
|
Webp |
JSON |
|
|
Json |
SQL_SCRIPT |
|
|
Sql |
X_HTML |
|
|
Rrepesents XHtml file. |
ONE_NOTE |
|
|
Rrepesents One Note file. The file format is not supported Only for detecting file type. |
MICROSOFT_CABINET |
|
|
Rrepesents Microsoft Cabinet file. The file format is not supported Only for detecting file type. |
RTF |
|
|
Rtf |
EPUB |
|
|
EPUB |
AZW_3 |
|
|
AZW3 |
OXPS |
|
|
OXPS (Open XML Paper Specification) format. |
G_ZIP |
|
|
Rrepesents GZip file. The file format is not supported Only for detecting file type. |
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. |
FillPictureType number
Utility class containing constants. Represents the picture fill type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
STRETCH |
|
|
Stretch |
STACK |
|
|
Stack |
STACK_AND_SCALE |
|
|
StackAndScale |
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. |
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. |
FilterType number
Utility class containing constants. The filter type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
COLOR_FILTER |
|
|
Filter by fill color of the cell. |
CUSTOM_FILTERS |
|
|
Custom filter type. |
DYNAMIC_FILTER |
|
|
Dynamic filter type. |
MULTIPLE_FILTERS |
|
|
When multiple values are chosen to filter by, or when a group of date values are chosen to filter by, this element groups those criteria together. |
ICON_FILTER |
|
|
Filter by icon of conditional formatting. |
TOP_10 |
|
|
Top 10 filter. |
NONE |
|
|
No filter. |
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. |
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. |
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 |
FormatConditionType number
Utility class containing constants. Conditional format rule type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CELL_VALUE |
|
|
This conditional formatting rule compares a cell value to a formula calculated result, using an operator. |
EXPRESSION |
|
|
This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted. |
TOP_10 |
|
|
This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified. |
UNIQUE_VALUES |
|
|
This conditional formatting rule highlights unique values in the range. |
DUPLICATE_VALUES |
|
|
This conditional formatting rule highlights duplicated values. |
CONTAINS_TEXT |
|
|
This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text. |
NOT_CONTAINS_TEXT |
|
|
This conditional formatting rule highlights cells that do not contain given text. Equivalent of using SEARCH() sheet function to determine whether the cell contains the text or not. |
BEGINS_WITH |
|
|
This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values. |
ENDS_WITH |
|
|
This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values. |
CONTAINS_BLANKS |
|
|
This conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank. |
NOT_CONTAINS_BLANKS |
|
|
This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank. |
CONTAINS_ERRORS |
|
|
This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error. |
NOT_CONTAINS_ERRORS |
|
|
This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error. |
TIME_PERIOD |
|
|
This conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated. For example, with a cell containing the value 38913 the conditional format shall be applied if the rule requires a value of 7/14/2006. |
ABOVE_AVERAGE |
|
|
This conditional formatting rule highlights cells that are above or below the average for all values in the range. |
COLOR_SCALE |
|
|
This conditional formatting rule creates a gradated color scale on the cells. |
DATA_BAR |
|
|
This conditional formatting rule displays a gradated data bar in the range of cells. |
ICON_SET |
|
|
This conditional formatting rule applies icons to cells according to their values. |
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. |
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. |
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. |
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 |
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 |
GradientFillType number
Utility class containing constants. Represents all Gradient fill type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
LINEAR |
|
|
Linear |
RADIAL |
|
|
Radial |
RECTANGLE |
|
|
Rectangle |
PATH |
|
|
Path |
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. |
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. |
GridlineType number
Utility class containing constants. Enumerates grid line Type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
DOTTED |
|
|
Represents dotted line. |
HAIR |
|
|
Represents hair line. |
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 |
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. |
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. |
HtmlFormatHandlingType number
Utility class containing constants. Specifies how to handle formatting from the HTML source
Properties
Name | Type | Optional | Description |
---|---|---|---|
ALL |
|
|
Transfer all HTML formatting into the worksheet along with data. |
NONE |
|
|
Bring data in as unformatted text (setting data types still occurs). |
RTF |
|
|
Translate HTML formatting to rich text formatting on the data brought into the worksheet. |
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. |
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. |
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 |
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. |
ImageBinarizationMethod number
Utility class containing constants. Specifies the method used to binarize image.
Properties
Name | Type | Optional | Description |
---|---|---|---|
THRESHOLD |
|
|
Specifies threshold method. |
FLOYD_STEINBERG_DITHERING |
|
|
Specifies dithering using Floyd-Steinberg error diffusion method. |
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 |
InputMethodEditorMode number
Utility class containing constants. Represents the default run-time mode of the Input Method Editor.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NO_CONTROL |
|
|
Does not control IME. |
ON |
|
|
IME on. |
OFF |
|
|
IME off. English mode. |
DISABLE |
|
|
IME off.User can't turn on IME by keyboard. |
HIRAGANA |
|
|
IME on with Full-width hiragana mode. |
KATAKANA |
|
|
IME on with Full-width katakana mode. |
KATAKANA_HALF |
|
|
IME on with Half-width katakana mode. |
ALPHA_FULL |
|
|
IME on with Full-width Alphanumeric mode. |
ALPHA |
|
|
IME on with Half-width Alphanumeric mode. |
HANGUL_FULL |
|
|
IME on with Full-width hangul mode. |
HANGUL |
|
|
IME on with Half-width hangul mode. |
HANZI_FULL |
|
|
IME on with Full-width hanzi mode. |
HANZI |
|
|
IME on with Half-width hanzi mode. |
JsonExportHyperlinkType number
Utility class containing constants. Represents type of exporting hyperlinks to json.
Properties
Name | Type | Optional | Description |
---|---|---|---|
DISPLAY_STRING |
|
|
Export display string |
ADDRESS |
|
|
Export url |
HTML_STRING |
|
|
Export as html string. |
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. |
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. |
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. |
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. |
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 |
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 |
LineSpaceSizeType number
Utility class containing constants. Represents the unit type of line space size.
Properties
Name | Type | Optional | Description |
---|---|---|---|
PERCENTAGE |
|
|
Represents in unit of a percentage of the text size. |
POINTS |
|
|
Represents in unit of points. |
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. |
LoadDataFilterOptions number
Utility class containing constants. Represents the options to filter data when loading workbook from template.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
Load nothing for sheet data NOTE: This member is now obsolete and please use Structure instead. This property will be removed 12 months later since December 2017. Aspose apologizes for any inconvenience you may have experienced. |
ALL |
|
|
Load all |
CELL_BLANK |
|
|
Load cells whose value is blank |
CELL_STRING |
|
|
Load cells whose value is string |
CELL_NUMERIC |
|
|
Load cells whose value is numeric(including datetime) |
CELL_ERROR |
|
|
Load cells whose value is error |
CELL_BOOL |
|
|
Load cells whose value is bool |
CELL_VALUE |
|
|
Load cells value(all value types) only |
FORMULA |
|
|
Load cell formulas. Generally defined Name objects(DefinedNames) also need to be loaded when loading formulas because they may be referenced by formulas. So Formula or CellData option should work with DefinedNames option together(Formula|DefinedNames or CellData|DefinedNames) for most scenarios. |
CELL_DATA |
|
|
Load cells data including values, formulas and formatting |
CHART |
|
|
Load charts |
SHAPE |
|
|
Load shapes NOTE: This member is now obsolete and please use Drawing instead. This property will be removed 12 months later since November 2019. Aspose apologizes for any inconvenience you may have experienced. |
DRAWING |
|
|
Drawing objects(including Chart, Picture, OleObject and all other drawing objects) |
MERGED_AREA |
|
|
Load merged cells |
CONDITIONAL_FORMATTING |
|
|
Load conditional formatting |
DATA_VALIDATION |
|
|
Load data validations |
PIVOT_TABLE |
|
|
Load pivot tables |
TABLE |
|
|
Load tables |
HYPERLINKS |
|
|
Load hyperlinks |
SHEET_SETTINGS |
|
|
Load settings for worksheet |
SHEET_DATA |
|
|
Load all data of worksheet, such as cells data, settings, objects, ...etc. |
BOOK_SETTINGS |
|
|
Load settings for workbook |
SETTINGS |
|
|
Load settings for workbook and worksheet |
XML_MAP |
|
|
Load XmlMap |
STRUCTURE |
|
|
Load structure of the workbook |
DOCUMENT_PROPERTIES |
|
|
Load document properties |
DEFINED_NAMES |
|
|
Load defined Name objects |
VBA |
|
|
Load VBA projects |
STYLE |
|
|
Load styles for cell formatting |
PICTURE |
|
|
Load pictures |
OLE_OBJECT |
|
|
Load OleObjects |
REVISION |
|
|
Load revision logs |
LoadFormat number
Utility class containing constants. Represents the load file format.
Properties
Name | Type | Optional | Description |
---|---|---|---|
AUTO |
|
|
Represents recognizing the format automatically. |
CSV |
|
|
Comma-Separated Values(CSV) text file. |
XLSX |
|
|
Represents Office Open XML spreadsheetML workbook or template, with or without macros. |
TSV |
|
|
Tab-Separated Values(TSV) text file. |
TAB_DELIMITED |
|
|
Represents a tab delimited text file, same with TSV. |
HTML |
|
|
Represents a html file. |
M_HTML |
|
|
Represents a mhtml file. |
ODS |
|
|
Open Document Sheet(ODS) file. |
EXCEL_97_TO_2003 |
|
|
Represents an Excel97-2003 xls file. |
SPREADSHEET_ML |
|
|
Represents an Excel 2003 xml file. |
XLSB |
|
|
Represents an xlsb file. |
OTS |
|
|
Open Document Template Sheet(OTS) file. |
NUMBERS |
|
|
Represents a numbers file. |
FODS |
|
|
Represents OpenDocument Flat XML Spreadsheet (.fods) file format. |
SXC |
|
|
Represents StarOffice Calc Spreadsheet (.sxc) file format. |
XML |
|
|
Represents a simple xml file. |
EPUB |
|
|
Reprents an EPUB file. |
AZW_3 |
|
|
Represents an AZW3 file. |
UNKNOWN |
|
|
Represents unrecognized format, cannot be loaded. |
IMAGE |
|
|
Image |
JSON |
|
|
Json |
LoadNumbersTableType number
Utility class containing constants. Indicates type of loading tables when some tables are in a sheet.
Properties
Name | Type | Optional | Description |
---|---|---|---|
ONE_TABLE_PER_SHEET |
|
|
|
OVERRIDE_OTHER_TABLES |
|
|
|
TILE_TABLES |
|
|
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. |
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. |
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. |
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 |
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. |
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. |
MergeEmptyTdType number
Utility class containing constants. Represents the merge type for empty TD element when exporting file to html.
Properties
Name | Type | Optional | Description |
---|---|---|---|
DEFAULT |
|
|
Display like MS Excel. |
NONE |
|
|
Empty TD elements will not be merged when exporting file to html. This will generate a significantly larger html file. |
MERGE_FORCELY |
|
|
Merging empty TD element forcedly when exporting file to html. The size of html file will be reduced significantly after setting value to true. If you want to import the html file to excel or export perfect grid lines when saving file to html, please keep the default value. |
MetadataType number
Utility class containing constants. Represents the type of metadata.
Properties
Name | Type | Optional | Description |
---|---|---|---|
ENCRYPTION |
|
|
Encrypts the file. |
DECRYPTION |
|
|
Decrypts the file. |
DOCUMENT_PROPERTIES |
|
|
Load the properties of the file. |
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 |
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 |
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. |
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. |
MsoDrawingType number
Utility class containing constants. Represents office drawing objects type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
GROUP |
|
|
Group |
LINE |
|
|
Line |
RECTANGLE |
|
|
Rectangle |
OVAL |
|
|
Oval |
ARC |
|
|
Arc |
CHART |
|
|
Chart |
TEXT_BOX |
|
|
TextBox |
BUTTON |
|
|
Button |
PICTURE |
|
|
Picture |
POLYGON |
|
|
Polygon |
CHECK_BOX |
|
|
CheckBox |
RADIO_BUTTON |
|
|
RadioButton |
LABEL |
|
|
Label |
DIALOG_BOX |
|
|
DialogBox |
SPINNER |
|
|
Spinner |
SCROLL_BAR |
|
|
ScrollBar |
LIST_BOX |
|
|
ListBox |
GROUP_BOX |
|
|
GroupBox |
COMBO_BOX |
|
|
ComboBox |
COMMENT |
|
|
Comment |
OLE_OBJECT |
|
|
OleObject |
CELLS_DRAWING |
|
|
Only for preserving the drawing object in the template file. |
UNKNOWN |
|
|
Only for preserving the drawing object in the xlsx file. |
SLICER |
|
|
Slicer |
WEB_EXTENSION |
|
|
Web extension |
SMART_ART |
|
|
Smart Art |
CUSTOM_XML |
|
|
Custom xml shape ,such as Ink. |
TIMELINE |
|
|
Timeline |
MODEL_3_D |
|
|
3D Model |
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. |
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 |
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 |
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 |
NameScopeType number
Utility class containing constants. Represents the scope type of defined names.
Properties
Name | Type | Optional | Description |
---|---|---|---|
ALL |
|
|
All defined names. |
WORKBOOK |
|
|
The defined names in the workbook. |
WORKSHEET |
|
|
The defined names in a worksheet or all worksheets. |
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 |
OLEDBCommandType number
Utility class containing constants. Specifies the OLE DB command type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
The command type is not specified. |
CUBE_NAME |
|
|
Specifies a cube name unsupported |
SQL_STATEMENT |
|
|
Specifies a SQL statement |
TABLE_NAME |
|
|
Specifies a table name |
DEFAULT_INFORMATION |
|
|
Specifies that default information has been given, and it is up to the provider how to interpret. unsupported |
WEB_BASED_LIST |
|
|
Specifies a query which is against a web based List Data Provider. unsupported |
OdsCellFieldType number
Utility class containing constants. Represents the cell field type of ods.
Properties
Name | Type | Optional | Description |
---|---|---|---|
DATE |
|
|
Current date. |
SHEET_NAME |
|
|
The name of the sheet. |
TITLE |
|
|
The name of the file. |
OdsGeneratorType number
Utility class containing constants. Represents the type of ODS generator.
Properties
Name | Type | Optional | Description |
---|---|---|---|
LIBRE_OFFICE |
|
|
Libre Office |
OPEN_OFFICE |
|
|
Open Office |
OdsPageBackgroundGraphicPositionType number
Utility class containing constants. Represents the position.
Properties
Name | Type | Optional | Description |
---|---|---|---|
TOP_LEFT |
|
|
Top left. |
TOP_CENTER |
|
|
Top center. |
TOP_RIGHT |
|
|
Top right. |
CENTER_LEFT |
|
|
Center left. |
CENTER_CENTER |
|
|
Center. |
CENTER_RIGHT |
|
|
Center right. |
BOTTOM_LEFT |
|
|
Bottom left. |
BOTTOM_CENTER |
|
|
Bottom center. |
BOTTOM_RIGHT |
|
|
Bottom right. |
OdsPageBackgroundGraphicType number
Utility class containing constants. Represents the type of formatting page background with image.
Properties
Name | Type | Optional | Description |
---|---|---|---|
POSITION |
|
|
Set the image at specific position. |
AREA |
|
|
Stretch the image. |
TILE |
|
|
Repeat and repeat the image. |
OdsPageBackgroundType number
Utility class containing constants. Represents the page background type of ods.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
No background. |
COLOR |
|
|
Formats the background with color. |
GRAPHIC |
|
|
Formats the background with image. |
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. |
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. |
OpenDocumentFormatVersionType number
Utility class containing constants. Open Document Format version type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
None strict. There are some difference between Excel and ODF. In order to keep the data of Excel file, we can not follow the strict of ODF. |
ODF_11 |
|
|
ODF Version 1.1 |
ODF_12 |
|
|
ODF Version 1.2 |
ODF_13 |
|
|
ODF Version 1.3 |
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. |
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. |
PageOrientationType number
Utility class containing constants. Represents print orientation constants.
Properties
Name | Type | Optional | Description |
---|---|---|---|
LANDSCAPE |
|
|
Landscape orientation |
PORTRAIT |
|
|
Portrait orientation |
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. |
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. |
ParameterType number
Utility class containing constants. Represents all parameters' type or return value type of function.
Properties
Name | Type | Optional | Description |
---|---|---|---|
REFERENCE |
|
|
|
VALUE |
|
|
|
ARRAY |
|
|
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 |
PasteType number
Utility class containing constants. Represents the paste special type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
ALL |
|
|
Copies all data of the range. |
DEFAULT |
|
|
It works as "All" behavior of MS Excel. |
ALL_EXCEPT_BORDERS |
|
|
Copies all data of the range without the range. |
DEFAULT_EXCEPT_BORDERS |
|
|
It works as "All except borders" behavior of MS Excel. |
COLUMN_WIDTHS |
|
|
Only copies the widths of the range. |
ROW_HEIGHTS |
|
|
Only copies the heights of the range. |
COMMENTS |
|
|
|
FORMATS |
|
|
|
FORMULAS |
|
|
|
FORMULAS_AND_NUMBER_FORMATS |
|
|
|
VALIDATION |
|
|
|
VALUES |
|
|
|
VALUES_AND_FORMATS |
|
|
|
VALUES_AND_NUMBER_FORMATS |
|
|
PdfCompliance number
Utility class containing constants. Allowing user to set PDF conversion's Compatibility
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
Pdf format compatible with PDF 1.4 NOTE: This member is now obsolete. Instead, please use PDF_14 property. This property will be removed 6 months later since November 2023. Aspose apologizes for any inconvenience you may have experienced. |
PDF_14 |
|
|
Pdf format compatible with PDF 1.4 |
PDF_15 |
|
|
Pdf format compatible with PDF 1.5 |
PDF_16 |
|
|
Pdf format compatible with PDF 1.6 |
PDF_17 |
|
|
Pdf format compatible with PDF 1.7 |
PDF_A_1_B |
|
|
Pdf format compatible with PDF/A-1b(ISO 19005-1) |
PDF_A_1_A |
|
|
Pdf format compatible with PDF/A-1a(ISO 19005-1) |
PDF_A_2_B |
|
|
Pdf format compatible with PDF/A-2b(ISO 19005-2) |
PDF_A_2_U |
|
|
Pdf format compatible with PDF/A-2u(ISO 19005-2) |
PDF_A_2_A |
|
|
Pdf format compatible with PDF/A-2a(ISO 19005-2) |
PDF_A_3_B |
|
|
Pdf format compatible with PDF/A-3b(ISO 19005-3) |
PDF_A_3_U |
|
|
Pdf format compatible with PDF/A-3u(ISO 19005-3) |
PDF_A_3_A |
|
|
Pdf format compatible with PDF/A-3a(ISO 19005-3) |
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 |
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". |
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. |
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. |
PivotAreaType number
Utility class containing constants. Indicates the type of rule being used to describe an area or aspect of the PivotTable.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
No Pivot area. |
NORMAL |
|
|
Represents a header or item. |
DATA |
|
|
Represents something in the data area. |
ALL |
|
|
Represents the whole PivotTable. |
ORIGIN |
|
|
Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets). |
BUTTON |
|
|
Represents a field button. |
TOP_RIGHT |
|
|
Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets). |
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. |
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. |
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. |
PivotFieldGroupType number
Utility class containing constants. Represents the group type of pivot field.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
No group |
DATE_TIME_RANGE |
|
|
Grouped by DateTime range. |
NUMBERIC_RANGE |
|
|
Grouped by numberic range. |
DISCRETE |
|
|
Grouped by discrete points. |
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. |
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. |
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. |
PivotGroupByType number
Utility class containing constants. Represents group by type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
RANGE_OF_VALUES |
|
|
Group by numbers. NOTE: This method is now obsolete. Instead, please use PivotGroupByType.Numbers enum. This method will be removed 12 months later since October 2023. Aspose apologizes for any inconvenience you may have experienced. |
NUMBERS |
|
|
Group by numbers. |
SECONDS |
|
|
Presents Seconds groupby type. |
MINUTES |
|
|
Presents Minutes groupby type. |
HOURS |
|
|
Presents Hours groupby type. |
DAYS |
|
|
Presents Days groupby type. |
MONTHS |
|
|
Presents Months groupby type. |
QUARTERS |
|
|
Presents Quarters groupby type. |
YEARS |
|
|
Presents Years groupby type. |
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 |
|
|
Shows values as the different format based the index of pivot item in the PivotField. Only for getting. |
PivotItemPositionType number
Utility class containing constants. Represents the position type of the pivot base item in the base field when the ShowDataAs calculation is in use.
Properties
Name | Type | Optional | Description |
---|---|---|---|
PREVIOUS |
|
|
Represents the previous pivot item in the PivotField. |
NEXT |
|
|
Represents the next pivot item in the PivotField. |
CUSTOM |
|
|
Shows values as the different format based the index of pivot item in the PivotField. Only for getting. |
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. |
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. |
PivotTableSelectionType number
Utility class containing constants. Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.
Properties
Name | Type | Optional | Description |
---|---|---|---|
DATA_AND_LABEL |
|
|
Data and labels |
DATA_ONLY |
|
|
Only selects data |
LABEL_ONLY |
|
|
Only selects labels |
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 |
|
|
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. |
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. |
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 |
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 |
|
|
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 |
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. |
PresetThemeGradientType number
Utility class containing constants. Represents the preset theme gradient type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
LIGHT_GRADIENT |
|
|
Light gradient |
TOP_SPOTLIGHT |
|
|
Top spotlight |
MEDIUM_GRADIENT |
|
|
Medium gradient |
BOTTOM_SPOTLIGHT |
|
|
Bottom spotlight |
RADIAL_GRADIENT |
|
|
Radial gradient |
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 |
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. |
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". |
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 |
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. |
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. |
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. |
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. |
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. |
ReConnectionMethodType number
Utility class containing constants. Specifies what the spreadsheet application should do when a connection fails.
Properties
Name | Type | Optional | Description |
---|---|---|---|
REQUIRED |
|
|
On refresh use the existing connection information and if it ends up being invalid then get updated connection information, if available from the external connection file. |
ALWAYS |
|
|
On every refresh get updated connection information from the external connection file, if available, and use that instead of the existing connection information. In this case the data refresh will fail if the external connection file is unavailable. |
NEVER |
|
|
Never get updated connection information from the external connection file even if it is available and even if the existing connection information is invalid |
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 |
ReflectionEffectType number
Utility class containing constants. Represents the effect type of reflection.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
No reflection effect. |
CUSTOM |
|
|
Custom reflection effect. |
TIGHT_REFLECTION_TOUCHING |
|
|
Tight reflection, touching. |
HALF_REFLECTION_TOUCHING |
|
|
Half reflection, touching. |
FULL_REFLECTION_TOUCHING |
|
|
Full reflection, touching. |
TIGHT_REFLECTION_4_PT_OFFSET |
|
|
Tight reflection, 4 pt offset. |
HALF_REFLECTION_4_PT_OFFSET |
|
|
Half reflection, 4 pt offset. |
FULL_REFLECTION_4_PT_OFFSET |
|
|
Full reflection, 4 pt offset. |
TIGHT_REFLECTION_8_PT_OFFSET |
|
|
Tight reflection, 8 pt offset. |
HALF_REFLECTION_8_PT_OFFSET |
|
|
Half reflection, 8 pt offset. |
FULL_REFLECTION_8_PT_OFFSET |
|
|
Full reflection, 8 pt offset. |
RenameStrategy number
Utility class containing constants. Strategy option for duplicate names of columns. When processing data with headers, some scenarios require the headers to be no duplication for all columns. For example, when exporting data to a datatable and the header is required to be taken as datatable's column name, duplicated values of the header are invalid. For such kind of situations, user may determine how to handle them by specifying this strategy.
Properties
Name | Type | Optional | Description |
---|---|---|---|
EXCEPTION |
|
|
Throws exception. |
DIGIT |
|
|
Named with digit. Duplicated names will become ...1, ...2, etc. |
LETTER |
|
|
Named with letter.. Duplicated names will become ...A, ...B, etc. |
ReserveMissingPivotItemType number
Utility class containing constants. Represents how to keep the missing pivot items.
Properties
Name | Type | Optional | Description |
---|---|---|---|
DEFAULT |
|
|
Removes old missint pivot items and reserves visible items which the current data source does not contain as missing items. |
ALL |
|
|
Reserves all missing items. |
NONE |
|
|
Removes all missing pivot items. |
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 |
RevisionActionType number
Utility class containing constants. Represents the type of revision action.
Properties
Name | Type | Optional | Description |
---|---|---|---|
ADD |
|
|
Add revision. |
DELETE |
|
|
Delete revision. |
DELETE_COLUMN |
|
|
Column delete revision. |
DELETE_ROW |
|
|
Row delete revision. |
INSERT_COLUMN |
|
|
Column insert revision. |
INSERT_ROW |
|
|
Row insert revision. |
RevisionType number
Utility class containing constants. Represents the revision type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CUSTOM_VIEW |
|
|
Custom view. |
DEFINED_NAME |
|
|
Defined name. |
CHANGE_CELLS |
|
|
Cells change. |
AUTO_FORMAT |
|
|
Auto format. |
MERGE_CONFLICT |
|
|
Merge conflict. |
COMMENT |
|
|
Comment. |
FORMAT |
|
|
Format. |
INSERT_SHEET |
|
|
Insert worksheet. |
MOVE_CELLS |
|
|
Move cells. |
UNDO |
|
|
Undo. |
QUERY_TABLE |
|
|
Query table. |
INSERT_DELETE |
|
|
Inserting or deleting. |
RENAME_SHEET |
|
|
Rename worksheet. |
UNKNOWN |
|
|
Unknown. |
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. |
|
|
|
Represents a Pdf file. |
XPS |
|
|
XPS (XML Paper Specification) format. |
TIFF |
|
|
Represents a TIFF file. |
SVG |
|
|
SVG file. |
DIF |
|
|
Data Interchange Format. |
OTS |
|
|
Open Document Template Sheet(OTS) file. |
XLT |
|
|
Excel 97-2003 template file. |
XML |
|
|
Represents a simple xml file. |
NUMBERS |
|
|
Represents a numbers file. Not supported. |
MARKDOWN |
|
|
Represents markdown document. |
FODS |
|
|
Represents OpenDocument Flat XML Spreadsheet (.fods) file format. |
SXC |
|
|
Represents StarOffice Calc Spreadsheet (.sxc) file format. |
PPTX |
|
|
Represents .pptx file. |
DOCX |
|
|
Represents .docx file. |
EMF |
|
|
Windows Enhanced Metafile. |
JPG |
|
|
JPEG JFIF. |
PNG |
|
|
Portable Network Graphics. |
BMP |
|
|
Windows Bitmap |
GIF |
|
|
Gif |
JSON |
|
|
Json |
SQL_SCRIPT |
|
|
Sql |
X_HTML |
|
|
Rrepesents XHtml file. |
EPUB |
|
|
Represents Epub file. |
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. |
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 |
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 |
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 |
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 |
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. |
ShowDropButtonType number
Utility class containing constants. Specifies when to show the drop button
Properties
Name | Type | Optional | Description |
---|---|---|---|
NEVER |
|
|
Never show the drop button. |
FOCUS |
|
|
Show the drop button when the control has the focus. |
ALWAYS |
|
|
Always show the drop button. |
SlicerCacheCrossFilterType number
Utility class containing constants. Represent the type of SlicerCacheCrossFilterType
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
The table style element of the slicer style for slicer items with no data is not applied to slicer items with no data, and slicer items with no data are not sorted separately in the list of slicer items in the slicer view |
SHOW_ITEMS_WITH_DATA_AT_TOP |
|
|
The table style element of the slicer style for slicer items with no data is applied to slicer items with no data, and slicer items with no data are sorted at the bottom in the list of slicer items in the slicer view |
SHOW_ITEMS_WITH_NO_DATA |
|
|
The table style element of the slicer style for slicer items with no data is applied to slicer items with no data, and slicer items with no data are not sorted separately in the list of slicer items in the slicer view. |
SlicerCacheItemSortType number
Utility class containing constants. Specify the sort type of SlicerCacheItem
Properties
Name | Type | Optional | Description |
---|---|---|---|
ASCENDING |
|
|
Ascending sort type |
DESCENDING |
|
|
Descending sort type |
SlicerStyleType number
Utility class containing constants. Specify the style of slicer view
Properties
Name | Type | Optional | Description |
---|---|---|---|
SLICER_STYLE_LIGHT_1 |
|
|
built-in light style one |
SLICER_STYLE_LIGHT_2 |
|
|
built-in light style two |
SLICER_STYLE_LIGHT_3 |
|
|
built-in light style three |
SLICER_STYLE_LIGHT_4 |
|
|
built-in light style four |
SLICER_STYLE_LIGHT_5 |
|
|
built-in light style five |
SLICER_STYLE_LIGHT_6 |
|
|
built-in light style six |
SLICER_STYLE_OTHER_1 |
|
|
built-in style other one |
SLICER_STYLE_OTHER_2 |
|
|
built-in style other two |
SLICER_STYLE_DARK_1 |
|
|
built-in dark style one |
SLICER_STYLE_DARK_2 |
|
|
built-in dark style tow |
SLICER_STYLE_DARK_3 |
|
|
built-in dark style three |
SLICER_STYLE_DARK_4 |
|
|
built-in dark style four |
SLICER_STYLE_DARK_5 |
|
|
built-in dark style five |
SLICER_STYLE_DARK_6 |
|
|
built-in dark style six |
CUSTOM |
|
|
user-defined style, unsupported for now unsupported |
SlideViewType number
Utility class containing constants. Represents the type when exporting to slides.
Properties
Name | Type | Optional | Description |
---|---|---|---|
VIEW |
|
|
Exporting as view in MS Excel. |
|
|
|
Exporting as printing. |
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. |
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. |
SortOrder number
Utility class containing constants. Represents sort order for the data range.
Properties
Name | Type | Optional | Description |
---|---|---|---|
ASCENDING |
|
|
|
DESCENDING |
|
|
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. |
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. |
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. |
SqlDataType number
Utility class containing constants. Specifies SQL data type of the parameter. Only valid for ODBC sources.
Properties
Name | Type | Optional | Description |
---|---|---|---|
SQL_UNSIGNED_OFFSET |
|
|
sql unsigned offset |
SQL_SIGNED_OFFSET |
|
|
sql signed offset |
SQL_GUID |
|
|
sql guid |
SQL_W_LONG_VARCHAR |
|
|
sql wide long variable char |
SQL_W_VARCHAR |
|
|
sql wide variable char |
SQL_W_CHAR |
|
|
sql wide char |
SQL_BIT |
|
|
sql bit |
SQL_TINY_INT |
|
|
sql tiny int |
SQL_BIG_INT |
|
|
sql big int |
SQL_LONG_VAR_BINARY |
|
|
sql long variable binary |
SQL_VAR_BINARY |
|
|
sql variable binary |
SQL_BINARY |
|
|
sql binary |
SQL_LONG_VAR_CHAR |
|
|
sql long variable char |
SQL_UNKNOWN_TYPE |
|
|
sql unknown type |
SQL_CHAR |
|
|
sql char |
SQL_NUMERIC |
|
|
sql numeric |
SQL_DECIMAL |
|
|
sql decimal |
SQL_INTEGER |
|
|
sql integer |
SQL_SMALL_INT |
|
|
sql small int |
SQL_FLOAT |
|
|
sql float |
SQL_REAL |
|
|
sql real |
SQL_DOUBLE |
|
|
sql double |
SQL_TYPE_DATE |
|
|
sql date type |
SQL_TYPE_TIME |
|
|
sql time type |
SQL_TYPE_TIMESTAMP |
|
|
sql timestamp type |
SQL_VAR_CHAR |
|
|
sql variable char |
SQL_INTERVAL_YEAR |
|
|
sql interval year |
SQL_INTERVAL_MONTH |
|
|
sql interval month |
SQL_INTERVAL_DAY |
|
|
sql interval day |
SQL_INTERVAL_HOUR |
|
|
sql interval hour |
SQL_INTERVAL_MINUTE |
|
|
sql interval minute |
SQL_INTERVAL_SECOND |
|
|
sql interval second |
SQL_INTERVAL_YEAR_TO_MONTH |
|
|
sql interval year to month |
SQL_INTERVAL_DAY_TO_HOUR |
|
|
sql interval day to hour |
SQL_INTERVAL_DAY_TO_MINUTE |
|
|
sql interval day to minute |
SQL_INTERVAL_DAY_TO_SECOND |
|
|
sql interval day to second |
SQL_INTERVAL_HOUR_TO_MINUTE |
|
|
sql interval hour to minute |
SQL_INTERVAL_HOUR_TO_SECOND |
|
|
sql interval hour to second |
SQL_INTERVAL_MINUTE_TO_SECOND |
|
|
sql interval minute to second |
SqlScriptOperatorType number
Utility class containing constants. Represents the type of operating data.
Properties
Name | Type | Optional | Description |
---|---|---|---|
INSERT |
|
|
Insert data. |
UPDATE |
|
|
Update data. |
DELETE |
|
|
Delete data. |
StyleModifyFlag number
Utility class containing constants. The style modified flags.
Properties
Name | Type | Optional | Description |
---|---|---|---|
LEFT_BORDER |
|
|
Indicates whether left border has been modified for the style. |
RIGHT_BORDER |
|
|
Indicates whether right border has been modified for the style. |
TOP_BORDER |
|
|
Indicates whether top border has been modified for the style. |
BOTTOM_BORDER |
|
|
Indicates whether bottom border has been modified for the style. |
DIAGONAL_DOWN_BORDER |
|
|
Indicates whether diagonal-down border has been modified for the style. |
DIAGONAL_UP_BORDER |
|
|
Indicates whether diagonal-up border has been modified for the style. |
DIAGONAL |
|
|
Indicates whether one or more diagonal borders(DIAGONAL_DOWN_BORDER, DIAGONAL_UP_BORDER) have been modified for the style. |
HORIZONTAL_BORDER |
|
|
Indicates whether horizontal border has been modified for the style. Only for dynamic style, such as conditional formatting. |
VERTICAL_BORDER |
|
|
Indicates whether vertical border has been modified for the style. Only for dynamic style, such as conditional formatting. |
BORDERS |
|
|
Indicates whether one or more borders(LEFT_BORDER, RIGHT_BORDER, TOP_BORDER, BOTTOM_BORDER, DIAGONAL, HORIZONTAL_BORDER, VERTICAL_BORDER) have been modified for the style. |
NUMBER_FORMAT |
|
|
Indicates whether numberformat has been modified. |
HORIZONTAL_ALIGNMENT |
|
|
Indicates whether horizontal alignment has been modified. |
VERTICAL_ALIGNMENT |
|
|
Indicates whether vertical alignment has been modified. |
INDENT |
|
|
Indicates whether indent property has been modified. |
ROTATION |
|
|
Indicates whether rotation property has been modified. |
WRAP_TEXT |
|
|
Indicates whether wrap text property has been modified. |
SHRINK_TO_FIT |
|
|
Indicates whether shrink to fit property has been modified. |
TEXT_DIRECTION |
|
|
Indicates whether text direction property has been modified. |
RELATIVE_INDENT |
|
|
Indicates whether relative indent property has been modified for the style. Only for dynamic style, such as conditional formatting. |
ALIGNMENT_SETTINGS |
|
|
Indicates whether one or more alignment-related properties(HORIZONTAL_ALIGNMENT, VERTICAL_ALIGNMENT, ROTATION, WRAP_TEXT, WRAP_TEXT, INDENT, SHRINK_TO_FIT, TEXT_DIRECTION, RELATIVE_INDENT) have been modified. |
PATTERN |
|
|
Indicates whether pattern of the shading has been modified. |
FOREGROUND_COLOR |
|
|
Indicates whether foreground color has been modified. |
BACKGROUND_COLOR |
|
|
Indicates whether background color has been modified. |
CELL_SHADING |
|
|
Indicates whether one or more shading-related properties(PATTERN, FOREGROUND_COLOR, BACKGROUND_COLOR) have been modified. |
LOCKED |
|
|
Indicates whether locked property has been modified. |
HIDE_FORMULA |
|
|
Indicates whether hide formula has been modified. |
PROTECTION_SETTINGS |
|
|
Indicates whether one or more protection-related properties(LOCKED, HIDE_FORMULA) have been modified. |
FONT_SIZE |
|
|
Indicates whether font size has been modified. |
FONT_NAME |
|
|
Indicates whether font name has been modified. |
FONT_COLOR |
|
|
Indicates whether font color has been modified. |
FONT_WEIGHT |
|
|
Indicates whether font weight has been modified. |
FONT_ITALIC |
|
|
Indicates whether italic property of font has been modified. |
FONT_UNDERLINE |
|
|
Indicates whether underline property of font has been modified. |
FONT_STRIKE |
|
|
Indicates whether strike property font has been modified. |
FONT_SCRIPT |
|
|
Indicates whether subscript or superscript property of font has been modified. |
FONT_FAMILY |
|
|
Indicates whether font family has been modified. |
FONT_CHARSET |
|
|
Indicates whether charset of the font has been modified. |
FONT_SCHEME |
|
|
unused. |
FONT_DIRTY |
|
|
unused. |
FONT_SPELLING_ERROR |
|
|
unused. |
FONT_U_FILL_TX |
|
|
unused. |
FONT_SPACING |
|
|
unused. |
FONT_KERNING |
|
|
unused. |
FONT_EQUALIZE |
|
|
unused. |
FONT_CAP |
|
|
unused. |
FONT_VERTICAL_TEXT |
|
|
|
FONT |
|
|
Indicates whether one or more properties have been modified for the font of the style. |
ALL |
|
|
Indicates whether one or more properties have been modified for the style. |
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 |
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. |
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 |
|
|
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. |
CELL_REFERENCE |
|
|
Link on cell or named range. |
TextAlignmentType number
Utility class containing constants. Enumerates text alignment types.
Properties
Name | Type | Optional | Description |
---|---|---|---|
GENERAL |
|
|
Represents general text alignment. |
BOTTOM |
|
|
Represents bottom text alignment. |
CENTER |
|
|
Represents center text alignment. |
CENTER_ACROSS |
|
|
Represents center across text alignment. |
DISTRIBUTED |
|
|
Represents distributed text alignment. |
FILL |
|
|
Represents fill text alignment. |
JUSTIFY |
|
|
Represents justify text alignment. |
LEFT |
|
|
Represents left text alignment. |
RIGHT |
|
|
Represents right text alignment. |
TOP |
|
|
Represents top text alignment. |
JUSTIFIED_LOW |
|
|
Aligns the text with an adjusted kashida length for Arabic text. |
THAI_DISTRIBUTED |
|
|
Distributes Thai text specially, because each character is treated as a word. |
TextAutonumberScheme number
Utility class containing constants. Represents all automatic number scheme.
Properties
Name | Type | Optional | Description |
---|---|---|---|
NONE |
|
|
|
ALPHA_LC_PAREN_BOTH |
|
|
(a), (b), (c), … |
ALPHA_LC_PAREN_R |
|
|
a), b), c), … |
ALPHA_LC_PERIOD |
|
|
a., b., c., … |
ALPHA_UC_PAREN_BOTH |
|
|
(A), (B), (C), … |
ALPHA_UC_PAREN_R |
|
|
A), B), C), … |
ALPHA_UC_PERIOD |
|
|
A., B., C., … |
ARABIC_1_MINUS |
|
|
Bidi Arabic 1 (AraAlpha) with ANSI minus symbol |
ARABIC_2_MINUS |
|
|
Bidi Arabic 2 (AraAbjad) with ANSI minus symbol |
ARABIC_DB_PERIOD |
|
|
Dbl-byte Arabic numbers w/ double-byte period |
ARABIC_DB_PLAIN |
|
|
Dbl-byte Arabic numbers |
ARABIC_PAREN_BOTH |
|
|
(1), (2), (3), … |
ARABIC_PAREN_R |
|
|
1), 2), 3), … |
ARABIC_PERIOD |
|
|
1., 2., 3., … |
ARABIC_PLAIN |
|
|
1, 2, 3, … |
CIRCLE_NUM_DB_PLAIN |
|
|
Dbl-byte circle numbers (1-10 circle[0x2460-], 11-arabic numbers) |
CIRCLE_NUM_WD_BLACK_PLAIN |
|
|
Wingdings black circle numbers |
CIRCLE_NUM_WD_WHITE_PLAIN |
|
|
Wingdings white circle numbers (0-10 circle[0x0080-],11- arabic numbers) |
EA_1_CHS_PERIOD |
|
|
EA: Simplified Chinese w/ single-byte period |
EA_1_CHS_PLAIN |
|
|
EA: Simplified Chinese (TypeA 1-99, TypeC 100-) |
EA_1_CHT_PERIOD |
|
|
EA: Traditional Chinese w/ single-byte period |
EA_1_CHT_PLAIN |
|
|
EA: Traditional Chinese (TypeA 1-19, TypeC 20-) |
EA_1_JPN_CHS_DB_PERIOD |
|
|
EA: Japanese w/ double-byte period |
EA_1_JPN_KOR_PERIOD |
|
|
EA: Japanese/Korean w/ single-byte period |
EA_1_JPN_KOR_PLAIN |
|
|
EA: Japanese/Korean (TypeC 1-) |
HEBREW_2_MINUS |
|
|
Bidi Hebrew 2 with ANSI minus symbol |
HINDI_ALPHA_1_PERIOD |
|
|
Hindi alphabet period - consonants |
HINDI_ALPHA_PERIOD |
|
|
Hindi alphabet period - vowels |
HINDI_NUM_PAREN_R |
|
|
/// Hindi numerical parentheses - right |
HINDI_NUM_PERIOD |
|
|
Hindi numerical period |
ROMAN_LC_PAREN_BOTH |
|
|
(i), (ii), (iii), … |
ROMAN_LC_PAREN_R |
|
|
i), ii), iii), … |
ROMAN_LC_PERIOD |
|
|
i., ii., iii., … |
ROMAN_UC_PAREN_BOTH |
|
|
(I), (II), (III), … |
ROMAN_UC_PAREN_R |
|
|
I), II), III), … |
ROMAN_UC_PERIOD |
|
|
I., II., III., … |
THAI_ALPHA_PAREN_BOTH |
|
|
Thai alphabet parentheses - both |
THAI_ALPHA_PAREN_R |
|
|
Thai alphabet parentheses - right |
THAI_ALPHA_PERIOD |
|
|
Thai alphabet period |
THAI_NUM_PAREN_BOTH |
|
|
Thai numerical parentheses - both |
THAI_NUM_PAREN_R |
|
|
Thai numerical parentheses - right |
THAI_NUM_PERIOD |
|
|
Thai numerical period |
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. |
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. |
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 |
|
|
TextFontAlignType number
Utility class containing constants. Represents the different types of font alignment.
Properties
Name | Type | Optional | Description |
---|---|---|---|
AUTOMATIC |
|
|
When the text flow is horizontal or simple vertical same as fontBaseline but for other vertical modes same as fontCenter. |
BOTTOM |
|
|
The letters are anchored to the very bottom of a single line. |
BASELINE |
|
|
The letters are anchored to the bottom baseline of a single line. |
CENTER |
|
|
The letters are anchored between the two baselines of a single line. |
TOP |
|
|
The letters are anchored to the top baseline of a single line. |
TextNodeType number
Utility class containing constants. Represents the node type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
TEXT_RUN |
|
|
Represents the text node. |
TEXT_PARAGRAPH |
|
|
Represents the text paragraph. |
EQUATION |
|
|
Represents the equation text. |
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. |
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. |
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. |
TextTabAlignmentType number
Utility class containing constants. Represents the text tab alignment types.
Properties
Name | Type | Optional | Description |
---|---|---|---|
CENTER |
|
|
The text at this tab stop is center aligned. |
DECIMAL |
|
|
At this tab stop, the decimals are lined up. |
LEFT |
|
|
The text at this tab stop is left aligned. |
RIGHT |
|
|
The text at this tab stop is right aligned. |
TextVerticalType number
Utility class containing constants. Represents the text direct type.
Properties
Name | Type | Optional | Description |
---|---|---|---|
VERTICAL |
|
|
East Asian Vertical display. |
HORIZONTAL |
|
|
Horizontal text. |
VERTICAL_LEFT_TO_RIGHT |
|
|
Displayed vertical and the text flows top down then LEFT to RIGHT |
VERTICAL_90 |
|
|
Each line is 90 degrees rotated clockwise |
VERTICAL_270 |
|
|
Each line is 270 degrees rotated clockwise |
STACKED |
|
|
Determines if all of the text is vertical |
STACKED_RIGHT_TO_LEFT |
|
|
Specifies that vertical WordArt should be shown from right to left rather than left to right. |
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. |
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. |
TickLabelAlignmentType number
Utility class containing constants. Represents the text alignment type for the tick labels on the axis
Properties
Name | Type | Optional | Description |
---|---|---|---|
CENTER |
|
|
Represents the text shall be centered. |
LEFT |
|
|
Represents the text shall be left justified. |
RIGHT |
|
|
Represents the text shall be right justified. |
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. |
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 |
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. |
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. |
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 |
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. |
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 |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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 |
|
|
VisibilityType number
Utility class containing constants. Represents the states for sheet visibility.
Properties
Name | Type | Optional | Description |
---|---|---|---|
VISIBLE |
|
|
Indicates the sheet is visible. |
HIDDEN |
|
|
Indicates the sheet is hidden, but can be shown by the user via the user interface. |
VERY_HIDDEN |
|
|
Indicates the sheet is hidden and cannot be shown in the user interface (UI). This state is only available programmatically. |
WebExtensionStoreType number
Utility class containing constants. Represents the store type of web extension.
Properties
Name | Type | Optional | Description |
---|---|---|---|
OMEX |
|
|
Specifies that the store type is Office.com. |
SP_CATALOG |
|
|
Specifies that the store type is SharePoint corporate catalog. |
SP_APP |
|
|
Specifies that the store type is a SharePoint web application. |
EXCHANGE |
|
|
Specifies that the store type is an Exchange server. |
FILE_SYSTEM |
|
|
Specifies that the store type is a file system share. |
REGISTRY |
|
|
Specifies that the store type is the system registry. |
EX_CATALOG |
|
|
Specifies that the store type is Centralized Deployment via Exchange. |
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. |
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. |