Error accessing data from an array in ruby on rails

Question

The error tells me that the method '[]' is not defined in the line 127
this is my code and Idon't see the error

def verificar_area archivo
bandera= false
Spreadsheet.client_encoding = 'UTF-8'
book = Spreadsheet.open archivo
@wk = book.worksheet 0

areas = ["Secundaria",
"Preparatoria",
"Universitario",
"Edad 11 a 15 años",
"Edad de 16 a 19 años",
"Solo estudian",
"Adolescentes que trabajan y estudian"]

(1 .. @wk.row_count).each do |index_renglon|
  @renglon_excel = @wk.rows[index_renglon]
  area=@renglon_excel[8]                        #This is the line 127
    if areas.include?(area)
      bandera=true
    else
      bandera=false
      break
    end #fin if
  end #fin for
  return bandera
end

the error in the browser is this this is the line 127 => area=@renglon_excel[8]

Deepak Mahakale · Accepted Answer · 2017-03-08 06:54:06Z

1

You are getting the error because @renglon_excel is nil for that specific iteration

@renglon_excel[8]

And you are trying to access with index of [8] on nil

To avoid this you can add a check

@renglon_excel = @wk.rows[index_renglon]
next unless @renglon_excel
area = @renglon_excel[8]

answered Mar 8, 2017 at 6:54

Deepak Mahakale

23.8k10 gold badges73 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tadman Over a year ago

Also p @renglon_excel[8] if you're ever curious what that value is.

Collectives™ on Stack Overflow

Error accessing data from an array in ruby on rails

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related