Independentsoft
- any library, any programming language
Home
Purchase
Support
Company
Contact
JODF
>
Tutorial
> Set cell format
The following example shows you how to set cell format.
import com.independentsoft.office.odf.Cell; import com.independentsoft.office.odf.Spreadsheet; import com.independentsoft.office.odf.Table; import com.independentsoft.office.odf.styles.CellStyle; import com.independentsoft.office.odf.styles.DecimalNumber; import com.independentsoft.office.odf.styles.NumberStyle; public class Example { public static void main(String[] args) { try { Spreadsheet spreadsheet = new Spreadsheet(); DecimalNumber decimalNumber1 = new DecimalNumber(); decimalNumber1.setDecimalPlaces(2); decimalNumber1.setMinIntegerDigits(1); decimalNumber1.setGrouping(true); NumberStyle numberStyle1 = new NumberStyle("N1"); numberStyle1.setNumber(decimalNumber1); CellStyle cellStyle1 = new CellStyle("CS1"); cellStyle1.setDataStyle("N1"); spreadsheet.getAutomaticStyles().getStyles().add(numberStyle1); spreadsheet.getAutomaticStyles().getStyles().add(cellStyle1); Cell a1 = new Cell(9999999); a1.setStyle("CS1"); Table sheet1 = new Table(); sheet1.set("A1", a1); spreadsheet.getTables().add(sheet1); spreadsheet.save("c:\\test\\output.ods", true); } catch (Exception e) { System.out.println(e.getMessage()); e.printStackTrace(); } } }
Need help? Ask our developers:
Name*
Email*
Message*