使用java导入excel文件
为了使用Java解析Excel文件,您需要使用Apache POI库。以下是解析Excel文件的步骤:
- 添加Apache POI库依赖项。您可以在Maven中添加以下依赖项:
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>
- 获取工作簿对象,一般是通过参数MultpartFile对象来获取的:
//file是参数MultpartFile的一个对象实例
Workbook workbook = null;
try {
InputStream in = file.getInputStream();
workbook = new HSSFWorkbook(in);
}catch(Exception e) {
InputStream in = file.getInputStream();
workbook = new XSSFWorkbook(in);
}
- 获取工作表对象并遍历行和单元格。以下是一个示例代码,用于遍历包含两行三列的电子表格:
Sheet sheet = workbook.getSheetAt(0);
Iterator<Row> rowIterator = sheet.iterator();
while (rowIterator.hasNext()) {
Row row = rowIterator.next();
Iterator<Cell> cellIterator = row.cellIterator();
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
switch (cell.getCellType()) {
case STRING:
System.out.print(cell.getStringCellValue() + "\t");
break;
case NUMERIC:
System.out.print(cell.getNumericCellValue() + "\t");
break;
case BOOLEAN:
System.out.print(cell.getBooleanCellValue() + "\t");
break;
default:
System.out.print("\t");
}
}
System.out.println();
}
- 关闭工作簿和输入流。您可以使用以下代码关闭工作簿和输入流:
workbook.close();
inputStream.close();