Set Cell Color

The following example shows you how to set cell's fill color and cell text color.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.DataBarColor;
import com.independentsoft.office.spreadsheet.Font;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;
import com.independentsoft.office.spreadsheet.styles.CellFormat;
import com.independentsoft.office.spreadsheet.styles.Fill;
import com.independentsoft.office.spreadsheet.styles.ForegroundColor;
import com.independentsoft.office.spreadsheet.styles.PatternFill;
import com.independentsoft.office.spreadsheet.styles.PatternType;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            PatternFill pattern1 = new PatternFill();
            pattern1.setType(PatternType.SOLID);

            ForegroundColor foregroundColor = new ForegroundColor();
            foregroundColor.setColor("FF0000"); //red

            pattern1.setForegroundColor(foregroundColor);

            Fill fill1 = new Fill();
            fill1.setPattern(pattern1);

            Font font1 = new Font();
            font1.setName("Calibri");
            font1.setSize(11);
            font1.setFamily(2);

            DataBarColor dataBarColor = new DataBarColor();
            dataBarColor.setColor("FFFF00"); //yellow
            
            font1.setColor(dataBarColor);

            CellFormat format1 = new CellFormat();
            format1.setFill(fill1);
            format1.setFont(font1);
            
            Cell a1 = new Cell(100);
            a1.setFormat(format1);
            
            Worksheet sheet1 = new Worksheet();
            sheet1.set("A1",a1);

            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 > Set Cell Color

Need help? Ask our developers: