Create a chart and rotate it : Excel « Windows Platform « Ruby






  1. Ruby
  2. Windows Platform
  3. Excel

Create a chart and rotate it


require 'win32ole' 


ChartTypeVal = 4100; 
excel = WIN32OLE.new("excel.application") 
excel['Visible'] = TRUE 
excel.Workbooks.Add() 
excel.Range("a1")['Value'] = 3 
excel.Range("a2")['Value'] = 2 
excel.Range("a3")['Value'] = 1 
excel.Range("a1:a3").Select() 

excelchart = excel.Charts.Add() 
excelchart['Type'] = ChartTypeVal 
30.step(180, 5) do |rot| 
    excelchart.rotation = rot 
    sleep(0.1) 
end 
excel.ActiveWorkbook.Close(0) 
excel.Quit()








Related examples in the same category

1.Using WIN32OLE with Excel
2.Create a chart in Excel
3.Set cell value and read it back
4.Add some more sheets