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
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 }
···
On Feb 23, 3:41 am, Ruhul Amin <tuhin_cs...@yahoo.com> wrote:
use this code to open my '2007-02-231028.xls' file. the file is in the
same directory of the program.
my code:
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.
···
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
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.
···
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 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
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
···
On Feb 23, 6:57 am, Ruhul Amin <tuhin_cs...@yahoo.com> wrote:
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