vken7az2p 发表于 2008-8-10 21:40:00

[求助]如何在EXCEL建立图样?

<p>[求助]如何在EXCEL建立图样?<br/>参考 vlxls-functions<br/><a href="http://www.atablex.com/htmls/vlxls-functions.htm">http://www.atablex.com/htmls/vlxls-functions.htm</a></p><p>开启 EXCEL<br/>(setq xlapp (vlax-get-or-create-object "excel.application"))<br/>(setq sheet (vlax-get-property xlapp&nbsp; "ActiveSheet"))<br/>(setq shapes (vlax-get-property sheet "shapes"))</p><p>建立LINE,正常<br/>ActiveSheet.Shapes.AddLine(0.0, 0.0, 100.75, 100.75)<br/>(vlax-invoke-method shapes 'AddLine 0.0 0.0 100.75 100.75 )<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br/>建立Rectangle,错误<br/>ActiveSheet.Shapes.AddShape(msoShapeRectangle, 121.5, 147.75, 99.5, 114.75)<br/>(vlax-invoke-method shapes 'AddShape ShapeRectangle 121.5 147.75 99.5 114.75 )</p><p>请问该怎样带入 msoShapeRectangle 这常数值呢?<br/>烦请各位高手可以解答一下<br/>谢谢~</p>
页: [1]
查看完整版本: [求助]如何在EXCEL建立图样?