通过POI追加数据到excel中小案例

最新推荐文章于 2024-01-05 17:41:29 发布

lang20150928

最新推荐文章于 2024-01-05 17:41:29 发布

阅读量131

点赞数

分类专栏： poi 文章标签： java 前端 apache

本文链接：https://blog.csdn.net/m0_37607945/article/details/125624579

版权

poi 专栏收录该内容

10 篇文章 1 订阅

订阅专栏

当前poi的版本为

<poi.veriosn>4.1.2</poi.veriosn>

相关依赖

      <!-- apache POI for xls -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>${poi.veriosn}</version>
        </dependency>
        <!-- apache POI for xlsx -->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>${poi.veriosn}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml-schemas</artifactId>
            <version>${poi.veriosn}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-scratchpad</artifactId>
            <version>${poi.veriosn}</version>
        </dependency>

案例代码

   public static void main(String[] args) throws IOException {
        String fileName = "D:\\data\\excel\\workbook.xls";
        File file = new File(fileName);
        if (file.exists()) {
            FileUtils.forceDelete(file);
        }
        // 首先创建一个空的excel
        try (Workbook wb = WorkbookFactory.create(false)) {
            Sheet wbSheet = wb.createSheet();
            Row row = wbSheet.createRow(0);
            Cell cell = row.createCell(0);
            cell.setCellValue("First Row");
            try (FileOutputStream fileOut = new FileOutputStream(fileName)) {
                wb.write(fileOut);
            }
        }

        for (int i = 0; i < 10; i++) {
            // 根据指定的流创建excel
            try (Workbook wb = WorkbookFactory.create(new FileInputStream(fileName))) {
                Sheet wbSheet = wb.getSheetAt(0);
                Row row = wbSheet.createRow(i + 1);
				Cell cell = row.createCell(i);
                cell.setCellValue("Hello World!" + i);
                try (FileOutputStream fileOut = new FileOutputStream(fileName)) {
                    wb.write(fileOut);
                }
            }
        }
    }