Enumerations
Added in 1.10 (2019 October)
Added in 1.9 (2019 May)
| ArrowheadLength | |
| ArrowheadStyle | |
| AutoFillType | |
| CalculationState | |
| ChartBinType | |
| ChartBoxQuartileCalculation | |
| ChartErrorBarsInclude | |
| ChartErrorBarsType | |
| ChartGradientStyle | |
| ChartGradientStyleType | |
| ChartMapAreaLevel | |
| ChartMapLabelStrategy | |
| ChartMapProjectionType | |
| ChartParentLabelStrategy | |
| CloseBehavior | |
| ConnectorType | |
| FillPattern | |
| GeometricShapeType | |
| HeaderFooterState | |
| LinkedDataTypeState | |
| PaperType | |
| PictureFormat | |
| PivotAxis | |
| PivotFilterTopBottomCriterion | |
| Placement | |
| PrintComments | |
| PrintErrorType | |
| PrintMarginUnit | |
| PrintOrder | |
| RangeCopyType | |
| RibbonTab | |
| SaveBehavior | |
| SearchDirection | |
| ShapeAutoSize | |
| ShapeFillType | |
| ShapeFontUnderlineStyle | |
| ShapeLineDashStyle | |
| ShapeLineStyle | |
| ShapeScaleFrom | |
| ShapeScaleType | |
| ShapeTextHorizontalAlignment | |
| ShapeTextHorizontalOverflow | |
| ShapeTextOrientation | |
| ShapeTextReadingOrder | |
| ShapeTextVerticalAlignment | |
| ShapeTextVerticalOverflow | |
| ShapeType | |
| ShapeZOrder | |
| SpecialCellType | |
| SpecialCellValueType | |
ArrowheadLength
|
ArrowheadStyle
|
AutoFillType
|
CalculationState
|
ChartBinType
|
ChartBoxQuartileCalculation
|
ChartErrorBarsInclude
|
ChartErrorBarsType
|
ChartGradientStyle
|
ChartGradientStyleType
|
ChartMapAreaLevel
|
ChartMapLabelStrategy
|
ChartMapProjectionType
|
ChartParentLabelStrategy
|
CloseBehavior
|
ConnectorType
|
FillPattern
|
GeometricShapeType
|
HeaderFooterState
|
LinkedDataTypeState
|
PaperType
|
PictureFormat
|
PivotAxis
|
PivotFilterTopBottomCriterion
|
Placement
|
PrintComments
|
PrintErrorType
|
PrintMarginUnit
|
PrintOrder
|
RangeCopyType
|
RibbonTab
|
SaveBehavior
|
SearchDirection
|
ShapeAutoSize
|
ShapeFillType
|
ShapeFontUnderlineStyle
|
ShapeLineDashStyle
|
ShapeLineStyle
|
ShapeScaleFrom
|
ShapeScaleType
|
ShapeTextHorizontalAlignment
|
ShapeTextHorizontalOverflow
|
ShapeTextOrientation
|
ShapeTextReadingOrder
|
ShapeTextVerticalAlignment
|
ShapeTextVerticalOverflow
|
ShapeType
|
ShapeZOrder
|
SpecialCellType
|
SpecialCellValueType
|
Added in 1.8 (2018 September)
| AggregationFunction | |
| ChartColorScheme | |
| ChartDisplayBlankAs | |
| ChartPlotAreaPosition | |
| ChartPlotBy | |
| ChartSplitType | |
| ChartTickLabelAlignment | |
| DataValidationAlertStyle | |
| DataValidationOperator | |
| DataValidationType | |
| PivotLayoutType | |
| ShowAsCalculation | |
| SortBy | |
| SubtotalLocationType | |
AggregationFunction
|
ChartColorScheme
|
ChartDisplayBlankAs
|
ChartPlotAreaPosition
|
ChartPlotBy
|
ChartSplitType
|
ChartTickLabelAlignment
|
DataValidationAlertStyle
|
DataValidationOperator
|
DataValidationType
|
PivotLayoutType
|
ShowAsCalculation
|
SortBy
|
SubtotalLocationType
|
Added in 1.7 (2018 May)
| BuiltInStyle | |
| CalculationMode | |
| ChartAxisCategoryType | |
| ChartAxisDisplayUnit | |
| ChartAxisGroup | |
| ChartAxisPosition | |
| ChartAxisScaleType | |
| ChartAxisTickLabelPosition | |
| ChartAxisTickMark | |
| ChartAxisTimeUnit | |
| ChartAxisType | |
| ChartLineStyle | |
| ChartMarkerStyle | |
| ChartTextHorizontalAlignment | |
| ChartTextVerticalAlignment | |
| ChartTitlePosition | |
| ChartTrendlineType | |
| DataChangeType | |
| DocumentPropertyItem | |
| DocumentPropertyType | |
| EventSource | |
| PageOrientation | |
| ProtectionSelectionMode | |
| ReadingOrder | |
| WorksheetPositionType | |
BuiltInStyle
|
CalculationMode
|
ChartAxisCategoryType
|
ChartAxisDisplayUnit
|
ChartAxisGroup
|
ChartAxisPosition
|
ChartAxisScaleType
|
ChartAxisTickLabelPosition
|
ChartAxisTickMark
|
ChartAxisTimeUnit
|
ChartAxisType
|
ChartLineStyle
|
ChartMarkerStyle
|
ChartTextHorizontalAlignment
|
ChartTextVerticalAlignment
|
ChartTitlePosition
|
ChartTrendlineType
|
DataChangeType
|
DocumentPropertyItem
|
DocumentPropertyType
|
EventSource
|
PageOrientation
|
ProtectionSelectionMode
|
ReadingOrder
|
WorksheetPositionType
|
These did appear in the Shared API but have since been removed
CustomFunctionValueType (Excel)
?
Excel.CustomFunctionValueType.string - A string type in Excel.
Excel.CustomFunctionValueType.Number ("number") - A number type in Excel, such as dates, currencies, and other numbers.
Excel.CustomFunctionValueType.Invalid ("invalid") - An invalid type in Excel.
Excel.CustomFunctionValueType.Boolean ("boolean") - A boolean type in Excel.
Excel.CustomFunctionValueType.IsoDate ("isodate") - An ISO Date in Excel.
CustomFunctionDimensionality (Excel)
?
Excel.CustomFunctionDimensionality.Scalar ("scalar") - A single cell's value in Excel.
Excel.CustomFunctionDimensionality.Matrix ("matrix") - A range of values in Excel, with one or more rows, and one or more columns. In JavaScript, a range is implemented as an array, where each array element is another array.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext