Java 获取导入Excel文件数据

Java 获取导入Excel文件数据

    需要导入依赖

       <dependency>

         <groupId>org.apache.poi</groupId>

         <artifactId>poi</artifactId>

         <version>3.14</version>

      </dependency>

      <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->

      <dependency>

         <groupId>org.apache.poi</groupId>

         <artifactId>poi-ooxml</artifactId>

         <version>3.14</version>

      </dependency>

 

 

FileInputStream is = new FileInputStream(uploadFile); //文件流

Workbook workbook = null;

try {

    workbook = WorkbookFactory.create(is); //这种方式 Excel 2003/2007/2010 都是可以处理的

} catch (Exception e) {

    e.printStackTrace();

}

int sheetCount = workbook.getNumberOfSheets();  //Sheet的数量

//遍历每个Sheet

for (int s = 0; s < sheetCount; s++) {

    Sheet sheet = workbook.getSheetAt(s);

    int rowCount = sheet.getPhysicalNumberOfRows(); //获取总行数

    //遍历每一行

    for (int r = 0; r < rowCount; r++) {

        Row row = sheet.getRow(r);

        int cellCount = row.getPhysicalNumberOfCells(); //获取总列数

        //遍历每一列

        for (int c = 0; c < cellCount; c++) {

            Cell cell = row.getCell(c);

            String value = getCellValue(cell);

        }

    }

}

 

private  String getCellValue(Cell cell){

    if(cell == null){

        return null;

    }

    String value = null;

    //简单的查检列类型

    switch(cell.getCellType())

    {

        case HSSFCell.CELL_TYPE_STRING://字符串

            value = cell.getRichStringCellValue().getString();

            break;

        case HSSFCell.CELL_TYPE_NUMERIC://数字

            long dd = (long)cell.getNumericCellValue();

            value = dd+"";

            break;

        case HSSFCell.CELL_TYPE_BLANK:

            value = "";

            break;

        case HSSFCell.CELL_TYPE_FORMULA:

            value = String.valueOf(cell.getCellFormula());

            break;

        case HSSFCell.CELL_TYPE_BOOLEAN://boolean型值

            value = String.valueOf(cell.getBooleanCellValue());

            break;

        case HSSFCell.CELL_TYPE_ERROR:

            value = String.valueOf(cell.getErrorCellValue());

            break;

        default:

            break;

    }

    return value;

}