C#在EXCEL中Shapes.AddPolyline,AddShape,Addline用法

如果画多边形,例如四边形,需要提供五个点,依次每个点坐标以及最后再加入原点坐标

	//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);
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值