formatColorRgb property

Color formatColorRgb
getter/setter pair

The color assigned to the threshold of a color scale conditional format in Rgb.

// Create a new Excel Document.
final Workbook workbook = Workbook();

// Accessing sheet via index.
final Worksheet sheet = workbook.worksheets[0];
sheet.getRangeByName('A1').number = 12;
sheet.getRangeByName('A2').number = 29;
sheet.getRangeByName('A3').number = 41;
sheet.getRangeByName('A4').number = 84;
sheet.getRangeByName('A5').number = 90;
sheet.getRangeByName('A6').number = 112;
sheet.getRangeByName('A7').number = 131;
sheet.getRangeByName('A8').number = 20;

//Create color scale for the data in specified range.
final ConditionalFormats conditionalFormats =
    sheet.getRangeByName('A1:A8').conditionalFormats;
final ConditionalFormat conditionalFormat =
    conditionalFormats.addCondition();

// set colorscale CF.
conditionalFormat.formatType = ExcelCFType.colorScale;
final ColorScale colorScale = conditionalFormat.colorScale;

//Sets 3 - color scale and its constraints
colorScale.setConditionCount(3);

// set Color for FormatColorRgb Property.
colorScale.criteria[0].formatColorRgb = Color.fromARGB(255, 134, 10, 200);
colorScale.criteria[0].type = ConditionValueType.lowestValue;

// set Color for FormatColorRgb Property.
colorScale.criteria[1].formatColorRgb = Color.fromARGB(250, 13, 200, 20);
colorScale.criteria[1].type = ConditionValueType.number;
colorScale.criteria[1].value = "70";

// set Color for FormatColorRgb Property.
colorScale.criteria[2].formatColorRgb = Color.fromARGB(255, 184, 110, 20);
colorScale.criteria[2].type = ConditionValueType.highestValue;

final List<int> bytes = workbook.saveAsStream();
File('ColorScale.xlsx').writeAsBytes(bytes);
 workbook.dispose();

Implementation

late Color formatColorRgb;