Convert excel spreadsheet to csv

is there any library to convert excel file to csv.
apprecaite ur help

Junkone wrote:

is there any library to convert excel file to csv.
apprecaite ur help

Just use the OLE interface to open the spreadsheet, then do a "save as" CSV.

try the gem 'roo'!

-Thomas

···

On 27/12/2007, Junkone <junkone1@gmail.com> wrote:

is there any library to convert excel file to csv.
apprecaite ur help

--
Thomas Preymesser
thopre@gmail.com
thomas@thopre.com
Büro: 030 - 830 353 88
mobil: 0176 - 75 03 03 04
Privat: 030 - 49 78 37 06

Try ruport.......

its a report generating tool......

···

--
Posted via http://www.ruby-forum.com/.

roo does not export ms excel spreadsheets. it only does open office
and goffice spreadsheets to csv.

···

On Dec 27, 5:42 am, Thomas Preymesser <tho...@gmail.com> wrote:

On 27/12/2007, Junkone <junko...@gmail.com> wrote:

> is there any library to convert excel file to csv.
> apprecaite ur help

try the gem 'roo'!

-Thomas

--
Thomas Preymesser
tho...@gmail.com
tho...@thopre.com
Büro: 030 - 830 353 88
mobil: 0176 - 75 03 03 04
Privat: 030 - 49 78 37 06http://thopre.wordpress.com/http://www.thopre.com/

Open the excel file and save it as a csv file.!!!

···

On Dec 27, 1:29 am, Ratnavel Sundaramurthi <ratnave...@gmail.com> wrote:

Try ruport.......

its a report generating tool......
--
Posted viahttp://www.ruby-forum.com/.

The web site at http://roo.rubyforge.org/ claims that it works with
Excel spreadsheets. Is this not correct?

···

On Dec 27, 8:36 am, Junkone <junko...@gmail.com> wrote:

roo does not export ms excel spreadsheets. it only does open office
and goffice spreadsheets to csv.

I will fix this in the next release.

-Thomas

···

On 27/12/2007, Junkone <junkone1@gmail.com> wrote:

roo does not export ms excel spreadsheets. it only does open office
and goffice spreadsheets to csv.

Oh - but it should ...

--
Thomas Preymesser
thopre@gmail.com
thomas@thopre.com
Büro: 030 - 830 353 88
mobil: 0176 - 75 03 03 04
Privat: 030 - 49 78 37 06

Excel#to_csv is now available again in release 0.8.2
Sorry, it disappeared with the last great restructuring of my gem.

-Thomas

···

On 27/12/2007, Junkone <junkone1@gmail.com> wrote:

roo does not export ms excel spreadsheets. it only does open office
and goffice spreadsheets to csv.

--
Thomas Preymesser
thopre@gmail.com
thomas@thopre.com
Büro: 030 - 830 353 88
mobil: 0176 - 75 03 03 04
Privat: 030 - 49 78 37 06

bbiker wrote:

Try ruport.......

its a report generating tool......
--
Posted viahttp://www.ruby-forum.com/.

Open the excel file and save it as a csv file.!!!

That's what I said ... you have to code it in Ruby, though ... doing it
with the mouse is cheating! :slight_smile:

OK ... Ruby Quiz proposal ... what's the most complicated path you can
come up with to do this? Open the spreadsheet as a database in Rails?
Extra points for requiring a Windows machine, a Linux machine and a Mac.
Even more extra points for doing it totally without a Windows machine.
Anything goes -- OpenOffice bindings -- uploading it to Google Office --
AJAX -- decoding the binary with "unpack" -- you name it.

:wink:
:wink:

···

On Dec 27, 1:29 am, Ratnavel Sundaramurthi <ratnave...@gmail.com> > wrote:

what's the most complicated path you can come up with to do this?

lol

···

--
Posted via http://www.ruby-forum.com/\.

bbiker wrote:
> Open the excel file and save it as a csv file.!!!
>
That's what I said ... you have to code it in Ruby, though ... doing it
with the mouse is cheating! :slight_smile:

... but very _pragmatic_! :wink:

OK ... Ruby Quiz proposal ... what's the most complicated path you can
come up with to do this?

Actually IMHO that's a bad quiz idea because with whatever solution
someone comes up, you will be able to find a more complicated solution
by simply adding a step. :slight_smile:

Kind regards

robert

···

2007/12/27, M. Edward (Ed) Borasky <znmeb@cesmail.net>:

--
use.inject do |as, often| as.you_can - without end