java poi 读取excel 图片_poi 获取excel中图片

转载自：http://fansfirst2008.iteye.com/blog/1138189

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.InputStream;

import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;

import org.apache.poi.hssf.usermodel.HSSFPicture;

import org.apache.poi.hssf.usermodel.HSSFPictureData;

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.openxml4j.exceptions.InvalidFormatException;

import org.apache.poi.ss.usermodel.PictureData;

import org.apache.poi.ss.usermodel.WorkbookFactory;

public class ReadPicturesFromExcel {

public static void main(String[] args) throws InvalidFormatException,

Exception {

InputStream inp = new FileInputStream(

"D:\\Users\\Fancy1_Fan\\桌面\\work\\test.xls");

HSSFWorkbook workbook = (HSSFWorkbook) WorkbookFactory.create(inp);

List pictures = workbook.getAllPictures();

HSSFSheet sheet = (HSSFSheet) workbook.getSheetAt(0);

int i = 0;

for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {

HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();

if (shape instanceof HSSFPicture) {

HSSFPicture pic = (HSSFPicture) shape;

int row = anchor.getRow1();

System.out.println(i + "--->" + anchor.getRow1() + ":"

+ anchor.getCol1());

int pictureIndex = pic.getPictureIndex()-1;

HSSFPictureData picData = pictures.get(pictureIndex);

System.out.println(i + "--->" + pictureIndex);

savePic(row, picData);

}

i++;

}

}

private static void savePic(int i, PictureData pic) throws Exception {

String ext = pic.suggestFileExtension();

byte[] data = pic.getData();

if (ext.equals("jpeg")) {

FileOutputStream out = new FileOutputStream(

"D:\\Users\\Fancy1_Fan\\桌面\\work\\pict" + i + ".jpg");

out.write(data);

out.close();

}

if (ext.equals("png")) {

FileOutputStream out = new FileOutputStream(

"D:\\Users\\Fancy1_Fan\\桌面\\work\\pict" + i + ".png");

out.write(data);

out.close();

}

}

}

//获取sheet里所有图片信息 Map

private Map getPicMap(HSSFWorkbook workbook) {

Map picMap = new HashMap();

List pictures = workbook.getAllPictures();

HSSFSheet sheet = (HSSFSheet) workbook.getSheetAt(0);

for (HSSFShape shape : sheet.getDrawingPatriarch().getChildren()) {

HSSFClientAnchor anchor = (HSSFClientAnchor) shape.getAnchor();

if (shape instanceof HSSFPicture) {

HSSFPicture pic = (HSSFPicture) shape;

HSSFPictureData picData = pictures.get(pic.getPictureIndex()-1);

picMap.put(anchor.getRow1(), picData);

} else {

picMap.put(anchor.getRow1(), null); //非图片数据则插入null

}

}

return picMap;

}