Skip to content
Related Articles

Related Articles

Creating a Cell at specific position in Excel file using Java
  • Difficulty Level : Medium
  • Last Updated : 27 Sep, 2018

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




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

    
    

  3. 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

geeks-digest-img




My Personal Notes arrow_drop_up
Recommended Articles
Page :