Independentsoft
- any library, any programming language
Home
Purchase
Support
Company
Contact
JSpreadsheet
>
Tutorial
> 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(); } } }
Need help? Ask our developers:
Name*
Email*
Message*