Set cell value and read it back : Excel « Windows Platform « Ruby






  1. Ruby
  2. Windows Platform
  3. Excel

Set cell value and read it back


require 'win32ole' 

excel = WIN32OLE.new("excel.application") 
excel.Workbooks.Add 


excel.Range("a1").Value = 10 
excel.Range("a2").Value = 20 
excel.Range("a3").Value = "=a1+a2" 
excel.Range("a1:a3").each do |cell| 
    p cell.Value 
end








Related examples in the same category

1.Using WIN32OLE with Excel
2.Create a chart in Excel
3.Create a chart and rotate it
4.Add some more sheets