Java program to write to excel file using apache poi

 Here is the java function to write to excel file using apache poi and testng

First add the following dependencies into maven project as we are using the testNG framework and maven project or if you are not using maven project then add respective JAR files into your project.

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi-ooxml</artifactId>

<version>5.0.0</version>

</dependency>

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi</artifactId>

<version>4.1.2</version>

</dependency>

<dependency>

<groupId>org.testng</groupId>

<artifactId>testng</artifactId>

<version>7.4.0</version>

<scope>test</scope>

</dependency>

package writetoexcel;

import java.io.IOException;

import java.util.ArrayList;

import java.util.Collection;

import java.util.Collections;

import java.util.List;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class WriteExcel {

public void writeunmatchedData(List<String> data, String name) throws IOException

{

XSSFWorkbook wb = new XSSFWorkbook();

XSSFSheet sheet = wb.createSheet(name);

FileOutputStream fileout = new FileOutputStream("full path to excel file"+name+".xlsx");

int rowCount = data.size();

for (int i =0; i<rowCount; i++)

{

XSSFRow row = sheet.createRow(i);

XSSFCell cell = row.createCell(0);

cell.setCellValue(data.get(i));

}

wb.write(fileout);

System.out.println(name +" Excel written is completed");

}

}

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE suite SYSTEM "http://testng.org/testng-1.0.dtd" >

<suite name="apachepoi_Demo">

<test verbose="2" name="Default test">

    <classes>

    

      <class name="Com.WriteExcel"/>       

</classes>

</test>

</suite>