org.dromara.hutool.poi.excel.writer

Class ExcelDrawingUtil

java.lang.Object

org.dromara.hutool.poi.excel.writer.ExcelDrawingUtil

public class ExcelDrawingUtil
extends Object

Excel绘制工具类
用于辅助写出指定的图形

Since:

6.0.0

Author:

Looly

Constructor Summary

Constructors

Constructor and Description
ExcelDrawingUtil()

Method Summary

Modifier and Type	Method and Description
static void	drawingCellComment(org.apache.poi.ss.usermodel.Cell cell, SimpleClientAnchor clientAnchor, String content) 添加批注
static void	drawingPic(org.apache.poi.ss.usermodel.Sheet sheet, byte[] pictureData, ExcelPicType imgType, SimpleClientAnchor clientAnchor) 写出图片，本方法只是将数据写入Workbook中的Sheet，并不写出到文件 添加图片到当前sheet中
static void	drawingSimpleShape(org.apache.poi.ss.usermodel.Sheet sheet, SimpleClientAnchor clientAnchor, ShapeConfig shapeConfig) 绘制简单形状

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelDrawingUtil

public ExcelDrawingUtil()

Method Detail

drawingPic

public static void drawingPic(org.apache.poi.ss.usermodel.Sheet sheet,
                              byte[] pictureData,
                              ExcelPicType imgType,
                              SimpleClientAnchor clientAnchor)

写出图片，本方法只是将数据写入Workbook中的Sheet，并不写出到文件
添加图片到当前sheet中

Parameters:

sheet - Sheet

pictureData - 数据bytes

imgType - 图片类型，对应poi中Workbook类中的图片类型2-7变量

clientAnchor - 图片的位置和大小信息

Since:

6.0.0

drawingSimpleShape

public static void drawingSimpleShape(org.apache.poi.ss.usermodel.Sheet sheet,
                                      SimpleClientAnchor clientAnchor,
                                      ShapeConfig shapeConfig)

绘制简单形状

Parameters:

sheet - Sheet

clientAnchor - 绘制区域信息

shapeConfig - 形状配置，包括形状类型、线条样式、线条宽度、线条颜色、填充颜色等

Since:

6.0.0

drawingCellComment

public static void drawingCellComment(org.apache.poi.ss.usermodel.Cell cell,
                                      SimpleClientAnchor clientAnchor,
                                      String content)

添加批注

Parameters:

cell - Cell

clientAnchor - 绘制区域信息

content - 内容