开发工具:
文件大小: 413kb
下载次数: 0
上传时间: 2014-01-02
详细说明： 一个简单示例 初始化当前Java线程STA ComThread InitSTA ; ActiveXComponent xl new ActiveXComponent "Excel Application" ; try{ 打开现有的Excel xl setProperty "Visible" new Variant false ; Dispatch workbooks xl getProperty "Workbooks" toDispatch ; Dispatch workbook Dispatch invoke workbooks "Open" Dispatch Method new Object[]{excelPath new Variant false 是否只读 new Varia nt false } 是否显示打开 new int[1] toDispatch ; 得到所有sheet Dispatch sheets Dispatch get workbook "sheets" toDispatch ; System out println "sheet数量："+Dispatch get sheets "count" toString ; 根据索引得到sheet Dispatch sheet Dispatch invoke sheets "Item" Dispatch Get new Object[]{i} new int[1] toDispatch ; 绘图 Dispatch chartobjects Dispatch call sheet "ChartObjects" toDispatch ; Dispatch achart Dispatch invoke chartobjects "Add" Dispatch Method new Object[] { new Double 12 yHeight 横坐标 纵坐标 new Double 943 new Double 293 宽度 高度 } new int[1] toDispatch ; Dispatch chart Dispatch get achart "chart" toDispatch ; Dispatch range Dispatch invoke sheet "Range" Dispatch Get new Object[] {rangeX rangeY} 列名位置 数据位置 new int[2] toDispatch ; Dispatch series Dispatch call chart "seriescollection" toDispatch ; Dispatch call series "add" range new Variant true ; 生成图形 Dispatch put chart "PlotBy" "2" ; 纵向读取数据绘制chart 设置线条气泡颜色 黄色 Dispatch seriesChartFillFormat Dispatch get series "Fill" toDispatch ; Dispatch seriesForeColor Dispatch get seriesChartFillFormat "ForeColor" toDispatch ; Dispatch put seriesForeColor "SchemeColor" "18" ; 设置绘图区背景色为透明 Dispatch plotArea Dispatch get chart "PlotArea" toDispatch ; Dispatch plotAreaInterior Dispatch get plotArea "Interior" toDispatch ; Dispatch put plotAreaInterior "ColorIndex" " 4142" ; 设置标题 Dispatch chartTitle Dispatch get chart "ChartTitle" toDispatch ; Dispatch put chartTitle "Text" params[paramIndex][0] ; 设置图例位置 Dispatch legend Dispatch get chart "Legend" toDispatch ; Dispatch put legend "Position" " 4160" ; 设置图表背景色 Dispatch chartArea Dispatch get chart "ChartArea" toDispatch ; Dispatch chartFillFormat Dispatch get chartArea "Fill" toDispatch ; Dispatch fc Dispatch get chartFillFormat "ForeColor" toDispatch ; Dispatch put fc "SchemeColor" "35" ; 保存 Dispatch call workbook "Save" ; Dispatch call workbook "Close" new Variant false ; xl invoke "Quit" new Variant[] {} ; }catch Exception ex { ex printStackTrace ; } finally { 释放 com 资源 xl invoke "Quit" new Variant[] {} ; ComThread Release ; System out println " 处理完成 " ; }">一个简单示例 初始化当前Java线程STA ComThread InitSTA ; ActiveXComponent xl new ActiveXComponent "Excel Application" ; try{ 打开现有的Excel xl setProperty "Visible" new Variant false ; Dispatch workbooks xl getProperty "Workbooks" toDis [更多] ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
