Watir:Excel文件打开数据读取

require 'win32ole'
 #打开excel文件
excel = WIN32OLE.new("excel.application")
excel.visible = true
filepath="D:\\test.xls" #路径用两斜杠
workbook = excel.workbooks.open(filepath)
worksheet=workbook.worksheets(1)
#worksheet=workbook.worksheets("sheet name") 打开表名
#读取excel文件
data=[]
row=10
while worksheet.range("a#{row}").value
   #读取单元格数据赋给数组
   data << worksheet.range("a#{row}").value.to_s
   puts data[row-10]
   row+=1
 end
workbook.close
excel.Quit

注意文件路径的写法:filepath="D:\\test.xls"