POI 其他形状

1.形状类型

有些支持，有些不支持

public interface HSSFShapeTypes {
    public static final int NotPrimitive = 0;
    public static final int Rectangle = 1;
    public static final int RoundRectangle = 2;
    public static final int Ellipse = 3;
    public static final int Diamond = 4;
    public static final int IsocelesTriangle = 5;
    public static final int RightTriangle = 6;
    public static final int Parallelogram = 7;
    public static final int Trapezoid = 8;
    public static final int Hexagon = 9;
    public static final int Octagon = 10;
    public static final int Plus = 11;
    public static final int Star = 12;
    public static final int Arrow = 13;
    public static final int ThickArrow = 14;
    public static final int HomePlate = 15;
    public static final int Cube = 16;
    public static final int Balloon = 17;
    public static final int Seal = 18;
    public static final int Arc = 19;
    public static final int Line = 20;
    public static final int Plaque = 21;
    public static final int Can = 22;
    public static final int Donut = 23;
    public static final int TextSimple = 24;
    public static final int TextOctagon = 25;
    public static final int TextHexagon = 26;
    public static final int TextCurve = 27;
    public static final int TextWave = 28;
    public static final int TextRing = 29;
    public static final int TextOnCurve = 30;
    public static final int TextOnRing = 31;
    public static final int StraightConnector1 = 32;
    public static final int BentConnector2 = 33;
    public static final int BentConnector3 = 34;
    public static final int BentConnector4 = 35;
    public static final int BentConnector5 = 36;
    public static final int CurvedConnector2 = 37;
    public static final int CurvedConnector3 = 38;
    public static final int CurvedConnector4 = 39;
    public static final int CurvedConnector5 = 40;
    public static final int Callout1 = 41;
    public static final int Callout2 = 42;
    public static final int Callout3 = 43;
    public static final int AccentCallout1 = 44;
    public static final int AccentCallout2 = 45;
    public static final int AccentCallout3 = 46;
    public static final int BorderCallout1 = 47;
    public static final int BorderCallout2 = 48;
    public static final int BorderCallout3 = 49;
    public static final int AccentBorderCallout1 = 50;
    public static final int AccentBorderCallout2 = 51;
    public static final int AccentBorderCallout3 = 52;
    public static final int Ribbon = 53;
    public static final int Ribbon2 = 54;
    public static final int Chevron = 55;
    public static final int Pentagon = 56;
    public static final int NoSmoking = 57;
    public static final int Star8 = 58;
    public static final int Star16 = 59;
    public static final int Star32 = 60;
    public static final int WedgeRectCallout = 61;
    public static final int WedgeRRectCallout = 62;
    public static final int WedgeEllipseCallout = 63;
    public static final int Wave = 64;
    public static final int FoldedCorner = 65;
    public static final int LeftArrow = 66;
    public static final int DownArrow = 67;
    public static final int UpArrow = 68;
    public static final int LeftRightArrow = 69;
    public static final int UpDownArrow = 70;
    public static final int IrregularSeal1 = 71;
    public static final int IrregularSeal2 = 72;
    public static final int LightningBolt = 73;
    public static final int Heart = 74;
    public static final int PictureFrame = 75;
    public static final int QuadArrow = 76;
    public static final int LeftArrowCallout = 77;
    public static final int RightArrowCallout = 78;
    public static final int UpArrowCallout = 79;
    public static final int DownArrowCallout = 80;
    public static final int LeftRightArrowCallout = 81;
    public static final int UpDownArrowCallout = 82;
    public static final int QuadArrowCallout = 83;
    public static final int Bevel = 84;
    public static final int LeftBracket = 85;
    public static final int RightBracket = 86;
    public static final int LeftBrace = 87;
    public static final int RightBrace = 88;
    public static final int LeftUpArrow = 89;
    public static final int BentUpArrow = 90;
    public static final int BentArrow = 91;
    public static final int Star24 = 92;
    public static final int StripedRightArrow = 93;
    public static final int NotchedRightArrow = 94;
    public static final int BlockArc = 95;
    public static final int SmileyFace = 96;
    public static final int VerticalScroll = 97;
    public static final int HorizontalScroll = 98;
    public static final int CircularArrow = 99;
    public static final int NotchedCircularArrow = 100;
    public static final int UturnArrow = 101;
    public static final int CurvedRightArrow = 102;
    public static final int CurvedLeftArrow = 103;
    public static final int CurvedUpArrow = 104;
    public static final int CurvedDownArrow = 105;
    public static final int CloudCallout = 106;
    public static final int EllipseRibbon = 107;
    public static final int EllipseRibbon2 = 108;
    public static final int FlowChartProcess = 109;
    public static final int FlowChartDecision = 110;
    public static final int FlowChartInputOutput = 111;
    public static final int FlowChartPredefinedProcess = 112;
    public static final int FlowChartInternalStorage = 113;
    public static final int FlowChartDocument = 114;
    public static final int FlowChartMultidocument = 115;
    public static final int FlowChartTerminator = 116;
    public static final int FlowChartPreparation = 117;
    public static final int FlowChartManualInput = 118;
    public static final int FlowChartManualOperation = 119;
    public static final int FlowChartConnector = 120;
    public static final int FlowChartPunchedCard = 121;
    public static final int FlowChartPunchedTape = 122;
    public static final int FlowChartSummingJunction = 123;
    public static final int FlowChartOr = 124;
    public static final int FlowChartCollate = 125;
    public static final int FlowChartSort = 126;
    public static final int FlowChartExtract = 127;
    public static final int FlowChartMerge = 128;
    public static final int FlowChartOfflineStorage = 129;
    public static final int FlowChartOnlineStorage = 130;
    public static final int FlowChartMagneticTape = 131;
    public static final int FlowChartMagneticDisk = 132;
    public static final int FlowChartMagneticDrum = 133;
    public static final int FlowChartDisplay = 134;
    public static final int FlowChartDelay = 135;
    public static final int TextPlainText = 136;
    public static final int TextStop = 137;
    public static final int TextTriangle = 138;
    public static final int TextTriangleInverted = 139;
    public static final int TextChevron = 140;
    public static final int TextChevronInverted = 141;
    public static final int TextRingInside = 142;
    public static final int TextRingOutside = 143;
    public static final int TextArchUpCurve = 144;
    public static final int TextArchDownCurve = 145;
    public static final int TextCircleCurve = 146;
    public static final int TextButtonCurve = 147;
    public static final int TextArchUpPour = 148;
    public static final int TextArchDownPour = 149;
    public static final int TextCirclePour = 150;
    public static final int TextButtonPour = 151;
    public static final int TextCurveUp = 152;
    public static final int TextCurveDown = 153;
    public static final int TextCascadeUp = 154;
    public static final int TextCascadeDown = 155;
    public static final int TextWave1 = 156;
    public static final int TextWave2 = 157;
    public static final int TextWave3 = 158;
    public static final int TextWave4 = 159;
    public static final int TextInflate = 160;
    public static final int TextDeflate = 161;
    public static final int TextInflateBottom = 162;
    public static final int TextDeflateBottom = 163;
    public static final int TextInflateTop = 164;
    public static final int TextDeflateTop = 165;
    public static final int TextDeflateInflate = 166;
    public static final int TextDeflateInflateDeflate = 167;
    public static final int TextFadeRight = 168;
    public static final int TextFadeLeft = 169;
    public static final int TextFadeUp = 170;
    public static final int TextFadeDown = 171;
    public static final int TextSlantUp = 172;
    public static final int TextSlantDown = 173;
    public static final int TextCanUp = 174;
    public static final int TextCanDown = 175;
    public static final int FlowChartAlternateProcess = 176;
    public static final int FlowChartOffpageConnector = 177;
    public static final int Callout90 = 178;
    public static final int AccentCallout90 = 179;
    public static final int BorderCallout90 = 180;
    public static final int AccentBorderCallout90 = 181;
    public static final int LeftRightUpArrow = 182;
    public static final int Sun = 183;
    public static final int Moon = 184;
    public static final int BracketPair = 185;
    public static final int BracePair = 186;
    public static final int Star4 = 187;
    public static final int DoubleWave = 188;
    public static final int ActionButtonBlank = 189;
    public static final int ActionButtonHome = 190;
    public static final int ActionButtonHelp = 191;
    public static final int ActionButtonInformation = 192;
    public static final int ActionButtonForwardNext = 193;
    public static final int ActionButtonBackPrevious = 194;
    public static final int ActionButtonEnd = 195;
    public static final int ActionButtonBeginning = 196;
    public static final int ActionButtonReturn = 197;
    public static final int ActionButtonDocument = 198;
    public static final int ActionButtonSound = 199;
    public static final int ActionButtonMovie = 200;
    public static final int HostControl = 201;
    public static final int TextBox = 202;
}

