How to convert Csv into Excel

[Sasi]

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 .

[qwan]

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

[Colin Law]

The spreadsheet gem may help.

Colin

[Michael Pavling]

On 7 November 2011 09:27, qwan <goo...@autotelik.co.uk> 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... :-/

[Colin Law]

On 7 November 2011 09:27, qwan <goo...@autotelik.co.uk> 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