<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
FileInputStream fis = new FileInputStream("path/to/excel/file.xls");
Workbook workbook = new HSSFWorkbook(fis);
Sheet sheet = workbook.getSheetAt(0);
for (Row row : sheet) {
for (Cell cell : row) {
System.out.println(cell.getStringCellValue());
}
}
fis.close();
Workbook workbook = new HSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("Hello, World!");
FileOutputStream fos = new FileOutputStream("path/to/excel/file.xls");
workbook.write(fos);
fos.close();
try {
FileInputStream fis = new FileInputStream("path/to/excel/file.xls");
fis.close();
} catch (IOException e) {
}
