Ruby 设置 Excel 单元格数据并读取

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

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