<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>
<dependency>
<groupId>com.monitorjbl</groupId>
<artifactId>xlsx-streamer</artifactId>
<version>2.1.0</version>
</dependency>
import com.monitorjbl.xlsx.StreamingReader;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import java.io.FileInputStream;
import java.io.InputStream;
public class ExcelStreamingReaderExample {
public static void main(String[] args) {
try {
InputStream is = new FileInputStream("path/to/excel/file.xlsx");
StreamingReader reader = StreamingReader.builder()
.open(is);
for (Sheet sheet : reader) {
for (Row row : sheet) {
for (int i = 0; i < row.getLastCellNum(); i++) {
System.out.print(row.getCell(i) + "\t");
}
System.out.println();
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
