Win32OLE提供的Excel操作

首先创建excel的WIN32OLE对象：excel= WIN32OLE.new('Excel.Application')

1.  打开excel文件：

     workbook =excel.Workbooks.Open('c:\examples\spreadsheet.xls') 

2.创建sheet：workbook = excel.Workbooks.Add() 

3.删除sheet：excel.DisplayAlerts = false

4.定位sheet，并且切换sheet：

        worksheet = workbook.Worksheets(1) #定位到第一个sheet 

        worksheet.Select

5.定位到某个sheet的某个单元格，并且进行修改值：（cells和Range）

   cells = sheets.cells("A1:A5") 

   cells.each do |cell| 

      cell.value = 10 

   end

  worksheet = workbook.Worksheets(1); 

  worksheet.Range("A1:D1").value =["North","South","East","West"]; 

  worksheet.Range("A2:B2").value =[