Write XLSX using Apache POI-Maven Project

Apache POI (Poor Obfuscation Implementation File System) is the Java API for Microsoft Documents such as XLS,XLSX,DOC and PPT as well.
HSSF (Horrible Spreadsheet Format)
Read or write an Excel file format – XLS
XSSF (XML Spreadhsheet Format)
Read or write an Excel file format – XLSX
To download the Apache POI Library access the below link -> https://poi.apache.org/download.html
Download the Binary Distribution

Linux : poi-bin-xx.tar.gz
Windows : poi-bin-xx.zip

Writing the XLSX in JAVA project
1. Create JAVA Project
2. Add the dependencies of the Apache POI to the Build Path of the project.

Java Project – Build Path

3. Create a XLSX file with rows and columns

Xlsx File

4. Write the logic to write the data to the XLSX.


package total.qa.apache.poi.readxlsx;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * Write XLSX using Apache POI API
 * @author qa
 *
 */

public class WriteXLSX {
	public static void main(String args[]) throws IOException
	{
		File f = new File("TestCaseData.xlsx");
		FileInputStream fis = new FileInputStream(f);
		XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);
		XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);
		XSSFCell cell=excelSheet.getRow(0).createCell(2);//row index - 0,column index-2
		cell.setCellType(CellType.STRING);
		cell.setCellValue("Pass");
		FileOutputStream fos = new FileOutputStream("TestCaseData.xlsx");
		excelWorkbook.write(fos);
		fos.close();
		fis.close();
		
		
		
	}

}

package total.qa.apache.poi.readxlsx;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import org.apache.poi.ss.usermodel.CellType;

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

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

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

/**

* Write XLSX using Apache POI API

* @author qa

public class WriteXLSX {

public static void main(String args[]) throws IOException

{

File f = new File("TestCaseData.xlsx");

FileInputStream fis = new FileInputStream(f);

XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);

XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);

XSSFCell cell=excelSheet.getRow(0).createCell(2);//row index - 0,column index-2

cell.setCellType(CellType.STRING);

cell.setCellValue("Pass");

FileOutputStream fos = new FileOutputStream("TestCaseData.xlsx");

excelWorkbook.write(fos);

fos.close();

fis.close();

}

Writing the XLSX in maven project
1. Create MAVEN Project
2. Add the following dependencies in the MAVEN pom.xml
https://mvnrepository.com/artifact/org.apache.poi/poi
https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml

Maven Dependency- Apache POI

3. Write the logic to write the data to the XLSX.


package total.qa.apache.poi.readxlsx;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * Write XLSX using Apache POI API
 * @author qa
 *
 */

public class WriteXLSX {
	public static void main(String args[]) throws IOException
	{
		File f = new File("TestCaseData.xlsx");
		FileInputStream fis = new FileInputStream(f);
		XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);
		XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);
		XSSFCell cell=excelSheet.getRow(0).createCell(2);//row index - 0,column index-2
		cell.setCellType(CellType.STRING);
		cell.setCellValue("Pass");
		FileOutputStream fos = new FileOutputStream("TestCaseData.xlsx");
		excelWorkbook.write(fos);
		fos.close();
		fis.close();
		
		
		
	}

}