Message-ID: <1160201806.9783.1711702683724.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9782_1477510181.1711702683724" ------=_Part_9782_1477510181.1711702683724 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Removes the specified Condition f= rom the ConditionalFormat ob= ject.
=20public void RemoveCondition(Condition condition)=20
Public Sub RemoveCondition(ByVal condition As Condition)=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); ConditionalFormat condFmt =3D wb.CreateConditionalFormat(); Condition cond1 =3D condFmt.CreateCondition( Condition.Comparison.CellValueBetween, "=3D100", "=3D150"); Condition cond2 =3D condFmt.CreateCondition( Condition.Comparison.CellValueGreaterThan, "=3D100"); condFmt.RemoveCondition(cond2);=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim condFmt As ConditionalFormat =3D wb.CreateConditionalFormat() Dim cond1 As Condition =3D _ condFmt.CreateCondition( _ Condition.Comparison.CellValueGreaterThan, _ "=3D100") Dim cond2 As Condition =3D _ condFmt.CreateCondition( _ Condition.Comparison.CellValueBetween, _ "=3D100", _ "=3D150") condFmt.RemoveCondition(cond2)=20