Conditional Formatting, Data Bars

[starnaus]

Is there an example of applying a data bar conditional format to a column of integers?

Thank you.

[Gary.zhang]

Hello,

For your need, please refer to the following method to apply a data bar conditional format to a column of integers. Regarding your email request, we have sent you the demo, please review it.

Code: Select all

Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.Range["A1"].NumberValue = 1;
sheet.Range["A2"].NumberValue = -2;
sheet.Range["A3"].NumberValue = 3;
sheet.Range["A4"].NumberValue = -4;
sheet.Range["A5"].NumberValue = 5;
ConditionalFormatWrapper format = sheet.Range["A1:A5"].ConditionalFormats.AddCondition();
format.FormatType = ConditionalFormatType.DataBar;
workbook.SaveToFile("sample.xlsx",ExcelVersion.Version2010);


If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team