智能商贸系统08-POI与EasyPOI导入导出

1、POI

官方网址：https://poi.apache.org/

1.1、导包

<!-- poi支持的jar包 -->
<dependency>
  <groupId>org.apache.poi</groupId>
  <artifactId>poi</artifactId>
  <version>3.11</version>
</dependency>
<dependency>
  <groupId>org.apache.poi</groupId>
  <artifactId>poi-ooxml</artifactId>
  <version>3.11</version>
</dependency>

1.2、创建Excel(完成99乘法表)

 /*
     * 99乘法表
     * */
    @Test
    public void testCreateExcel() throws Exception {
   
        /*
         * 1、创建一个工作簿
         *      放在内存中
         *      里面什么都没有
         * */
        SXSSFWorkbook wb = new SXSSFWorkbook();
        //2、创建一张sheet
        Sheet sheet = wb.createSheet("99");
        //3、创建行
        for (int i = 1; i <= 9; i++) {
   
            Row row = sheet.createRow(i - 1);
            //4、创建列
            for (int j = 1; j <= i; j++) {
   
                Cell cell = row.createCell(j - 1);
                //5、格子内写
                cell.setCellValue(i + "×" + j + "=" + (i * j));
            }
        }
        FileOutputStream out = new FileOutputStream("99.xlsx");
        wb.write(out);
        out.close();

        // dispose of temporary files backing this workbook on disk
        wb.dispose();
    }

1.3、读取Excel

@Test
    public void testReadExcel() throws Exception {
   
        //1、读取文件到内容中
        Workbook wb = WorkbookFactory.create(new FileInputStream("99.xlsx"));
        //2、读取第一个表(根据表名或者序号。从0开始）
        Sheet sheetAt = wb.getSheetAt(0);
        //3、获取总行数
        int lastRowNum = sheetAt.getLastRowNum();
        for (int i = 0; i <lastRowNum ; i++) {
   
            //4、获取到行
            Row row = sheetAt.getRow(i);
            //5、获取总列数
            short lastCellNum = row.getLastCellNum();
            //6、获取单元格
            for (int j = 0; j < lastCellNum; j++) {
   
                Cell cell = row.getCell(j);
                System.out.print(cell.getStringCellValue()+" ");
            }
            System.out.println();
        }
    }

2、EasyPOI

官方文档:http://easypoi.mydoc.io/

2.1、导包

• 注意：EasyPOI的包和poi的包可能会产生冲突，所以先将poi的包删除

<!-- easypoi的支持 -->
<dependency>
  <groupId>cn.afterturn</groupId>
  <artifactId>easypoi-base</artifactId>
  <version>3.2.0</version>
</dependency>
<dependency>
  <groupId>cn.afterturn</groupId>
  <artifactId>easypoi-web</artifactId>
  <version>3.2.0</version>