Conditional formatting - color scale

The following example shows you how to apply a two-color scale rule that shades cells from red (minimum) to green (maximum).

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.ColorScale;
import com.independentsoft.office.spreadsheet.ConditionalFormatType;
import com.independentsoft.office.spreadsheet.ConditionalFormatValueObject;
import com.independentsoft.office.spreadsheet.ConditionalFormatValueObjectType;
import com.independentsoft.office.spreadsheet.ConditionalFormatting;
import com.independentsoft.office.spreadsheet.ConditionalFormattingRule;
import com.independentsoft.office.spreadsheet.DataBarColor;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet();
            sheet.set("A1", new Cell(10));
            sheet.set("A2", new Cell(40));
            sheet.set("A3", new Cell(70));
            sheet.set("A4", new Cell(30));
            sheet.set("A5", new Cell(90));

            ColorScale colorScale = new ColorScale();

            ConditionalFormatValueObject minObj = new ConditionalFormatValueObject();
            minObj.setType(ConditionalFormatValueObjectType.MINIMUM);
            minObj.setValue("0");
            colorScale.getConditionalFormatValueObjects().add(minObj);

            ConditionalFormatValueObject maxObj = new ConditionalFormatValueObject();
            maxObj.setType(ConditionalFormatValueObjectType.MAXIMUM);
            maxObj.setValue("0");
            colorScale.getConditionalFormatValueObjects().add(maxObj);

            DataBarColor red = new DataBarColor();
            red.setColor("FF0000");
            colorScale.getColors().add(red);

            DataBarColor green = new DataBarColor();
            green.setColor("00FF00");
            colorScale.getColors().add(green);

            ConditionalFormattingRule rule = new ConditionalFormattingRule();
            rule.setType(ConditionalFormatType.COLOR_SCALE);
            rule.setPriority(1);
            rule.setColorScale(colorScale);

            ConditionalFormatting cf = new ConditionalFormatting();
            cf.setReference("A1:A5");
            cf.getRules().add(rule);
            sheet.getConditionalFormattings().add(cf);

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Conditional formatting - color scale

Need help? Ask our developers: