JAVA POI的excel中包含圖片進(jìn)行讀取保存,單張圖片,多張圖片

---------------------------------------------效果----------------------------------------------------------

1.單張圖片

2.多張圖片
文章來源地址http://www.zghlxwxcb.cn/news/detail-670945.html

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPicture;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFShape;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.PictureData;

public class importExcelByImg {

	public static void main(String[] args) {
		// 1.一個(gè)單元格一個(gè)圖片
		importExcelOne();
		// 2.一個(gè)單元格多個(gè)圖片
		importExcelTwo();

	}

	/**
	 * 1.一個(gè)單元格一個(gè)圖片
	 */
	public static void importExcelOne() {
		try {
			FileInputStream fileInputStream = new FileInputStream("D://1603169080802.xls");

			HSSFWorkbook hssfWorkbook = new HSSFWorkbook(fileInputStream);// 工作簿

			HSSFSheet sheet = hssfWorkbook.getSheetAt(0);// 工作表

			int lastRowNum = sheet.getLastRowNum();// 獲取最后一行序號,從零開始

			Map<String, PictureData> picMap = new HashMap<>();// 存儲圖片信息和坐標(biāo)

			List<HSSFShape> list = sheet.getDrawingPatriarch().getChildren();

			if (list != null && list.size() > 0) {// 處理獲取圖片信息和坐標(biāo)
				list = list.stream().filter(item -> item instanceof HSSFPicture).collect(Collectors.toList());// 過濾出圖片的數(shù)據(jù)
				for (HSSFShape hssfShape : list) {
					HSSFPicture hSSFPicture = (HSSFPicture) hssfShape;
					HSSFClientAnchor hSSFClientAnchor = (HSSFClientAnchor) hSSFPicture.getAnchor();
					PictureData pictureData = hSSFPicture.getPictureData();
					picMap.put(hSSFClientAnchor.getRow1() + "," + hSSFClientAnchor.getCol1(), pictureData);
				}
			}

			for (int i = 1; i <= lastRowNum; i++) {
				HSSFRow row = sheet.getRow(i);
				String name = row.getCell(0) == null ? "" : row.getCell(0).getStringCellValue();
				String sex = row.getCell(1) == null ? "" : row.getCell(1).getStringCellValue();

				// 獲取圖片數(shù)據(jù)
				PictureData pictureData = picMap.get(i + "," + 2);
				String path = "";
				if (pictureData != null) {
					String suggestFileExtension = pictureData.suggestFileExtension();// 圖片格式
					path = "D://" + i + "-2." + suggestFileExtension;// 存儲路徑
					FileOutputStream out = new FileOutputStream(path);// 流寫入
					out.write(pictureData.getData());
					out.close();
				}

				System.out.println("名稱:" + name + ",    性別:" + sex + ",    圖片存儲路徑:" + path);

			}

		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	/**
	 * 1.一個(gè)單元格多圖片
	 */
	public static void importExcelTwo() {
		try {
			FileInputStream fileInputStream = new FileInputStream("D://1603169081675.xls");

			HSSFWorkbook hssfWorkbook = new HSSFWorkbook(fileInputStream);// 工作簿

			HSSFSheet sheet = hssfWorkbook.getSheetAt(0);// 工作表

			int lastRowNum = sheet.getLastRowNum();// 獲取最后一行序號,從零開始

			Map<String, List<PictureData>> picMap = new HashMap<>();// 存儲圖片信息和坐標(biāo)

			List<HSSFShape> list = sheet.getDrawingPatriarch().getChildren();

			if (list != null && list.size() > 0) {// 處理獲取圖片信息和坐標(biāo)
				list = list.stream().filter(item -> item instanceof HSSFPicture).collect(Collectors.toList());// 過濾出圖片的數(shù)據(jù)
				for (HSSFShape hssfShape : list) {
					HSSFPicture hSSFPicture = (HSSFPicture) hssfShape;
					HSSFClientAnchor hSSFClientAnchor = (HSSFClientAnchor) hSSFPicture.getAnchor();
					PictureData pictureData = hSSFPicture.getPictureData();
					String point = hSSFClientAnchor.getRow1() + "," + hSSFClientAnchor.getCol1();
					// 如果存在這個(gè)坐標(biāo)KEY表示相同單元格中的圖片,直接集合添加該圖片,不存在該坐標(biāo)key直接創(chuàng)建添加
					if (picMap.containsKey(point)) {
						picMap.get(point).add(pictureData);
					} else {
						List<PictureData> arrayList = new ArrayList<PictureData>();
						arrayList.add(pictureData);
						picMap.put(point, arrayList);
					}
				}
			}

			for (int i = 1; i <= lastRowNum; i++) {
				HSSFRow row = sheet.getRow(i);
				String name = row.getCell(0) == null ? "" : row.getCell(0).getStringCellValue();
				String sex = row.getCell(1) == null ? "" : row.getCell(1).getStringCellValue();

				// 獲取圖片數(shù)據(jù)
				List<PictureData> pictureDataList = picMap.get(i + "," + 2);
				String paths = "";
				if (pictureDataList != null)
					for (PictureData pictureData : pictureDataList) {
						String suggestFileExtension = pictureData.suggestFileExtension();// 圖片格式
						String path = "D://" + i + "-2--" + pictureDataList.indexOf(pictureData) + "."
								+ suggestFileExtension;// 存儲路徑
						paths = paths + path;
						FileOutputStream out = new FileOutputStream(path);// 流寫入
						out.write(pictureData.getData());
						out.close();
					}

				System.out.println("名稱:" + name + ",    性別:" + sex + ",    圖片存儲路徑:" + paths);

			}

		} catch (IOException e) {
			e.printStackTrace();
		}
	}

}

到了這里，關(guān)于JAVA POI的excel中包含圖片進(jìn)行讀取保存,單張圖片,多張圖片的文章就介紹完了。如果您還想了解更多內(nèi)容，請?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！