如果画多边形,例如四边形,需要提供五个点,依次每个点坐标以及最后再加入原点坐标
//n表示点的数量
float[,] ps = new float[5, 2];
ps[0, 0] = 300;
ps[0, 1] = 300;
ps[1, 0] = 600;
ps[1, 1] = 300;
ps[2, 0] = 600;
ps[2, 1] = 600;
ps[3, 0] = 300;
ps[3, 1] = 600;
ps[4, 0] = 300;
ps[4, 1] = 300;
object points = ps;
//根据点位多边形画框
ExcelOffice.Shape ShapeVar = ws.Shapes.AddPolyline(points);
AddPolyline如何设置多变形内部样式,例:
ShapeVar.Select();
ShapeVar.Name = "多变形";
//设置无填充色
ShapeVar.Fill.Visible = MsoTriState.msoFalse;
//设置红蓝框线条
ExcelOffice.LineFormat line = ShapeVar.Line;
line.ForeColor.SchemeColor = 10;
ShapeVar.Line.ForeColor.SchemeColor = 10;
//设置线宽
ShapeVar.Line.Weight = (float)2.25;
ShapeVar.Line.DashStyle = Microsoft.Office.Core.MsoLineDashStyle.msoLineDashDot;
//固定框
ShapeVar.Placement = ExcelOffice.XlPlacement.xlFreeFloating;
//设置点击打印时可不打印线条
excel.Selection.PrintObject = 0;
Addline画线
ExcelOffice.Shape ShapeVars = ws.Shapes.AddLine(int.Parse(lineres[0]), int.Parse(lineres[1]), int.Parse(lineres[2]), int.Parse(lineres[3]));
ShapeVars.Select();
ShapeVars.Name = "redline"+jx.ToString();
ExcelOffice.LineFormat lines = ShapeVars.Line;
lines.ForeColor.SchemeColor = 10;
ShapeVars.Line.ForeColor.SchemeColor = 10;
ShapeVars.Line.Weight = (float)2.25;
ShapeVars.Line.DashStyle = Microsoft.Office.Core.MsoLineDashStyle.msoLineDashDot;
ShapeVars.Placement = ExcelOffice.XlPlacement.xlFreeFloating;//固定框
excel.Selection.PrintObject = 0; //不打印线条
画框
ExcelOffice.Shape ShapeVar = ws.Shapes.AddShape(MsoAutoShapeType.msoShapeRectangle, RangeVar.Left, RangeVar.Top, RangeVar.Width, RangeVar.Height);