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! 
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.
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!
… but very pragmatic! 
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. 
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
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
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