gem install roo -v '1.9.5'

class Product < ActiveRecord::Base
  attr_accessible :name, :price, :released_on

  def self.import(file)
    spreadsheet = Excel.new(file)
    header = spreadsheet.row(1)
    (2..spreadsheet.last_row).each do |i|
      row = Hash[[header, spreadsheet.row(i)].transpose]
      product = find_by_id(row["id"]) || new
      product.attributes = row.to_hash.slice(*accessible_attributes)
      product.save!
    end
  end
end

require File.expand_path('../config/application', __FILE__)

TestDb::Application.load_tasks

desc "import product to db"
task :import => :environment do |t, args|
  Product.import("f:/test.xls")
end