CODEWITHSUNDEEP
javaexcelapache-poi
SHam
SHam

Reputation: 33

How to write Excel file by using String List

I want to write a excel file. all writing details consist with a list. and set it as input parameter for the method. Please tell me the best way to do this.

public static void writeExcelFile(List<String> combineLists){
          XSSFWorkbook workbook = new XSSFWorkbook(); 
          XSSFSheet sheet = workbook.createSheet("Employee Data");
|
|

}

Input list:

Upvotes: 2

Views: 18119

Answers (1)

Kid101
Kid101

Reputation: 1470

Your Images says you have a list of string inside List where as your Input parameter has only list as a parameter. So I'll assume it is List<List<String>>

   FileOutputStream out = new FileOutputStream(new File("demo.xlsx"));
            XSSFWorkbook workbook = new XSSFWorkbook();
            XSSFSheet sheet = workbook.createSheet("Employee Data");
//I am creating and adding list just for illustration purpose only
            List<String> l1 = new ArrayList<String>();
            l1.add(" l1 1");
            l1.add("l1 2");
            List<String> l2 = new ArrayList<String>();
            l2.add(" l2 1");
            l2.add("l2 2");
            List<List<String>> list = new ArrayList<List<String>>();
            list.add(l1);
            list.add(l2);
            Iterator <List<String>>i = list.iterator();
            int rownum=0;
            int cellnum = 0;
            while (i.hasNext()) {
                List<String> templist = (List<String>) i.next();
                Iterator<String> tempIterator= templist.iterator();
                Row row = sheet.createRow(rownum++);
                cellnum = 0;
                while (tempIterator.hasNext()) {
                    String temp = (String) tempIterator.next();
                        Cell cell = row.createCell(cellnum++);
                                cell.setCellValue(temp);

                    }

                }
            workbook.write(out);
            out.close();
            workbook.close();

I hope this helps.

Upvotes: 3

Related Questions