POI Excel - 绘制边框

POI Excel - 绘制边框 首页 / POI入门教程 / POI Excel - 绘制边框

HSSFSimpleShape用于在电子表格中绘制形状。此类提供了一种方法 setShapeType(),该方法有助于绘制各种形状,例如椭圆形,直线形,矩形等。

让无涯教程来看一个例子。

Apache POI绘制形状示例

package poiexample;
import java.io.FileOutputStream;
import java.io.OutputStream;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFSimpleShape;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class ShapeExample {
	public static void main(String[] args) {Workbook wb = new HSSFWorkbook();
	try (OutputStream os = new FileOutputStream("Learnfk.xls")) {
		Sheet sheet = wb.createSheet("Sheet");
		Row row = sheet.createRow(4);//创建行
		Cell cell = row.createCell(1);//创建一个单元格
        HSSFPatriarch patriarch = (HSSFPatriarch) sheet.createDrawingPatriarch();
		HSSFClientAnchor  a = new HSSFClientAnchor( 0, 0, 1023, 255, (short) 1, 0, (short) 1, 0 );
	    HSSFSimpleShape shape = patriarch.createSimpleShape(a);
	    shape.setShapeType(HSSFSimpleShape.OBJECT_TYPE_OVAL);
	    wb.write(os);
	}catch(Exception e) {
		System.out.println(e.getMessage());
	}
	}
}

输出:

Apache POI Draw Shape

祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)

技术教程推荐

Java核心技术面试精讲 -〔杨晓峰〕

如何做好一场技术演讲 -〔极客时间〕

Nginx核心知识150讲 -〔陶辉〕

分布式系统案例课 -〔杨波〕

重学线性代数 -〔朱维刚〕

代码之丑 -〔郑晔〕

郭东白的架构课 -〔郭东白〕

网络排查案例课 -〔杨胜辉〕

零基础学Python(2023版) -〔尹会生〕

好记忆不如烂笔头。留下您的足迹吧 :)