workbook加载文件路径_java-从.xls文件读取图像以及其位置的引用

只要形状是图片,就可以进行以下操作：

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

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

import org.apache.poi.ss.util.*;

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

import java.io.FileOutputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.FileInputStream;

import java.io.InputStream;

class GetShapePosition {

public static void main(String[] args) {

try {

InputStream inp = new FileInputStream("workbook.xls");

Workbook wb = WorkbookFactory.create(inp);

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

HSSFPatriarch dravingPatriarch = sheet.getDrawingPatriarch();

java.util.List shapes = dravingPatriarch.getChildren();

for (HSSFShape shape : shapes) {

if (shape instanceof HSSFPicture) {

HSSFPicture hssfPicture = (HSSFPicture)shape;

int picIndex = hssfPicture.getPictureIndex();

String filename = hssfPicture.getFileName();

int row = hssfPicture.getClientAnchor().getRow1();

int col = hssfPicture.getClientAnchor().getCol1();

System.out.println("Picture " + picIndex + " with Filename: " + filename + " is located row: " + row + ", col: " + col);

}

}

} catch (InvalidFormatException ifex) {

} catch (FileNotFoundException fnfex) {

} catch (IOException ioex) {

}

}

}