ruby读取excel数据

samwalt

Windows平台

require 'win32ole'require 'fileutils'working_path = ""working_path.concat(Dir.getwd).concat('/')excel_file = WIN32OLE.new('Excel.Application')workbook = excel_file.workbooks.open(working_path + ARGV[0]) worksheet = workbook.worksheets(1)worksheet.selectline_num = 2id = worksheet.range("A#{line_num}").valueipAddress = worksheet.range("B#{line_num}").valuebegin  while id && ipAddressnew_file_name = prefix + '_' + (line_num-1).to_s + suffix  # the name of the new xml fileFileUtils.cp(ARGV[1], new_file_name)modify_xml_file(new_file_name, id, ipAddress)line_num += 1id = worksheet.range("A#{line_num}").valueipAddress = worksheet.range("B#{line_num}").value  endrescue Exception => eputs eensure  excel_file.quitend