try (InputStream is = new FileInputStream("file.xlsx")) {
Workbook workbook = WorkbookFactory.create(is);
Sheet sheet = workbook.getSheetAt(0);
DataFormatter formatter = new DataFormatter();
Iterator<Row> rowIterator = sheet.rowIterator();
while (rowIterator.hasNext()) {
Row row = rowIterator.next();
Iterator<Cell> cellIterator = row.cellIterator();
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
String cellValue = formatter.formatCellValue(cell);
System.out.println(cellValue);
}
}
} catch (IOException e) {
e.printStackTrace();
}
try (InputStream is = new FileInputStream("file.xlsx")) {
Workbook workbook = WorkbookFactory.create(is);
BigDataConfig config = new BigDataConfig();
XLSTransformer transformer = new XLSTransformer(config);
List<MyData> dataList = transformer.transformMultipleSheetsList(workbook, new HashMap<>(), MyData.class);
for (MyData data : dataList) {
// ...
}
} catch (IOException e) {
e.printStackTrace();
}
