Jason

if you (can) send me the xls in question off list, I'll be happy to investigate.

cheers,
Hannes

On 10/2/06, Paul Lutus <nospam / nosite.zzz> wrote:
> 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
>
>