Message-ID: <1821423931.9625.1711697025217.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9624_127370449.1711697025217" ------=_Part_9624_127370449.1711697025217 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
public Style Style{ get; set; }=20
Public Property Style() As Style=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); Range rng =3D wb.Worksheets[0].CreateRange("$B$2:$F$10"= ); ConditionalFormat condFmt =3D wb.CreateConditionalFormat(); Condition cond =3D condFmt.CreateCondition( Condition.Comparison.CellValueGreaterThan, "=3D100"); Font fnt =3D cond.Style.Font; fnt.Bold =3D true; fnt.Color =3D wb.Palette.GetClosestColor(100, 100, 255); rng.SetConditionalFormat(condFmt);=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim rng As Range =3D wb.Worksheets(0).CreateRange("$B$2:$F$1= 0") Dim condFmt As ConditionalFormat =3D wb.CreateConditionalFormat() Dim cond As Condition =3D _ condFmt.CreateCondition( _ Condition.Comparison.CellValueGreaterThan, _ "=3D100") Dim fnt As Font =3D cond.Style.Font fnt.Bold =3D true fnt.Color =3D wb.Palette.GetClosestColor(100, 1= 00, 255) rng.SetConditionalFormat(condFmt)=20