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

downup

1. require 'win32ole'
   
2. 
   
3. excel = WIN32OLE.new("excel.application")
   
4. excel.Workbooks.Add
   
5. 
   
6. 
   
7. excel.Range("a1").Value = 10
   
8. excel.Range("a2").Value = 20
   
9. excel.Range("a3").Value = "=a1+a2"
   
10. excel.Range("a1:a3").each do |cell|
    
11.     p cell.Value
    
12. end

复制代码