How to convert Csv into Excel

#1

Is there any ruby gems or plugin which can be used for converting
(.csv) files inot (.xls) files , or is there any mechanism which can
be used for the conversion of files from csv to xls .

#2

Hi

I have written a toolkit in this area, still working toward releasing
the gem on ruby gems but
project/source is here https://github.com/autotelik/interact

The .xls file read/write requires JRuby but is OS independant and does
not require Excel be installed.

The main focus is import/export from active record direct to Excel or
CSV but all the tools for CSV->Excel are in there
… the excel wrapper to generate Excel from Ruby arrays/data is
under : lib / helpers / jruby / jexcel_file.rb and check out the
specs
and tasks such as interact tasks/excel_generator.rake

Hope that helps
Tom

#3

On 7 November 2011 04:50, Sasi removed_email_address@domain.invalid wrote:

Is there any ruby gems or plugin which can be used for converting
(.csv) files inot (.xls) files , or is there any mechanism which can
be used for the conversion of files from csv to xls .

The spreadsheet gem may help.

Colin

#4

On 7 November 2011 09:27, qwan removed_email_address@domain.invalid wrote:

Hi

I have written a toolkit in this area, still working toward releasing
the gem on ruby gems but
project/source is here https://github.com/autotelik/interact

Are you planning to support ods files? That is something I am sorely
missing. At the moment I have to use the spreadsheet gem to generate
xls files which I then access from LibreOffice. Yuk!

Colin

#5

On 7 November 2011 09:27, qwan removed_email_address@domain.invalid wrote:

I have written a toolkit in this area, still working toward releasing
the gem on ruby gems but
project/source is here https://github.com/autotelik/interact

http://xkcd.com/974/

I tend to just open the CSV in Excel… :-/