使用java代码实现多行多列且带图片的excel的导入导出

对于多行多列且带图片的excel的导入导出，可以使用Apache POI和Java Excel API这两个Java库来实现。

Apache POI的代码示例：

导入：

try {
    FileInputStream file = new FileInputStream(new File("path/to/excel/file.xlsx"));
    XSSFWorkbook workbook = new XSSFWorkbook(file);
    XSSFSheet sheet = workbook.getSheetAt(0);
    
    // 循环读取每一行
    for (Row row : sheet) {
        // 循环读取每一列
        for (Cell cell : row) {
            // 判断单元格类型，如果是图片类型则处理图片
            if (cell.getCellType() == CellType.PICTURE) {
                // 处理图片
                XSSFPicture picture = (XSSFPicture) cell.getDrawingPatriarch().getChildren().get(0);
                byte[] pictureData = picture.getPictureData().getData();
                // 将图片保存到本地文件中
                FileOutputStream fos = new FileOutputStream("path/to/image.png");
                fos.write(pictureData);
                fos.close();
            } else {
                // 处理文本类型
                String text = cell.getStringCellValue();
                // 处理数值类型
                double value = cell.getNumericCellValue();
            }
        }
    }
    
    file.close();
    workbook.close();
} catch (Exception e) {
    e.printStackTrace();
}

导出：

try {
    XSSFWorkbook workbook = new XSSFWorkbook();
    XSSFSheet sheet = workbook.createSheet("Sheet1");
    
    // 创建样式
    XSSFCellStyle style = workbook.createCellStyle();
    style.setAlignment(HorizontalAlignment.CENTER);
    style.setVerticalAlignment(VerticalAlignment.CENTER);
    
    // 创建字体
    XSSFFont font = workbook.createFont();
    font.setFontName("Arial");
    font.setFontHeightInPoints((short) 12);
    style.setFont(font);
    
    // 创建图片
    byte[] pictureData = Files.readAllBytes(new File("path/to/image.png").toPath());
    int pictureIdx = workbook.addPicture(pictureData, Workbook.PICTURE_TYPE_PNG);
    CreationHelper helper = workbook.getCreationHelper();
    Drawing drawing = sheet.createDrawingPatriarch();
    ClientAnchor anchor = helper.createClientAnchor();
    anchor.setCol1(0);
    anchor.setRow1(0);
    Picture picture = drawing.createPicture(anchor, pictureIdx);
    
    // 创建单元格
    XSSFCell cell = sheet.createRow(0).createCell(0);
    cell.setCellValue("Hello");
    cell.setCellStyle(style);
    
    FileOutputStream fos = new FileOutputStream(new File("path/to/excel/file.xlsx"));
    workbook.write(fos);
    fos.close();
    
    workbook.close();
} catch (Exception e) {
    e.printStackTrace();
}

Java Excel API的代码示例：

导入：

try {
    WorkbookSettings ws = new WorkbookSettings();
    ws.setEncoding("UTF-8");
    File file = new File("path/to/excel/file.xls");
    Workbook workbook = Workbook.getWorkbook(file, ws);
    Sheet sheet = workbook.getSheet(0);
    
    // 循环读取每一行
    for (int i = 0; i < sheet.getRows(); i++) {
        Cell[] row = sheet.getRow(i);
        // 循环读取每一列
        for (int j = 0; j < row.length; j++) {
            Cell cell = row[j];
            // 判断单元格类型，如果是图片类型则处理图片
            if (cell.getType() == CellType.IMAGE) {
                // 处理图片
                byte[] pictureData = cell.getContents().getBytes();
                // 将图片保存到本地文件中
                FileOutputStream fos = new FileOutputStream("path/to/image.png");
                fos.write(pictureData);
                fos.close();
            } else {
                // 处理文本类型
                String text = cell.getContents();
                // 处理数值类型
                double value = Double.parseDouble(text);
            }
        }
    }
    
    workbook.close();
} catch (Exception e) {
    e.printStackTrace();
}

导出：

try {
    WritableWorkbook workbook = Workbook.createWorkbook(new File("path/to/excel/file.xls"));
    WritableSheet sheet = workbook.createSheet("Sheet1", 0);
    
    // 创建样式
    WritableCellFormat format = new WritableCellFormat();
    format.setAlignment(Alignment.CENTRE);
    format.setVerticalAlignment(VerticalAlignment.CENTRE);
    WritableFont font = new WritableFont(WritableFont.ARIAL, 12);
    format.setFont(font);
    
    // 创建图片
    byte[] pictureData = Files.readAllBytes(new File("path/to/image.png").toPath());
    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    baos.write(pictureData);
    int pictureIdx = workbook.addPicture(baos.toByteArray(), WritableWorkbook.IMAGE_PNG);
    WritableImage image = new WritableImage(0, 0, 1, 1, pictureIdx);
    sheet.addImage(image);
    
    // 创建单元格
    Label label = new Label(0, 0, "Hello", format);
    sheet.addCell(label);
    
    workbook.write();
    workbook.close();
} catch (Exception e) {
    e.printStackTrace();
}