Requirment – How to write an excel file in Java
Solutions– Well Apache POI is answer.This API will help you a lot.you have to download and add the POI JAR file to your project’s class path. The Apache POI JAR file can be found http://poi.apache.org/download.html
Following is code –
public static void main(String[] args) throws IOException { // Directory path where the xls file will be created String filePath = "C:/Vinay/ApachePoi/VinayExcel.xls"; FileOutputStream fout = new FileOutputStream(filePath ); ByteArrayOutputStream outputStream = new ByteArrayOutputStream(); HSSFWorkbook workBook = new HSSFWorkbook(); // Create the spreadsheet HSSFSheet spreadSheet = workBook.createSheet("vinay_sheet"); // Create the first row HSSFRow row = spreadSheet.createRow((short) 0); // Create the cells and write to the file HSSFCell cell; cell = row.createCell(0); cell.setCellValue(new HSSFRichTextString("Vinay")); cell = row.createCell(1); cell.setCellValue(new HSSFRichTextString("Kumar")); workBook.write(outputStream); outputStream.writeTo(fout); outputStream.close(); fout.close(); }
Happy coding with Vinay in techartifact