无涯教程-POI Excel - 绘制边框

94 阅读1分钟

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

参考链接

www.learnfk.com/apache-poi-…