依赖
<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>5.2.5</version> </dependency>
代码
package com.test.excel;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.File;
import java.nio.file.Files;
public class ExcelRateOneTest {
public static void main(String[] args) {
File file = new File("D:\\年轻干部人才库名册.xls");
try {
Workbook workbook = null;
try {
workbook = new XSSFWorkbook(Files.newInputStream(file.toPath()));
} catch (Exception e) {
System.out.println("该excel文件不是xlsx类型"+e.getMessage());
}
try {
if (null == workbook) {
workbook = new HSSFWorkbook(Files.newInputStream(file.toPath()));
}
} catch (Exception e) {
System.out.println("该文件不是excel文件"+e.getMessage());
}
if (workbook != null) {
Sheet sheet = workbook.getSheetAt(0);
Row row = sheet.getRow(0);
Cell cell = row.getCell(0);
System.out.println("单元格内容:" + getCellValue(cell));
}
}catch (Exception e){
System.out.println(e.getMessage());
}
}
/**
* 根据单元格类型获取单元格内容,将内容转为字符串类型
* @param cell 单元格
* @return
*/
public static String getCellValue(Cell cell) {
if (cell == null) {
return "";
}
switch (cell.getCellType()) {
case STRING:
return cell.getStringCellValue();
case NUMERIC:
return cell.getNumericCellValue() + "";
case BOOLEAN:
return cell.getBooleanCellValue() + "";
case FORMULA:
return cell.getCellFormula() + "";
default:
return "";
}
}
}