1、安装引用Apache POI
Maven中pom.xml添加如下:
org.apache.poi
poi
4.0.1
org.apache.poi
poi-ooxml
4.0.1
2、读取Excel中时间日期数据InputStream inputStream = new FileInputStream("D://test.xlsx");
XSSFWorkbook wb = new XSSFWorkbook(inputStream);
Sheet sheet = wb.getSheetAt(0);
Cell cell = sheet.getRow(0).getCell(0);// 获取第一行第一列的单元格
if (cell != null)
{
if (cell.getCellTypeEnum() != CellType.STRING && HSSFDateUtil.isCellDateFormatted(cell))
{
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date date = HSSFDateUtil.getJavaDate(cell.getNumericCellValue());
String value = sdf.format(date);
System.out.println(value);
}
}
wb.close();
3、读取Excel中其它数据//1.使用流读取文件