2.测试

package hssf.shape.simpleshape;

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFShapeTypes;
import org.apache.poi.hssf.usermodel.HSSFSimpleShape;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

/**
 * 直线在sheet中位置
 * new HSSFClientAnchor(x1, y1, x2, y2, (short)startcol, startrow, (short)endcol, endrow)
 * @param x1     直线一端在开始单元格(startcol, startrow)内的横坐标，范围[0, 2013],将列宽均分为1023份
 * @param y1     直线一端在开始单元格(startcol, startrow)内的纵坐标，范围[0, 255],将行高均分为255份
 * @param x2    直线一端在结束单元格(endcol, endrow)内的横坐标，范围[0, 2013],将列宽均分为1023份
 * @param y2    直线一端在结束单元格(endcol, endrow)内的纵坐标，范围[0, 255],将列宽均分为255份
 * @param startcol 直线一端所处开始列号，base 0
 * @param startrow 直线一端所处开始行号，base 0
 * @param endcol   直线另一端所处结束列号，base 0
 * @param endrow   直线另一端所处结束行号，base 0
 * */ 
public class TestOtherShape {

	public static void main(String[] args) throws Exception {
		// 创建一个工作博
				Workbook workbook = new HSSFWorkbook();
				// 创建一个sheet
				Sheet sheet = workbook.createSheet();
				// 画图的*管理器对象HSSFPatriarch, 一个sheet只能获取一个
				HSSFPatriarch hssfPatriarch = (HSSFPatriarch) sheet.createDrawingPatriarch();
						
				HSSFClientAnchor anchor1 = new HSSFClientAnchor(0, 0, 0, 0, (short)1, 2, (short)3, 10);
				// 没有图形
				HSSFSimpleShape notPrimitive = hssfPatriarch.createSimpleShape(anchor1);
				notPrimitive.setShapeType(HSSFShapeTypes.NotPrimitive);
				
				HSSFClientAnchor anchor2 = new HSSFClientAnchor(0, 0, 0, 0, (short)4, 2, (short)6, 10);
				// 创建一个没有填充色的矩形
				HSSFSimpleShape rect = hssfPatriarch.createSimpleShape(anchor2);
				rect.setShapeType(HSSFShapeTypes.Rectangle);
				rect.setNoFill(true);
				
				HSSFClientAnchor anchor3 = new HSSFClientAnchor(0, 0, 0, 0, (short)7, 2, (short)9, 10);
				// 创建一个圆角矩形
				HSSFSimpleShape roundRectangle = hssfPatriarch.createSimpleShape(anchor3);
				roundRectangle.setShapeType(HSSFShapeTypes.RoundRectangle);
				
				HSSFClientAnchor anchor4 = new HSSFClientAnchor(0, 0, 0, 0, (short)10, 2, (short)12, 10);
				// 创建一个椭圆
				HSSFSimpleShape ellipse = hssfPatriarch.createSimpleShape(anchor4);
				ellipse.setShapeType(HSSFShapeTypes.Ellipse);
				
				HSSFClientAnchor anchor5 = new HSSFClientAnchor(0, 0, 0, 0, (short)13, 2, (short)15, 10);
				// 创建一个菱形
				HSSFSimpleShape diamond = hssfPatriarch.createSimpleShape(anchor5);
				diamond.setShapeType(HSSFShapeTypes.Diamond);
				
				HSSFClientAnchor anchor6 = new HSSFClientAnchor(0, 0, 0, 0, (short)16, 2, (short)18, 10);
				// 创建一个等腰三角形
				HSSFSimpleShape isocelesTriangle = hssfPatriarch.createSimpleShape(anchor6);
				isocelesTriangle.setShapeType(HSSFShapeTypes.IsocelesTriangle);
				
				HSSFClientAnchor anchor21 = new HSSFClientAnchor(0, 0, 0, 0, (short)1, 16, (short)3, 24);
				// 创建一个直角三角形
				HSSFSimpleShape rightTriangle = hssfPatriarch.createSimpleShape(anchor21);
				rightTriangle.setShapeType(HSSFShapeTypes.RightTriangle);
				
				HSSFClientAnchor anchor22 = new HSSFClientAnchor(0, 0, 0, 0, (short)4, 16, (short)6, 24);
				// 创建一个平行四边形
				HSSFSimpleShape parallelogram = hssfPatriarch.createSimpleShape(anchor22);
				parallelogram.setShapeType(HSSFShapeTypes.Parallelogram);
				
//				HSSFClientAnchor anchor23 = new HSSFClientAnchor(0, 0, 0, 0, (short)7, 16, (short)9, 24);
//				// 创建一个梯形 - 不支持
//				HSSFSimpleShape trapezoid = hssfPatriarch.createSimpleShape(anchor23);
//				trapezoid.setShapeType(HSSFShapeTypes.Trapezoid);
				
				HSSFClientAnchor anchor24 = new HSSFClientAnchor(0, 0, 0, 0, (short)10, 16, (short)12, 24);
				// 创建一个六边形
				HSSFSimpleShape hexagon = hssfPatriarch.createSimpleShape(anchor24);
				hexagon.setShapeType(HSSFShapeTypes.Hexagon);
				
				HSSFClientAnchor anchor25 = new HSSFClientAnchor(0, 0, 0, 0, (short)13, 16, (short)15, 24);
				// 创建一个八边形
				HSSFSimpleShape octagon = hssfPatriarch.createSimpleShape(anchor25);
				octagon.setShapeType(HSSFShapeTypes.Octagon);
				
				HSSFClientAnchor anchor26 = new HSSFClientAnchor(0, 0, 0, 0, (short)16, 16, (short)18, 24);
				// 创建一个十字形
				HSSFSimpleShape plus = hssfPatriarch.createSimpleShape(anchor26);
				plus.setShapeType(HSSFShapeTypes.Plus);
				
				FileOutputStream file = new FileOutputStream("C://Users//Administrator//Desktop//test.xls");
				workbook.write(file);
				file.close();
	}

}

结果：