读取excel 用roo plugin

task :get_unit_data => :environment do
       require 'roo'
       s = Excel.new("unit.xls")
       s.default_sheet = s.sheets.first
       start_row = s.first_row
       end_row = s.last_row
       start_column = s.first_column
       end_column = s.last_column
       (start_row..end_row).each do |row|
            unit_name = ""
            unit_abbr = ""
            is_defalut = false
            is_conversion = false
            is_equation = false
            value = ""
            (start_column..end_column).each do |col|

                data = s.cell(row,col,s.sheets.first).to_s
                    next if data.blank?
                    next if (data=~/\d/)==1
              
                    name = data.split("(").first  if col ==1
                    unit_name = data if col==2
                    unit_abbr = data if col==3
                    if col > 3
                      is_defalut = true if data=~/defa/
                      is_equation = true if data=~/equa/
                      is_conversion = true if data=~/conver/
                      value = data  if data=~/\d/
                    end
                   
                     puts name  unless name.blank?
                     unit_group = UnitGroup.create({:name => name,:company_uid => SYS_UID}) unless name.blank?
                  
             
            end
            if (!unit_name.blank?) || (!unit_abbr.blank?)
              Unit.transaction  do
                unit = Unit.new
                unit.name = unit_name
                unit.abbreviation = unit_abbr
                unit.is_default = is_defalut
                unit.is_conversion = is_conversion
                unit.is_equation  = is_equation
                unit.value = value
                if unit.save
                  unit_group = UnitGroup.last
                  unit_group.units << unit
                end
              end
               puts row
            end
           
       end
  end