Ruby Excel 文件操作之添加 Sheet

downup

1. require 'win32ole'
   
2. 
   
3. excel = WIN32OLE.new("excel.application")
   
4. excel['Visible'] = true
   
5. workbook = excel.Workbooks.Add(1)
   
6. worksheet= workbook.Worksheets("Sheet1")
   
7. worksheet.name="Ruby Greetings"
   
8. worksheet.Cells(1, 1)['Value']='Hello Ruby Fans'
   
9. worksheet.Cells(1, 1).Font['Bold']=true
   
10. worksheet.Cells(1, 1).font['size']=18
    
11. 
    
12. for name in ['dog', 'cat', 'rabbit', 'bird']
    
13.    worksheet = workbook.Worksheets.Add
    
14.    worksheet.name=name
    
15.    for row in 2..6
    
16.       for col in 2..10
    
17.          worksheet.Cells(row, col)['Value']="(#{row}, #{col})"
    
18.       end
    
19.    end
    
20.    for col in 2..10
    
21.         worksheet.Columns(col).AutoFit
    
22.    end
    
23. end

复制代码

Sapien

这个在所有系统上都能用吗？还是只能用于 Windows？

2gua

回复 2# Sapien


    Windows，毫无疑问。