public void readExcelFile(String filePath, int sheetNo) {
try {
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(filePath));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(sheetNo);
HSSFRow row;
HSSFCell cell;
int totalRow = sheet.getPhysicalNumberOfRows();
for (int i = 0; i < totalRow; i++) {
row = sheet.getRow(i);
int lastCell = row.getLastCellNum();
for (int j = 0; j < lastCell; j++) {
try {
cell = row.getCell((short) j);
int dataType = cell.getCellType();
switch (dataType) {
case 0: System.out.print(cell.getNumericCellValue() + "\t");
break;
case 1:
System.out.print(cell.getStringCellValue() + "\t");
break;
}
} catch (Exception e) {
e.printStackTrace();
}
}
System.out.println();
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
No comments:
Post a Comment