From: Paul Lutus Date: 2006-10-02T14:30:13+09:00 Subject: Re: parseexcel and email fields Jason Fox wrote: > > > I am having a problem reading in a spreadsheet that contains email > addresses in one of the columns. I get a "cannot convert nil into > String" error when I try to parse the spreadsheet (see below). > > Has anyone else had success with using parseexcel with spreadsheets that > contain email addresses? Any help would be much appreciated. > > Regards, > Jason > > Here is the stack trace: > > can't convert nil into String - (TypeError) > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/olestorage.rb:249:in `<<' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/olestorage.rb:249:in > `get_big_data' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/olestorage.rb:138:in > `get_data' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/olestorage.rb:290:in > `get_nth_pps' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/olestorage.rb:281:in > `get_nth_pps' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/olestorage.rb:199:in > `initialize' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/olestorage.rb:355:in > `get_header' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/olestorage.rb:110:in > `initialize' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/parser.rb:172:in `parse' > /usr/local/lib/ruby/site_ruby/1.8/parseexcel/parseexcel.rb:10:in `parse' > .. > I am willing to bet the problem lies somewhere in the code ... the code you didn't post. -- Paul Lutus http://www.arachnoid.com