Creating a Cell at specific position in Excel file using Java

Apache POI can be used to create a cell in a Given Excel file at specific position. Apache POI is an API provided by Apache foundation.

Steps to Create a Cell at specific position in a given Excel File:

Create a maven project(Maven is a build automation tool used primarily for Java projects) in eclipse or a Java project with POI library installed

Add following maven dependency in pom.xml file

<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency> 
      <groupId>org.apache.poi</groupId> 
      <artifactId>poi</artifactId> 
      <version>3.12</version> 
    </dependency> 
    <dependency> 
      <groupId>org.apache.poi</groupId> 
      <artifactId>poi-ooxml</artifactId> 
      <version>3.12</version> 
    </dependency> 

Write java code in javaresource folder

import java.io.*; 
import org.apache.poi.hssf.usermodel.HSSFWorkbook; 
import org.apache.poi.ss.usermodel.Cell; 
import org.apache.poi.ss.usermodel.Row; 
import org.apache.poi.ss.usermodel.Sheet; 
import org.apache.poi.ss.usermodel.Workbook; 
  
public class CreateCellAtSpecificPosition { 
    public static void main(String[] args) throws FileNotFoundException, IOException 
    { 
        // Create a workbook instances 
        Workbook wb = new HSSFWorkbook(); 
  
        OutputStream os = new FileOutputStream("Geeks.xlsx"); 
  
        // Creating a sheet using predefined class provided by Apache POI 
        Sheet sheet = wb.createSheet("Company Prepration"); 
  
        // Creating a row at specific position 
        // using predefined class provided by Apache POI 
  
        // Specific row number 
        Row row = sheet.createRow(1); 
  
        // Specific cell number 
        Cell cell = row.createCell(1); 
  
        // putting value at specific position 
        cell.setCellValue("Geeks"); 
  
        // writing the content to Workbook 
        wb.write(os); 
  
        System.out.println("given cell is created at position (1, 1)"); 
    } 
} 

Output

given cell is created at position (1, 1)

Output in Geeks.xlsx File

My Personal Notes

Recommended Posts: