Excel导入带图片

最新推荐文章于 2024-08-23 21:23:28 发布

qq_17550513

最新推荐文章于 2024-08-23 21:23:28 发布

阅读量172

点赞数 1

文章标签： excel

本文链接：https://blog.csdn.net/qq_17550513/article/details/140382891

版权

Workbook workbook = WorkbookFactory.create(file.getInputStream());
        Sheet sheetAt = workbook.getSheetAt(0);
        Map<String, PictureData> picturesHSS = getPicturesHSS((XSSFSheet) sheetAt);

/**
* 获取图片和位置 (xls)
*
* @param sheet
* @return
* @throws IOException
*/
public static Map<String, PictureData> getPicturesHSS(XSSFSheet sheet) {
Map<String, PictureData> map = new HashMap<String, PictureData>();
List list = sheet.getDrawingPatriarch().getShapes();
for (XSSFShape shape : list) {
if (shape instanceof XSSFPicture) {
XSSFPicture picture = (XSSFPicture) shape;
XSSFClientAnchor cAnchor = (XSSFClientAnchor) picture.getAnchor();
PictureData pdata = picture.getPictureData();
String key = cAnchor.getRow1() + “-” + cAnchor.getCol1(); // 行号-列号
map.put(key, pdata);
}
}
return map;
}