Param |
---|
index | index | The 0-based index of the Condition object to remove. |
Example |
---|
Code Block |
---|
| csharp | csharp |
title | C# |
---|
{signature}
{parameters}
{param:index}The 0\-based index of the [Condition|Condition] object to remove.{param}
{example}{code:csharp|title=C#}
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
ConditionalFormat condFmt = wb.CreateConditionalFormat();
Condition cond1 =
condFmt.CreateCondition(
Condition.Comparison.CellValueBetween,
"=100",
"=150");
Condition cond2 =
condFmt.CreateCondition(
Condition.Comparison.CellValueGreaterThan,
"=100");
condFmt.RemoveCondition(0);
Code Block |
---|
{code}
{code:vb.net
vb.net | title | |title=vb.net
}
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
Dim condFmt As ConditionalFormat = wb.CreateConditionalFormat()
Dim cond1 As Condition = _
condFmt.CreateCondition( _
Condition.Comparison.CellValueGreaterThan, _
"=100")
Dim cond2 As Condition = _
condFmt.CreateCondition( _
Condition.Comparison.CellValueBetween, _
"=100", _
"=150")
condFmt.RemoveCondition(0)
{code}
{example}