poi获取Excel表中图片位置

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.io.FileNotFoundException;

import java.io.FilenameFilter;

import java.util.Iterator;

import java.util.List;



import org.apache.poi.hssf.record.EscherAggregate;

import org.apache.poi.ddf.EscherRecord;

import org.apache.poi.ddf.EscherClientAnchorRecord;

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

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

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

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

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;



/**

* 获取Excel表中图片位置

* @author win user

*/

public class cc {





public static void main(String[] args) {

try {

new cc().getImageMatrices("D:/aa.xls");

} catch (Exception ex) {

System.out.println("Caught an: " + ex.getClass().getName());

System.out.println("Message: " + ex.getMessage());

System.out.println("Stacktrace follows:.....");

ex.printStackTrace(System.out);

}

}

public void getImageMatrices(String folderName) throws IOException,

FileNotFoundException, InvalidFormatException {

//File fileFolder = new File(folderName);

//File[] excelWorkbooks = fileFolder.listFiles(new ExcelFilenameFilter());

// for(File excelWorkbook : excelWorkbooks) {

Workbook workbook = WorkbookFactory.create(new FileInputStream(

folderName));

if (workbook instanceof HSSFWorkbook) {

this.processImages((HSSFWorkbook) workbook);

} else {

this.processImages((XSSFWorkbook) workbook);

}

// }

}



private void processImages(HSSFWorkbook workbook) {

EscherAggregate drawingAggregate = null;

HSSFSheet sheet = null;

List<EscherRecord> recordList = null;

Iterator<EscherRecord> recordIter = null;



sheet = workbook.getSheetAt(0);

drawingAggregate = sheet.getDrawingEscherAggregate();

if (drawingAggregate != null) {

recordList = drawingAggregate.getEscherRecords();

recordIter = recordList.iterator();

while (recordIter.hasNext()) {

this.iterateRecords(recordIter.next(), 1);

}

}

//}

}



private void iterateRecords(EscherRecord escherRecord, int level) {

List<EscherRecord> recordList = null;

Iterator<EscherRecord> recordIter = null;

EscherRecord childRecord = null;

recordList = escherRecord.getChildRecords();

recordIter = recordList.iterator();

while (recordIter.hasNext()) {

childRecord = recordIter.next();

if (childRecord instanceof EscherClientAnchorRecord) {



this.printAnchorDetails((EscherClientAnchorRecord) childRecord);

}

if (childRecord.getChildRecords().size() > 0) {

this.iterateRecords(childRecord, ++level);

}

}

}



private void printAnchorDetails(EscherClientAnchorRecord anchorRecord) {

System.out.print("图片左上角  "+anchorRecord.getRow1() +"行  " + anchorRecord.getCol1()+ "列"  + " x坐标："

+ anchorRecord.getDx1() + "  y坐标：" + anchorRecord.getDy1());

System.out.println("           图片的右下角 "+ anchorRecord.getRow2()+ " 行  "+ anchorRecord.getCol2() +" 列 "+ " x坐标："

+ anchorRecord.getDx2()+ "  y坐标：" + anchorRecord.getDy2());

}



private void processImages(XSSFWorkbook workbook) {

System.out.println("目前还不支持OOXML  workbooks.Investigating.");

}





public class ExcelFilenameFilter implements FilenameFilter {



public boolean accept(File file, String fileName) {

boolean includeFile = false;

if (fileName.endsWith(".xls") || fileName.endsWith(".xlsx")) {

includeFile = true;

}

return (includeFile);

}

}

}