/**
* 解析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-08-19 09:53:47 发布
这篇博客介绍了如何利用Apache POI库解析07版Excel,并特别关注了日期类型的格式化处理。博主探讨了如何判断单元格类型,如函数、数字、字符串,并确保输出的格式与原Excel单元格保持一致。
摘要由CSDN通过智能技术生成