+3 votes
in Programming by (1.9k points)

I want to store my results in excel sheet ,My results are in the form of string. actually there are some condition if they are true i am printing results in logger but want to store them in excel so that any one can see results. 

like : 


System.out.println(String1 and String2 are same);

// here i want to store results in Excel.


I hope you got my question ...Thanks for help!


1 Answer

+2 votes
by Expert (3.8k points)
selected by
Best answer

You can use this code its for writing excel from java and you can modify according to your need.

package test;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import org.apache.poi.hpsf.HPSFException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class finalExcel {
    public static void main(String[] args) throws HPSFException {
        ArrayList data = new ArrayList();
        ArrayList headers = new ArrayList();
        java.util.Date date= new java.util.Date();
        File file123 = new File("D:\\sample"+date.getTime()+".xls");
        for (int i = 0; i <= 5; i++) {
            ArrayList cells = new ArrayList();
            randomstring str = new randomstring();
            randomstring str1 = new randomstring();
            String t = str.genString(5);
            String t1 = str1.genString(5);
            cells.add("ENO" + i);
        exportToExcel("Test", headers, data, file123);
    public static void exportToExcel(String sheetName, ArrayList headers,
            ArrayList data, File outputFile) throws HPSFException {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet(sheetName);
        int rowIdx = 0;
        short cellIdx = 0;
        // Header
        HSSFRow hssfHeader = sheet.createRow(rowIdx);
        HSSFCellStyle cellStyle = wb.createCellStyle();
        for (Iterator cells = headers.iterator(); cells.hasNext();) {
            HSSFCell hssfCell = hssfHeader.createCell(cellIdx++);
            hssfCell.setCellValue((String) cells.next());
        // Data
        rowIdx = 1;
        for (Iterator rows = data.iterator(); rows.hasNext();) {
            ArrayList row = (ArrayList) rows.next();
            HSSFRow hssfRow = sheet.createRow(rowIdx++);
            cellIdx = 0;
            for (Iterator cells = row.iterator(); cells.hasNext();) {
                HSSFCell hssfCell = hssfRow.createCell(cellIdx++);
                hssfCell.setCellValue((String) cells.next());
      //  wb.setSheetName(0, sheetName, HSSFWorkbook);
        try {
            FileOutputStream outs = new FileOutputStream(outputFile);
        } catch (IOException e) {
            throw new HPSFException(e.getMessage());
Enjoy... :)
by (1.9k points)
Nice its really works, thanks finally I got the solution.
by Expert (6.4k points)
Thanks @jatin this code helped me also.

Not a Member yet?

Ask to Folks Login

My Account

Your feedback is highly appreciated