java 从excel中读取图片存到本地磁盘

qq_37749055

已于 2024-03-12 16:37:36 修改

阅读量446

点赞数

文章标签： java excel python

于 2023-10-13 13:58:13 首次发布

本文链接：https://blog.youkuaiyun.com/qq_37749055/article/details/133809227

版权

直接保存到本地磁盘

public static void main(String[] args) throws IOException {

    String excelFilePath = "F:/ftproot/METAMSC/20231011/fskbook.xlsx";
    String imagePath = "D:/temp";

    try {
      FileInputStream fis = new FileInputStream(new File(excelFilePath));
      XSSFWorkbook workbook = new XSSFWorkbook(fis);
      XSSFSheet sheet = workbook.getSheetAt(0);
      XSSFDrawing drawings = sheet.getDrawingPatriarch();

        List<XSSFShape> shapes = drawings.getShapes();
      int i=0;
      for (XSSFShape shape : shapes) {
        if (shape instanceof XSSFPicture) {
            ++i;
            if (i ==4){
             continue;
            }

          XSSFPicture picture = (XSSFPicture) shape;
          PictureData pictureData = picture.getPictureData();
          byte[] data = pictureData.getData();
         String imageFileName = UUID.randomUUID().toString