读书人

ruby 如何调用 EXCEL 自动生成图表?

发布时间: 2012-03-02 14:40:29 作者: rapoo

ruby 怎么调用 EXCEL 自动生成图表???
我需要把程序内的数据 用图表来显示出来,用EXCEL或其他什么的
求教求教@!!!!!

[解决办法]
require 'win32ole '

# -4100 is the value for the Excel constant xl3DColumn.
ChartTypeVal = -4100;

# Creates OLE object to Excel
excel = WIN32OLE.new( "excel.application ")

# Create and rotate the chart

excel[ 'Visible '] = TRUE
workbook = excel.Workbooks.Add()
excel.Range( "a1 ")[ 'Value '] = 3
excel.Range( "a2 ")[ 'Value '] = 2
excel.Range( "a3 ")[ 'Value '] = 1
excel.Range( "a1:a3 ").Select()
excelchart = workbook.Charts.Add()
excelchart[ 'Type '] = ChartTypeVal

30.step(180, 10) do |rot|
sleep(1)
excelchart[ 'Rotation '] = rot
end

excelchart2 = workbook.Charts.Add();
excelchart3 = workbook.Charts.Add();

charts = workbook.Charts
charts.each { |i| puts i }

excel.ActiveWorkbook.Close(0);
excel.Quit();


读书人网 >Ruby Rails

热点推荐