public XSSFWorkbook loadXLSAndPrintFirstColumn(File xlsFile) {
InputStream inputStream = null;
try {
inputStream = new FileInputStream(xlsFile);
XSSFWorkbook xssFWorkbook = new XSSFWorkbook(inputStream);
Sheet sheet = workbook.getSheetAt(workbook.getActiveSheetIndex());
for (int index = 0; index < sheet.getPhysicalNumberOfRows(); index++) {
try {
Row row = sheet.getRow(index);
System.out.println(row.getCell(0,Row.CREATE_NULL_AS_BLANK).getStringCellValue()));
} catch (Exception e) {
System.out.println("Exception");
}
}
}
|