/**
* 解析excel
*
* @param fileName
*/
public void parseExcelFile(String fileName) {
// String fileName = System.getProperty("user.dir") +
// "\\resources\\excelParse.xlsx";
InputStream in = null;
try {
in = new FileInputStream(fileName);
XSSFWorkbook workBook = new XSSFWorkbook(in);
int sheetNum = workBook.getNumberOfSheets();
XSSFSheet sheet = workBook.getSheetAt(sheetNum);
sheetNum--;
int rowNum = sheet.getLastRowNum();
if (rowNum > 0) {
for (int i = 0; i < rowNum; i++) {
XSSFRow row = sheet.getRow(rowNum);
if (row != null) {
int cellNum = row.getLastCellNum();
for (int j = 0; j < cellNum; j++) {
XSSFCell cell = row.getCell(cellNum);
String cellValue = getCellValue(cell);
}
}
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
poi解析Excel,格式化日期类型
最新推荐文章于 2024-06-11 21:53:41 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)