Conditional Formatting

The following example shows you how to use conditional formatting.
import com.independentsoft.office.spreadsheet.Cell;
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.DataBar;
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 sheet1 = new Worksheet();
            sheet1.set("A1",new Cell(100));
            sheet1.set("A2",new Cell(1000));
            sheet1.set("A3",new Cell(2000));
            
            DataBarColor dataBarColor = new DataBarColor();
            dataBarColor.setColor("FF0000"); //red
            
            DataBar dataBar1 = new DataBar();
            dataBar1.setColor(dataBarColor);
            
            ConditionalFormatValueObject first = new ConditionalFormatValueObject();
            first.setType(ConditionalFormatValueObjectType.MINIMUM);
            first.setValue("0");
            
            ConditionalFormatValueObject second = new ConditionalFormatValueObject();
            second.setType(ConditionalFormatValueObjectType.MAXIMUM);
            second.setValue("0");

            dataBar1.setFirstConditionalFormatValueObject(first);
            dataBar1.setSecondConditionalFormatValueObject(second);

            ConditionalFormattingRule rule1 = new ConditionalFormattingRule();
            rule1.setType(ConditionalFormatType.DATA_BAR);
            rule1.setPriority(1);
            rule1.setDataBar(dataBar1);

            ConditionalFormatting formatting1 = new ConditionalFormatting();
            formatting1.setReference("A1:A3");
            formatting1.getRules().add(rule1);

            sheet1.getConditionalFormattings().add(formatting1);

            Workbook book = new Workbook();
            book.getSheets().add(sheet1);

            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}
Independentsoft - any library, any programming language

JSpreadsheet > Tutorial > Conditional Formatting

Need help? Ask our developers:
