Apache POI 绘制边框

2025 年 3 月 17 日 | 阅读 1 分钟

Apache POI 允许我们在工作簿表格中应用一组边框。PropertyTemplate 对象通过定义的方法和常量模拟此功能，允许绘制单元格的顶部、底部、左侧、右侧、水平、垂直、内部、外部边框。

让我们看一个在单元格周围绘制边框的例子。

Apache POI 绘制边框示例

package poiexample;
import java.io.FileOutputStream;
import java.io.OutputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.BorderExtent;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.PropertyTemplate;
public class DrawingBorderExample {
	public static void main(String[] args) {		
		try (OutputStream os = new FileOutputStream("Javatpoint.xls")) {	
			 PropertyTemplate pt = new PropertyTemplate();
			 pt.drawBorders(new CellRangeAddress(1, 2, 1, 2),
			          BorderStyle.MEDIUM, BorderExtent.ALL);
			 pt.drawBorders(new CellRangeAddress(5, 6, 1, 2),
			          BorderStyle.MEDIUM, BorderExtent.OUTSIDE);
			 pt.drawBorders(new CellRangeAddress(5, 6, 1, 2), BorderStyle.THIN,
			          BorderExtent.INSIDE);
			 pt.drawBorders(new CellRangeAddress(9, 10, 1, 3),
			          BorderStyle.MEDIUM, IndexedColors.GREEN.getIndex(),
			          BorderExtent.OUTSIDE);
			 pt.drawBorders(new CellRangeAddress(9, 10, 1, 3),
			          BorderStyle.MEDIUM, IndexedColors.BLUE.getIndex(),
			          BorderExtent.INSIDE_VERTICAL);
			 pt.drawBorders(new CellRangeAddress(9, 10, 1, 3),
			          BorderStyle.MEDIUM, IndexedColors.RED.getIndex(),
			          BorderExtent.INSIDE_HORIZONTAL);
			 pt.drawBorders(new CellRangeAddress(10, 10, 2, 2),
			          BorderStyle.NONE, 
			          BorderExtent.ALL);
			 Workbook wb = new HSSFWorkbook();
			 Sheet sheet = wb.createSheet("Sheet");
			 pt.applyBorders(sheet);
			 wb.write(os);
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
	}
}

输出

下一个主题Apache POI 多种样式

Apache POI 绘制边框

Apache POI 绘制边框示例

联系信息

关注我们

教程

面试题

在线编译器

Python

Java

.Net Framework

AI, ML and Data Science

Cloud Technology

B.Tech and MCA

Web Technology

PHP

Software Testing

Technical Interview

Java Interview

Python

Web Interview

Database Interview

B.Tech / MCA

Important Interview

Software Testing Interview

Company Interviews

Online Compilers

Multiple Choice Questions

Apache POI 教程

Excel 文档

Word 文档

Powerpoint 文档

Apache POI 绘制边框

Apache POI 绘制边框示例

相关帖子

POI 页码

POI 隐藏行

POI 样式形状

POI 单元格换行

POI 读取单元格内容

POI Excel 标题

Excel 文档处理

POI 创建工作簿

POI 大纲

POI 绘制形状

订阅 Tpoint Tech

联系信息

关注我们

教程

面试题

在线编译器