java使用POI读取和写入excel内容

1.读取excel中的内容

    public void excelRead() throws IOException {

        String filePath = "E:\\case.xlsx";
        //获取excel文件的文件输入流
        FileInputStream inFiele = new FileInputStream(filePath);
        //获取excel的WorkBook
        Workbook workbook = WorkbookFactory.create(inFiele);
        //获取sheet
        Sheet sheet = workbook.getSheetAt(0);
        //获取excel的总行数
        int rowNum = sheet.getLastRowNum();
        System.out.println("excel文件的行数是："+rowNum);
        //获取excel中某一行的列数
        short cellNum = sheet.getRow(0).getLastCellNum();
        System.out.println("excel文件的列数是"+cellNum);

        //获取应第4行第5列的值
//        Cell cell = sheet.getRow(3).getCell(4);
//        cell.setCellType(CellType.STRING);
//        String stringCellValue = cell.getStringCellValue();
//        System.out.println(stringCellValue);

        for(int i=0;i<=rowNum;i++){
            Row row = sheet.getRow(i);
            for(int j=0;j<row.getLastCellNum();j++){
                //获取指定的单元格
                Cell cell = row.getCell(j);
                //将单元格中内容的类型设置为String
                cell.setCellType(CellType.STRING);
                //获取单元格中的内容
                System.out.print(cell.getStringCellValue()+"     ");
            }
            System.out.println();
        }
        //关闭文件流
        inFiele.close();

    }

2.在excel中写入内容

    public void excelWrite() throws IOException {

        String filePath = "E:\\case.xlsx";
        //获取excel文件的文件输入流
        FileInputStream inFile = new FileInputStream(filePath);
        //获取excel的WorkBook
        Workbook workbook = WorkbookFactory.create(inFile);
        //获取excel的sheet
        Sheet sheet = workbook.getSheetAt(0);
        //获取excel的行数
        int rowNum = sheet.getLastRowNum();

        //在最后一列的第一列添加"结束"
        Cell cell = sheet.getRow(rowNum+1).getCell(0);
        cell.setCellType(CellType.STRING);
        cell.setCellValue("结束");

        //获取excel文件的文件输出流
        FileOutputStream outFile = new FileOutputStream(filePath);
        //
        workbook.write(outFile);
        //关闭文件流
        outFile.close();
    }