使用apache的poi生成本地Excel文件

Bertha 。 2023-01-17 06:24 116阅读 0赞

导入poi和hutool-all的pom依赖

<dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.16</version>
    </dependency>
    
    <dependency>
        <groupId>cn.hutool</groupId>
        <artifactId>hutool-all</artifactId>
        <version>5.4.0</version>
    </dependency>

示例代码如下：

import cn.hutool.json.JSONObject;
    import cn.hutool.json.JSONUtil;
    import org.apache.poi.hssf.usermodel.HSSFSheet;
    import org.apache.poi.hssf.usermodel.HSSFWorkbook;
    import org.apache.poi.ss.usermodel.Cell;
    import org.apache.poi.ss.usermodel.Row;
    
    import java.io.FileOutputStream;
    import java.io.IOException;
    import java.io.OutputStream;
    import java.util.ArrayList;
    import java.util.List;
    
    public class demo {
    
        public static void main(String[] args){
            List<String> dataList =new ArrayList<>();
            dataList.add("{\"name\":\"张三\",\"age\":\"18\"}");
            dataList.add("{\"name\":\"李四\",\"age\":\"19\"}");
            dataList.add("{\"name\":\"王五\",\"age\":\"20\"}");
            writeExcel(dataList);
        }
    
        public static void writeExcel(List<String> dataList){
            OutputStream out = null;
            try {
                //1.创建一个sheet,并往sheet中填充内容
                HSSFWorkbook workbook=new HSSFWorkbook();
                HSSFSheet sheet=workbook.createSheet("sheet1");
                Row firstRow = sheet.createRow(0);
                firstRow.createCell(0).setCellValue("姓名");
                firstRow.createCell(1).setCellValue("年龄");
                for (int j = 0; j < dataList.size(); j++) {
                    //从第二行开始,开始循环创建行
                    Row row = sheet.createRow(j + 1);
                    String data = dataList.get(j);
                    JSONObject dataJsonObject = JSONUtil.parseObj(data);
                    String name =dataJsonObject.getStr("name");
                    String age = dataJsonObject.getStr("age");
                    Cell first = row.createCell(0);
                    first.setCellValue(name);
                    Cell second = row.createCell(1);
                    second.setCellValue(age);
                }
                //2.创建文件输出流
                out =  new FileOutputStream("E:\\名单.xlsx");
                //3.将Sheet中的内容写入到Excel文件中
                workbook.write(out);
            } catch (Exception e) {
                e.printStackTrace();
            } finally{
                try {
                    if(out != null){
                        out.flush();
                        out.close();
                    }
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
            System.out.println("操作完成");
        }
    }