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 ruport…

its a report generating tool…

bbiker wrote:

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

OK … Ruby Q. 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 S. [email protected]
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.!!!

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

lol

On Dec 27, 5:42 am, Thomas P. [email protected] wrote:

Thomas P.
[email protected]
[email protected]
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/

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

2007/12/27, M. Edward (Ed) Borasky [email protected]:

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 Q. 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

On 27/12/2007, Junkone [email protected] wrote:

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

try the gem ‘roo’!

-Thomas


Thomas P.
[email protected]
[email protected]
Büro: 030 - 830 353 88
mobil: 0176 - 75 03 03 04
Privat: 030 - 49 78 37 06


http://www.thopre.com/

On 27/12/2007, Junkone [email protected] wrote:

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

Oh - but it should …
I will fix this in the next release.

-Thomas


Thomas P.
[email protected]
[email protected]
Büro: 030 - 830 353 88
mobil: 0176 - 75 03 03 04
Privat: 030 - 49 78 37 06


http://www.thopre.com/

On Dec 27, 8:36 am, Junkone [email protected] wrote:

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

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

On 27/12/2007, Junkone [email protected] wrote:

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

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

-Thomas


Thomas P.
[email protected]
[email protected]
Büro: 030 - 830 353 88
mobil: 0176 - 75 03 03 04
Privat: 030 - 49 78 37 06


http://www.thopre.com/

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs