Workbook workbook = StreamingReader.builder()
for (Sheet sheet : workbook){
for (Row row : sheet) {
}
}
Cell cell = row.getCell(0);
String value = cell.getStringCellValue();
workbook.close();
inputStream.close();
import com.monitorjbl.xlsx.StreamingReader;
import org.apache.poi.ss.usermodel.*;
import java.io.FileInputStream;
import java.io.InputStream;
public class ExcelProcessingExample {
public static void main(String[] args) throws Exception {
InputStream inputStream = new FileInputStream("path/to/excel.xlsx");
Workbook workbook = StreamingReader.builder()
.rowCacheSize(100)
.bufferSize(4096)
.open(inputStream);
for (Sheet sheet : workbook){
for (Row row : sheet) {
for (Cell cell : row) {
String value = cell.getStringCellValue();
System.out.println(value);
}
}
}
workbook.close();
inputStream.close();
}
}
