'Unhandled celltype datetime' exception when saving an Excel spreadsheet to csv using to_csv

[John McDowall]

I am getting the following exception whenever I try to save an Excel
spreadsheet as a CSV and it has a column which has a cell type of
datetime:

unhandled celltype datetime
"/usr/local/lib/ruby/gems/1.9.1/gems/roo-1.9.3/lib/roo/
generic_spreadsheet.rb:609:in `block (2 levels) in
write_csv_content'", "/usr/local/lib/ruby/gems/1.9.1/gems/roo-1.9.3/
lib/roo/generic_spreadsheet.rb:605:in `upto'",
"/usr/local/lib/ruby/gems/1.9.1/gems/roo-1.9.3/lib/roo/
generic_spreadsheet.rb:605:in `block in write_csv_content'", "/usr/
local/lib/ruby/gems/1.9.1/gems/roo-1.9.3/lib/roo/
generic_spreadsheet.rb:604:in `upto'",
"/usr/local/lib/ruby/gems/1.9.1/gems/roo-1.9.3/lib/roo/
generic_spreadsheet.rb:604:in `write_csv_content'", "/usr/local/lib/
ruby/gems/1.9.1/gems/roo-1.9.3/lib/roo/generic_spreadsheet.rb:158:in
`to_csv'"

Any ideas?

[Thomas Preymesser]

Hello John,

On 2 August 2011 18:38, John McDowall <jo...@minervabuilt.com> wrote:

I am getting the following exception whenever I try to save an Excel
spreadsheet as a CSV and it has a column which has a cell type of
datetime:

 

i have fixed this problem in the 1.9.6 version.

-Thomas

--
Thomas Preymesser
tho...@gmail.com
http://thopre.googlepages.com/
http://thopre.wordpress.com/

[Thomas Preymesser]

Hello John,

On 2 August 2011 18:38, John McDowall <jo...@minervabuilt.com> wrote:

I am getting the following exception whenever I try to save an Excel
spreadsheet as a CSV and it has a column which has a cell type of
datetime: