Number formats

The following example shows you how to apply number formats including date, currency, percentage and custom patterns.

import java.util.Date;

import com.independentsoft.office.spreadsheet.Cell;
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.MasterCellFormat;
import com.independentsoft.office.spreadsheet.styles.NumberFormat;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook();

            MasterCellFormat dateFormat = new MasterCellFormat();
            NumberFormat nfDate = new NumberFormat();
            nfDate.setID(1);
            nfDate.setCode("dd/mm/yyyy");
            dateFormat.setNumberFormat(nfDate);

            MasterCellFormat currencyFormat = new MasterCellFormat();
            NumberFormat nfCurr = new NumberFormat();
            nfCurr.setID(2);
            nfCurr.setCode("$#,##0.00");
            currencyFormat.setNumberFormat(nfCurr);

            MasterCellFormat percentFormat = new MasterCellFormat();
            NumberFormat nfPct = new NumberFormat();
            nfPct.setID(3);
            nfPct.setCode("0.00%");
            percentFormat.setNumberFormat(nfPct);

            book.getStyles().getMasterCellFormats().add(dateFormat);
            book.getStyles().getMasterCellFormats().add(currencyFormat);
            book.getStyles().getMasterCellFormats().add(percentFormat);

            Worksheet sheet = new Worksheet();

            Cell a1 = new Cell(new Date());
            CellFormat fmt1 = new CellFormat();
            fmt1.setNumberFormatID(1);
            a1.setFormat(fmt1);
            sheet.set("A1", a1);

            Cell a2 = new Cell(9999.99);
            CellFormat fmt2 = new CellFormat();
            fmt2.setNumberFormatID(2);
            a2.setFormat(fmt2);
            sheet.set("A2", a2);

            Cell a3 = new Cell(0.1234);
            CellFormat fmt3 = new CellFormat();
            fmt3.setNumberFormatID(3);
            a3.setFormat(fmt3);
            sheet.set("A3", a3);

            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 > Number formats

Need help? Ask our developers: