org.dromara.hutool.poi.excel.shape

Class ExcelPicUtil

java.lang.Object

org.dromara.hutool.poi.excel.shape.ExcelPicUtil

public class ExcelPicUtil
extends Object

Excel图片工具类

Since:

4.0.7

Author:

looly

Constructor Summary

Constructors

Constructor and Description
ExcelPicUtil()

Method Summary

Modifier and Type	Method and Description
static List<? extends org.apache.poi.ss.usermodel.PictureData>	getAllPictures(org.apache.poi.ss.usermodel.Workbook workbook) 获取所有图片列表
static ExcelPicType	getPicType(File picFile) 获取图片类型
static List<org.apache.poi.ss.usermodel.Picture>	getShapePics(org.apache.poi.ss.usermodel.Sheet sheet) 获取工作簿指定sheet中绘制的图片列表 结果中Picture.getClientAnchor()标识位置信息，Picture.getPictureData()标识图片数据
static List<org.apache.poi.ss.usermodel.Picture>	getShapePics(org.apache.poi.ss.usermodel.Workbook workbook, int sheetIndex) 获取工作簿指定sheet中绘制的图片列表
static void	writePicTo(org.apache.poi.ss.usermodel.PictureData pic, File file) 写入图片到文件
static void	writePicTo(org.apache.poi.ss.usermodel.Picture pic, File file) 写入图片到文件

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExcelPicUtil

public ExcelPicUtil()

Method Detail

getPicType

public static ExcelPicType getPicType(File picFile)

获取图片类型

Parameters:

picFile - 图片文件

Returns:

图片类型，默认PNG

Since:

6.0.0

writePicTo

public static void writePicTo(org.apache.poi.ss.usermodel.Picture pic,
                              File file)

写入图片到文件

Parameters:

pic - 图片数据

file - 文件

writePicTo

public static void writePicTo(org.apache.poi.ss.usermodel.PictureData pic,
                              File file)

写入图片到文件

Parameters:

pic - 图片数据

file - 文件

getAllPictures

public static List<? extends org.apache.poi.ss.usermodel.PictureData> getAllPictures(org.apache.poi.ss.usermodel.Workbook workbook)

获取所有图片列表

Parameters:

workbook - 工作簿Workbook

Returns:

图片列表

getShapePics

public static List<org.apache.poi.ss.usermodel.Picture> getShapePics(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                     int sheetIndex)

获取工作簿指定sheet中绘制的图片列表

Parameters:

workbook - 工作簿Workbook

sheetIndex - sheet的索引

Returns:

图片映射，键格式：行_列，值：PictureData

getShapePics

public static List<org.apache.poi.ss.usermodel.Picture> getShapePics(org.apache.poi.ss.usermodel.Sheet sheet)

获取工作簿指定sheet中绘制的图片列表
结果中Picture.getClientAnchor()标识位置信息，Picture.getPictureData()标识图片数据

Parameters:

sheet - 工作表Sheet

Returns:

图片列表