ruby代码将查找数据存入execl表的处理.rb

ruby代码将查找数据存入execl表的处理.rb

require 'win32ole'

application = WIN32OLE.new('Excel.Application')

worksheet1 =application.Workbooks.Open(File.dirname(__FILE__) + '/' + "1.xls")
worksheet = worksheet1.Worksheets('Sheet1')
application.DisplayAlerts = false

worksheet.Activate
contLoop = true           # Dummy counter for the loop

while contLoop do

worksheet.Cells(1, 1).Value = 11111
worksheet.Cells(1, 2).Value = 11111222
#puts colVal
#if (colVal) then
#
## 如果这个字段非空，则表示这行有值
#
## 在这里处理读取
#
##do processing ….
#
#else
#
## 这里表明结束。
#
## End the loop
#
#
#end
contLoop = false

# go to the next Row

#row +=  1

end

# we are done
worksheet1.save
application.Workbooks.Close
puts 'ok'