poi实现多张图片导出到excel一个单元格

旧时光里的歌

于 2024-03-13 16:51:46 发布

阅读量1.1k

点赞数 11

CC 4.0 BY-SA版权

文章标签： excel java

本文链接：https://blog.csdn.net/qq_34315636/article/details/136684919

public static void main(String[] args) {
        // 模拟数据源
        List<Person> personList = new ArrayList<>();
        personList.add(new Person("Alice", "Female", Arrays.asList("D:\\文件\\test\\1.jpg")));
        personList.add(new Person("Bob", "Male", Arrays.asList("D:\\文件\\test\\1.jpg","D:\\文件\\test\\2.jpg")));
       exportExcelImg(personList);
    }
    private static void exportExcelImg(List<Person> personList) {
        XSSFWorkbook wb = new XSSFWorkbook();
        try {
            Sheet sheet = wb.createSheet();
            // 创建表头
            Row headerRow = sheet.createRow(0);
            String[] columns = {"姓名", "性别", "照片"};
            for (int i = 0; i < columns.length; i++) {
                Cell cell = headerRow.createCell(i);
                cell.setCellValue(columns[i]);
            }
            Drawing patriarch = sheet.createDrawingPatriarch();
            int rowNum = 1;
            for (Person person : personL