Wiki

Clone wiki

Aspose for Apache POI / Add-Data-in-Cells

Apache POI SS

Workbook wb = new HSSFWorkbook();

CreationHelper createHelper = wb.getCreationHelper();
Sheet sheet = wb.createSheet("new sheet");

// Create a row and put some cells in it. Rows are 0 based.
Row row = sheet.createRow((short)0);
// Create a cell and put a value in it.
Cell cell = row.createCell(0);
cell.setCellValue(1);

// Or do it on one line.
row.createCell(1).setCellValue(1.2);
row.createCell(2).setCellValue(
createHelper.createRichTextString("This is a string"));
row.createCell(3).setCellValue(true);

// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("DataInCells_Apache.xls");
wb.write(fileOut);
fileOut.close();

Aspose.Cells

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Accessing the added worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();

cells.get("A1").setValue("Hello World"); //Adding a string value to the cell
cells.get("A2").setValue(20.5); //Adding a double value to the cell
cells.get("A3").setValue(15); //Adding an integer  value to the cell
cells.get("A4").setValue(true); //Adding a boolean value to the cell

Cell cell = cells.get("A5"); //Adding a date/time value to the cell
cell.setValue(java.util.Calendar.getInstance());

//Setting the display format of the date
Style style = cell.getStyle();
style.setNumber(15);
cell.setStyle(style);

workbook.save("DataInCells_Aspose.xls"); //Saving the Excel file

Download Source Code

Updated