读取Excel中的图片

最新推荐文章于 2024-07-19 15:08:22 发布

ZZZZVSS

最新推荐文章于 2024-07-19 15:08:22 发布

阅读量1.2k

点赞数

分类专栏： java，工具类

本文链接：https://blog.csdn.net/zhengsaisai/article/details/106849485

版权

java，工具类专栏收录该内容

28 篇文章 0 订阅

订阅专栏

Maven:

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>
<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi</artifactId>
   <version>3.17</version>
 </dependency>

Code:

File excelFile = new File("C:\\Users\\Administrator\\Desktop\\C.xlsx");
		XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(excelFile));
		// 读取图片
		List<XSSFPictureData> pictures = wb.getAllPictures();
		for (int i = 0; i < pictures.size(); i++) {
			XSSFPictureData pictureData = pictures.get(i);
			byte[] picData = pictureData.getData();
			// File file = new File("C:\\Users\\Administrator\\Desktop\\IMG\\" +
			// RandomUtil.randomString(8) + ".png");
			FileOutputStream out = new FileOutputStream(
					"C:\\Users\\Administrator\\Desktop\\C\\c000" + (i + 1) + ".png");
			out.write(picData);
			out.close();
		}