Re: [Rails] How can I check if a cell is empty using RubyXL?

tried 

@projectCode = inventory[0][line][1].value if inventory[0][line][1].nil? 

and even testing inventory[0][line].nil? and inventory[0].nil? and I keep getting the same error

undefined method `[]' for nil:NilClass

I am overwriting @projectCode with each iteration because there's a comparison later. 

On Thursday, October 17, 2013 3:45:52 PM UTC-4:30, Colin Law wrote:

On 17 October 2013 19:58, Monserrat Foster <monse...@gmail.com> wrote:
> I'm trying to check if a cell is empty because when the parser reaches an
> empty cell it throws NoMethodError (undefined methodvalue' for
> nil:NilClass)`
>
> This is what I was trying to do:
>
> 1.upto(inventory[0].sheet_data.size) do |line|
>       @projectCode = inventory[0][line][1].value unless
> inventory[0][line][1].value.nil?

Is it not fairly obvious?  The error message says you are calling the
method value on something that is nil, so presumably
inventory[0][line][1] is nil.  So just test that for nil.  There are
nicer ways of coding this however, I might use
@projectCode = inventory[0][line][1].value if inventory[0][line][1]

However you seem to be in a loop that keeps overwriting @projectCode
but perhaps you have snipped out some of the code.

Colin

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/c0895c4a-42e7-459c-b2d0-bf02ca166aa6%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.