java 使用反射将数据写入Excel

最新推荐文章于 2025-04-29 15:04:27 发布

原创最新推荐文章于 2025-04-29 15:04:27 发布 · 882 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java #excel #反射

java 专栏收录该内容

83 篇文章

订阅专栏

本文介绍了一个使用Java进行批量写入Excel文件的方法。该方法通过指定文件名、工作表名、对象列表及字段映射来创建Excel文件，并实现了对私有字段的访问。此示例适用于需要批量导出数据至Excel表格的应用场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 public void writeData(String fileName, String sheetName, List<Object> list, Map<String, String> colMap)
            throws IOException, WriteException, IllegalAccessException, NoSuchFieldException {
        File file = new File(fileName);
        file.createNewFile();
        OutputStream os = new FileOutputStream(file);
        WritableWorkbook wwb = Workbook.createWorkbook(os);
        WritableSheet writableSheet = wwb.createSheet(sheetName, 0);

        int rowIndex = 0;
        int colIndex = 0;
        Iterator iterator = colMap.entrySet().iterator();
        List<String> colList = new ArrayList<>();

        while (iterator.hasNext()) {
            Map.Entry entry = (Map.Entry) iterator.next();
            colList.add(entry.getValue().toString());

            WritableFont wf = new WritableFont(WritableFont.createFont("宋体"), 10, WritableFont.BOLD, false);
            WritableCellFormat wcf = new WritableCellFormat(wf);
            Label label = new Label(colIndex, rowIndex, entry.getKey().toString(), wcf);
            writableSheet.addCell(label);
            colIndex++;
        }

        rowIndex++;

        for (Object obj :
                list) {
            colIndex = 0;
            for (String str :
                    colList) {
                Field field = obj.getClass().getDeclaredField(str);
                field.setAccessible(true);
                Label label = new Label(colIndex, rowIndex, field.get(obj).toString());
                writableSheet.addCell(label);
                colIndex++;
            }
            rowIndex++;
        }

        wwb.write();
        wwb.close();
        os.flush();
        os.close();

    }