Class ConditionalFormattingCollection
Contents
[
Hide
]ConditionalFormattingCollection class
Encapsulates a collection of FormatCondition
objects.
public class ConditionalFormattingCollection : CollectionBase<FormatConditionCollection>
Properties
Name | Description |
---|---|
Capacity { get; set; } | |
Count { get; } | |
Item { get; } | Gets the FormatConditions element at the specified index. |
Item { get; set; } |
Methods
Name | Description |
---|---|
Add() | Adds a FormatConditions to the collection. |
BinarySearch(FormatConditionCollection) | |
BinarySearch(FormatConditionCollection, IComparer<FormatConditionCollection>) | |
BinarySearch(int, int, FormatConditionCollection, IComparer<FormatConditionCollection>) | |
Clear() | |
Contains(FormatConditionCollection) | |
Copy(ConditionalFormattingCollection) | Copies conditional formatting. |
CopyTo(FormatConditionCollection[]) | |
CopyTo(FormatConditionCollection[], int) | |
CopyTo(int, FormatConditionCollection[], int, int) | |
Exists(Predicate<FormatConditionCollection>) | |
Find(Predicate<FormatConditionCollection>) | |
FindAll(Predicate<FormatConditionCollection>) | |
FindIndex(Predicate<FormatConditionCollection>) | |
FindIndex(int, Predicate<FormatConditionCollection>) | |
FindIndex(int, int, Predicate<FormatConditionCollection>) | |
FindLast(Predicate<FormatConditionCollection>) | |
FindLastIndex(Predicate<FormatConditionCollection>) | |
FindLastIndex(int, Predicate<FormatConditionCollection>) | |
FindLastIndex(int, int, Predicate<FormatConditionCollection>) | |
GetEnumerator() | |
IndexOf(FormatConditionCollection) | |
IndexOf(FormatConditionCollection, int) | |
IndexOf(FormatConditionCollection, int, int) | |
LastIndexOf(FormatConditionCollection) | |
LastIndexOf(FormatConditionCollection, int) | |
LastIndexOf(FormatConditionCollection, int, int) | |
RemoveArea(int, int, int, int) | Remove all conditional formatting in the range. |
RemoveAt(int) |
Examples
namespace AsposeCellsExamples
{
using Aspose.Cells;
using System;
using System.Drawing;
public class ConditionalFormattingCollectionDemo
{
public static void ConditionalFormattingCollectionExample()
{
// Instantiating a Workbook object
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
// Get Conditional Formatting
ConditionalFormattingCollection cformattings = sheet.ConditionalFormattings;
// Adds an empty conditional formatting
int index = cformattings.Add();
// Get newly added Conditional formatting
FormatConditionCollection fcs = cformattings[index];
// Sets the conditional format range.
CellArea ca = new CellArea
{
StartRow = 0,
EndRow = 0,
StartColumn = 0,
EndColumn = 0
};
fcs.AddArea(ca);
ca = new CellArea
{
StartRow = 1,
EndRow = 1,
StartColumn = 1,
EndColumn = 1
};
fcs.AddArea(ca);
// Add condition.
int conditionIndex = fcs.AddCondition(FormatConditionType.CellValue, OperatorType.Between, "=A2", "100");
int conditionIndex2 = fcs.AddCondition(FormatConditionType.CellValue, OperatorType.Between, "50", "100");
// Sets the background color.
FormatCondition fc = fcs[conditionIndex];
fc.Style.BackgroundColor = Color.Red;
// Saving the Excel file
workbook.Save("ConditionalFormattingCollectionDemo.xlsx");
workbook.Save("ConditionalFormattingCollectionDemo.pdf");
}
}
}
See Also
- class CollectionBase<T>
- class FormatConditionCollection
- namespace Aspose.Cells
- assembly Aspose.Cells