Generate monkey code

generate_monkey_code.rb

require 'rubygems'
require 'spreadsheet'

TEMPLATE = "template.xls"
LOCAL_FILE_NAME = "generated.txt"

Spreadsheet.client_encoding = 'UTF-8'

def inspect_sheet sheet
  File.open(LOCAL_FILE_NAME, 'w') {|f|
    sheet.each do |row|
      if true
        type = "TextVariableField"
      end
      line = "lineLayout.addField(new #{type}('IDC-REG', #{row[2]}));"
      f.puts(line)
    end
  }
end

template = Spreadsheet.open TEMPLATE
sheet = template.worksheet 0

inspect_sheet(sheet)