Cell value types

The following example shows you how to create cells with different value types: string, integer, double, boolean, date and formula.

import java.util.Date;

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Formula;
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.setName("Values");

            sheet.set("A1", new Cell("Text value"));
            sheet.set("A2", new Cell(42));
            sheet.set("A3", new Cell(3.14159));
            sheet.set("A4", new Cell(true));
            sheet.set("A5", new Cell(new Date()));

            Cell formulaCell = new Cell();
            formulaCell.setFormula(new Formula("SUM(A2:A3)"));
            sheet.set("A6", formulaCell);

            sheet.set("B1", new Cell("String"));
            sheet.set("B2", new Cell("Integer"));
            sheet.set("B3", new Cell("Double"));
            sheet.set("B4", new Cell("Boolean"));
            sheet.set("B5", new Cell("DateTime"));
            sheet.set("B6", new Cell("Formula"));

            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 > Cell value types

Need help? Ask our developers: