Ruby操作Excel文件
写了一段Ruby操作Excel的脚本，使用OLE方式，功能是从Excel中读取第一列有效数据至数组，分析后将数据分类存入几个集合，并输出至Excel中
?
?
require "win32ole"excel = WIN32OLE.new('excel.application')excel.Visible = trueworkBook = excel.WorkBooks.Open('c:/a.xlsx')workSheet = workBook.Worksheets(1)workSheet.Selectline = 1data = []query = []statistic = []# 读取第一列数据Axwhile workSheet.Range("a#{line}").Valuevalue = workSheet.Range("a#{line}").ValuekeyWord = value.split('=')[0].upcaseif keyWord.include? 'QUERY'query << valueelsif keyWord.include? 'STATIS'statistic << valueelsedata << valueendline += 1end# 写入数据Hxfor i in 0...data.sizeworkSheet.Range("h#{i + 1}").Value = data[i]endexcel.ActiveWorkBook.Close(1)excel.Quitp "query=#{query.size}"p "statis=#{statistic.size}"p "data=#{data.size}"