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:

1. 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
2. Add following maven dependency in pom.xml file
   filter_none

   edit
   close

   play_arrow

   link
   brightness_4
   code

   <!-- 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>

   chevron_right

   filter_none

3. Write java code in javaresource folder
   filter_none

   edit
   close

   play_arrow

   link
   brightness_4
   code

   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)");     } }

   chevron_right

   filter_none

Output

given cell is created at position (1, 1)

Output in Geeks.xlsx File

Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.

Shahnawaz_Ali

Check out this Author's contributed articles.