Wiki
Clone wikiAspose 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