public interface IFormatConditions
Represents the conditional formats associated with a range.
Method Summary
All Methods Instance Methods Abstract Methods
Adds a new conditional format.
Adds a new conditional format.
Returns a new
IAboveAverage
object representing a conditionalformatting rule for the specified range.
Returns a new
IColorScale
object representing a conditionalformatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a selected range.
Returns a
IDataBar
object representing a data bar conditionalformatting rule for the specified range.
Returns a new
IIconSetCondition
object which represents an icon setconditional formatting rule for the specified range.
Returns a
ITop10
object representing a conditional formatting rulefor the specified range.
Returns a new
IUniqueValues
object representing a conditionalformatting rule for the specified range.
void
Deletes all conditional formats associated with the represented range.
void
Generates the conditional formats from the json string.
Returns the conditional format specified by the zero-based index.
int
Returns a value that represents the number of objects in the collection.
Generates a json string from the conditional formats.
Method Details
getCount
int getCount ()
Returns a value that represents the number of objects in the collection.
get
Returns the conditional format specified by the zero-based index.
Parameters:
index
- The zero-based index of the conditional format to return.
Returns:
The specified conditional format.
addAboveAverage
Returns a new
IAboveAverage
object representing a conditionalformatting rule for the specified range.
Returns:
AboveAverage object.
addColorScale
Returns a new
IColorScale
object representing a conditionalformatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a selected range.
Returns:
ColorScale object.
addDatabar
Returns a
IDataBar
object representing a data bar conditionalformatting rule for the specified range.
Returns:
Databar object.
addIconSetCondition
Returns a new
IIconSetCondition
object which represents an icon setconditional formatting rule for the specified range.
Returns:
IconSetCondition object.
addTop10
Returns a
ITop10
object representing a conditional formatting rulefor the specified range.
Returns:
Top10 object.
addUniqueValues
Returns a new
IUniqueValues
object representing a conditionalformatting rule for the specified range.
Returns:
UniqueValues object.
delete
void delete ()
Deletes all conditional formats associated with the represented range.
fromJson
Generates the conditional formats from the json string.
Parameters:
json
- the json string.
toJson
Generates a json string from the conditional formats.
Returns:
the conditional formats json string.