Forum: Ruby undefined method `at' for nil:NilClass in parseexcel.help pl

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
87303c28b23af9aa69831b6bd156fdb0?d=identicon&s=25 Ruhul Amin (tuhin_cse99)
on 2007-02-23 09:41
 use this code to open my '2007-02-231028.xls' file. the file is in the
same directory of the program.
my code:

require 'parseexcel'

workbook = Spreadsheet::ParseExcel.parse('2007-02-231028.xls')

worksheet = workbook.worksheet(0)

skip = 2
worksheet.each(skip) { |row|
# a row is actually just an Array of Cells..
first_cell = row.at(0)

}

Error is:
undefined method `at' for nil:NilClass

I can not understand the error. please help me as i am a niwbie in ruby
87303c28b23af9aa69831b6bd156fdb0?d=identicon&s=25 Ruhul Amin (tuhin_cse99)
on 2007-02-23 10:45
Ruhul Amin wrote:
>  use this code to open my '2007-02-231028.xls' file. the file is in the
> same directory of the program.
> my code:
> require 'parseexcel'
> workbook = Spreadsheet::ParseExcel.parse('2007-02-231028.xls')
>  worksheet = workbook.worksheet(0)
>  skip = 2
> worksheet.each(skip) { |row|
> # a row is actually just an Array of Cells..
> first_cell = row.at(0)
> > }
>  Error is:undefined method `at' for nil:NilClass
> I can not understand the error. please help me as i am a niwbie in ruby

please help me.
Afabd225e57b433553138fead5a820d4?d=identicon&s=25 Raj Sahae (rajsahae)
on 2007-02-23 12:21
(Received via mailing list)
I don't know anything about the parseexcel library, but I can at least
explain the error.
The error you are getting simply says that the object"row", which is the
parameter you pass into your block from worksheet.each, is an instance
of Nil, and not an Array.  So either the parse, workbook, or worksheet
is returning Nil somewhere.
87303c28b23af9aa69831b6bd156fdb0?d=identicon&s=25 Ruhul Amin (tuhin_cse99)
on 2007-02-23 12:57
Raj Sahae wrote:
> I don't know anything about the parseexcel library, but I can at least
> explain the error.
> The error you are getting simply says that the object"row", which is the
> parameter you pass into your block from worksheet.each, is an instance
> of Nil, and not an Array.  So either the parse, workbook, or worksheet
> is returning Nil somewhere.

thx for ur response. I also guessed so. but why? The problem comes
when i try to read japanese text. Any other way by which i can read
japanese
text to in my mysql database.

problems are:
1. japanese text
2. read data from the particular cell

plz help me with some sample code.

waiting for ur response

Amin
23172b6630dc631a134c9bad2fec2a39?d=identicon&s=25 ChrisH (Guest)
on 2007-02-23 18:01
(Received via mailing list)
On Feb 23, 6:57 am, Ruhul Amin <tuhin_cs...@yahoo.com> wrote:
> japanese
> Amin
>
> --
> Posted viahttp://www.ruby-forum.com/.

It looks like when a row contains no data it is set to nil.
Are certain the row you are reading has data?

Cheers
Chris
Feee221f9eb7818d90625ea141bfd60c?d=identicon&s=25 bbiker (Guest)
on 2007-02-23 22:46
(Received via mailing list)
On Feb 23, 3:41 am, Ruhul Amin <tuhin_cs...@yahoo.com> wrote:
> skip = 2
>
> --
> Posted viahttp://www.ruby-forum.com/.

Are you sure the syntax is correct ...
1. never seen code where each takes parameter
2. worksheet is a single object .. not an array of worksheets
3. Perhaps it should be worksheet.Rows.each { |row| do whatever
including skipping }
753dcb78b3a3651127665da4bed3c782?d=identicon&s=25 Brian Candler (Guest)
on 2007-02-25 20:45
(Received via mailing list)
On Sat, Feb 24, 2007 at 06:45:08AM +0900, bbiker wrote:
> Are you sure the syntax is correct ...
> 1. never seen code where each takes parameter

I have. There was an hour-long video presentation about TextMate posted
here
a week or two ago. In it, the presenter wrote a program to solve the
Pascal's Triangle Ruby Quiz. His #each method took a parameter which let
you
specify the the number of rows you wanted to generate - otherwise, it
would
iterate infinitely.

Regards,

Brian.
This topic is locked and can not be replied to.