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:inget_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:inget_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:ininitialize’
/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:ininitialize’
/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:inparse’
…