poi 导入Excel文件

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>

public String importExcel(MultipartFile file){
	InputStream is = file.getInputStream();
	//获取文件名字
	String filename = file.getOriginalFilename().toLowerCase();
	//上传
	file.transferTo(new File("D://")+filename);
	//利用WorkbookFactory无需判断Excel版本
	Workbook workbook = WorkbookFactory.create(is);
	Sheet sheet = workbook.getSheetAt(0);
	//获取总行数
	int rowCount = sheet.getPhysicalNumberOfRows();
	//获取总列数
	int celCount = sheet.getRow(0).getPhysicalNumberOfCells();
	for (int i = 1; i < rowCount; i++) {
		Row rowData = sheet.getRow(i);
		//行不为空
		if(rowData != null) {
			for (int j = 0; j < celCount ; j++) {
				String cellData = (String) getCellFormatValue(rowData.getCell(j));
				//开始处理数据
                switch (j) {
                    case 0:
                       //第一行第一列
                       break;
                   case 1:
                       //第一行第二列
                       break;
                 }
			}
		}else {
            continue;
        }
	}
	return "导入成功！";
}

//Excel格式
	public static Object getCellFormatValue(Cell cell){

		Object cellValue = null;

		if(cell!=null){
			//判断cell类型
			switch(cell.getCellType()){
				case HSSFCell.CELL_TYPE_STRING://字符串
					cellValue = cell.getStringCellValue();
					break;

				case HSSFCell.CELL_TYPE_BOOLEAN://布尔
					cellValue = String.valueOf(cell.getBooleanCellValue());
					break;

				case HSSFCell.CELL_TYPE_BLANK://空
					cellValue = "";
					break;

				case HSSFCell.CELL_TYPE_NUMERIC:
					if (HSSFDateUtil.isCellDateFormatted(cell)) {//日期
						Date date = cell.getDateCellValue();
						cellValue = new SimpleDateFormat("yyyy-MM-dd").format(date);
					} else {
						//不是日期格式，则防止当数字过长时以科学计数法显示
						cell.setCellType(HSSFCell.CELL_TYPE_STRING);
						cellValue = cell.toString();
					}
					break;

				case HSSFCell.CELL_TYPE_FORMULA://函数
					try {
						cellValue = String.valueOf(cell.getStringCellValue());
					} catch (IllegalStateException e) {
						cellValue = String.valueOf(cell.getNumericCellValue());
					}
					break;

				case Cell.CELL_TYPE_ERROR:
					cellValue = "";
					break;
			}
		}else{
			cellValue = "";
		}
		return cellValue;
	}