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
<
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_rightfilter_none - 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)"
);
}
}
chevron_rightfilter_none
Output
given cell is created at position (1, 1)
Output in Geeks.xlsx File