Interfaces

BasicDataValidation(1.8) (Interface) Represents the Basic Type data validation criteria.
CellBorder(1.9) (Interface) Represents the properties of a single border.
CellBorderCollection(1.9) (Interface) Represents the format.borders properties.
CellProperties(1.9) (Interface) Represents the returned properties of getCellProperties.
CellPropertiesBorderLoadOptions(1.9) (Interface) Specifies which properties to load on the format.borders object.
CellPropertiesFill(1.9) (Interface) Represents the format.fill properties.
CellPropertiesFillLoadOptions(1.9) (Interface) Specifies which properties to load on the format.fill object.
CellPropertiesFont(1.9) (Interface) Represents the format.font properties.
CellPropertiesFontLoadOptions(1.9) (Interface) Specifies which properties to load on the format.font object.
CellPropertiesFormat(1.9) (Interface) Represents the returned format properties of getCellProperties or format input parameter of setCellProperties.
CellPropertiesFormatLoadOptions(1.9) (Interface) Represents which properties to load on the format object.
CellPropertiesLoadOptions(1.9) (Interface) Represents which cell properties to load, when used as part of a "range.getCellProperties" method.
CellPropertiesProtection(1.9) (Interface) Represents the format.protection properties.
ColumnProperties(1.9) (Interface) Represents the returned properties of getColumnProperties.
ColumnPropertiesLoadOptions(1.9) (Interface) Represents which column properties to load, when used as part of a "range.getColumnProperties" method.
ConditionalCellValueRule(1.6) (Interface) Represents a cell value conditional format rule.
ConditionalColorScaleCriteria(1.6) (Interface) Represents the criteria of the color scale.
ConditionalColorScaleCriterion(1.6) (Interface) Represents a Color Scale Criterion which contains a type, value, and a color.
ConditionalDatabarRule(1.6) (Interface) Represents a rule-type for a Data Bar.
ConditionalIconCriterion(1.6) (Interface) Represents an Icon Criterion which contains a type, value, an Operator, and an optional custom icon, if not using an iconset.
ConditionalPresetCriteriaRule(1.6) (Interface) Represents the Preset Criteria Conditional Format Rule.
ConditionalTextComparisonRule(1.6) (Interface) Represents a Cell Value Conditional Format Rule.
ConditionalTopBottomRule(1.6) (Interface) Represents the rule of the top/bottom conditional format.
CustomDataValidation(1.8) (Interface) Represents the Custom data validation criteria.
DataValidationErrorAlert(1.8) (Interface) Represents the error alert properties for the data validation.
DataValidationPrompt(1.8) (Interface) Represents the user prompt properties for the data validation.
DataValidationRule(1.8) (Interface) Represents the Data validation rule that contains different types of data validation.
FilterCriteria(1.2) (Interface) Represents the filtering criteria applied to a column.
FilterDatetime(1.2) (Interface) Represents how to filter a date when filtering on values.
Icon(1.2) (Interface) Represents a cell icon.
ListDataValidation(1.8) (Interface) Represents the List data validation criteria.
LoadOption(1.2) (Interface)
PageLayoutMarginOptions(1.9) (Interface) Represents the options in page layout margins.
PageLayoutZoomOptions(1.9) (Interface) Represents page zoom properties.
PivotValueFilter(1.12) (Interface) Configurable template for a value filter to apply to a PivotField.
RangeHyperlink(1.7) (Interface) Represents the necessary strings to get/set a hyperlink (XHL) object.
RangeReference(1.2) (Interface) Represents a string reference of the form SheetName!A1:B5, or a global or local named range.
ReplaceCriteria(Interface) Represents the replace criteria to be used.
RowProperties(1.9) (Interface) Represents the returned properties of getRowProperties.
RowPropertiesLoadOptions(1.9) (Interface) Represents which row properties to load, when used as part of a "range.getRowProperties" method.
RunOptions(?) (Interface)
SearchCriteria(1.9) (Interface) Represents the search criteria to be used.
SettableCellProperties(1.9) (Interface) Represents the input parameter of setCellProperties.
SettableColumnProperties(1.9) (Interface) Represents the input parameter of setColumnProperties.
SettableRowProperties(1.9) (Interface) Represents the input parameter of setRowProperties.
ShowAsRule(1.8) (Interface)
Subtotals(1.8) (Interface) Subtotals for the Pivot Field.
WorksheetProtectionOptions(1.2) (Interface) Represents the options in sheet protection.
WorksheetSearchCriteria(Interface) Represents the worksheet search criteria to be used.
BasicDataValidation
(1.8) (Interface) Represents the Basic Type data validation criteria.
CellBorder
(1.9) (Interface) Represents the properties of a single border.
CellBorderCollection
(1.9) (Interface) Represents the format.borders properties.
CellProperties
(1.9) (Interface) Represents the returned properties of getCellProperties.
CellPropertiesBorderLoadOptions
(1.9) (Interface) Specifies which properties to load on the format.borders object.
CellPropertiesFill
(1.9) (Interface) Represents the format.fill properties.
CellPropertiesFillLoadOptions
(1.9) (Interface) Specifies which properties to load on the format.fill object.
CellPropertiesFont
(1.9) (Interface) Represents the format.font properties.
CellPropertiesFontLoadOptions
(1.9) (Interface) Specifies which properties to load on the format.font object.
CellPropertiesFormat
(1.9) (Interface) Represents the returned format properties of getCellProperties or format input parameter of setCellProperties.
CellPropertiesFormatLoadOptions
(1.9) (Interface) Represents which properties to load on the format object.
CellPropertiesLoadOptions
(1.9) (Interface) Represents which cell properties to load, when used as part of a "range.getCellProperties" method.
CellPropertiesProtection
(1.9) (Interface) Represents the format.protection properties.
ColumnProperties
(1.9) (Interface) Represents the returned properties of getColumnProperties.
ColumnPropertiesLoadOptions
(1.9) (Interface) Represents which column properties to load, when used as part of a "range.getColumnProperties" method.
ConditionalCellValueRule
(1.6) (Interface) Represents a cell value conditional format rule.
ConditionalColorScaleCriteria
(1.6) (Interface) Represents the criteria of the color scale.
ConditionalColorScaleCriterion
(1.6) (Interface) Represents a Color Scale Criterion which contains a type, value, and a color.
ConditionalDatabarRule
(1.6) (Interface) Represents a rule-type for a Data Bar.
ConditionalIconCriterion
(1.6) (Interface) Represents an Icon Criterion which contains a type, value, an Operator, and an optional custom icon, if not using an iconset.
ConditionalPresetCriteriaRule
(1.6) (Interface) Represents the Preset Criteria Conditional Format Rule.
ConditionalTextComparisonRule
(1.6) (Interface) Represents a Cell Value Conditional Format Rule.
ConditionalTopBottomRule
(1.6) (Interface) Represents the rule of the top/bottom conditional format.
CustomDataValidation
(1.8) (Interface) Represents the Custom data validation criteria.
DataValidationErrorAlert
(1.8) (Interface) Represents the error alert properties for the data validation.
DataValidationPrompt
(1.8) (Interface) Represents the user prompt properties for the data validation.
DataValidationRule
(1.8) (Interface) Represents the Data validation rule that contains different types of data validation.
FilterCriteria
(1.2) (Interface) Represents the filtering criteria applied to a column.
FilterDatetime
(1.2) (Interface) Represents how to filter a date when filtering on values.
Icon
(1.2) (Interface) Represents a cell icon.
ListDataValidation
(1.8) (Interface) Represents the List data validation criteria.
LoadOption
(1.2) (Interface)
PageLayoutMarginOptions
(1.9) (Interface) Represents the options in page layout margins.
PageLayoutZoomOptions
(1.9) (Interface) Represents page zoom properties.
PivotValueFilter
(1.12) (Interface) Configurable template for a value filter to apply to a PivotField.
RangeHyperlink
(1.7) (Interface) Represents the necessary strings to get/set a hyperlink (XHL) object.
RangeReference
(1.2) (Interface) Represents a string reference of the form SheetName!A1:B5, or a global or local named range.
ReplaceCriteria
(Interface) Represents the replace criteria to be used.
RowProperties
(1.9) (Interface) Represents the returned properties of getRowProperties.
RowPropertiesLoadOptions
(1.9) (Interface) Represents which row properties to load, when used as part of a "range.getRowProperties" method.
RunOptions
(?) (Interface)
SearchCriteria
(1.9) (Interface) Represents the search criteria to be used.
SettableCellProperties
(1.9) (Interface) Represents the input parameter of setCellProperties.
SettableColumnProperties
(1.9) (Interface) Represents the input parameter of setColumnProperties.
SettableRowProperties
(1.9) (Interface) Represents the input parameter of setRowProperties.
ShowAsRule
(1.8) (Interface)
Subtotals
(1.8) (Interface) Subtotals for the Pivot Field.
WorksheetProtectionOptions
(1.2) (Interface) Represents the options in sheet protection.
WorksheetSearchCriteria
(Interface) Represents the worksheet search criteria to be used.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top