Forum: Ruby on Rails parse excel file

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
kb (Guest)
on 2007-03-29 23:56
(Received via mailing list)
is there a way to nativley read from and write to an excel (.xls) file
with Ruby.  I want users to be able to upload data from Excel into a
MySQL database.
andy_w (Guest)
on 2007-03-30 00:07
(Received via mailing list)
try converting the excel file into csv format first. it will be easy
then to parse its content and add each line to your desired database.
thats way you will also be able to implement filters...
try "save as" in excel and select csv format as file extension

cheers, and hooray my first post here :D
Fredrik (Guest)
on 2007-03-30 00:09
(Received via mailing list)
gem install spreadsheet-excel
gem install parseexcel

Fredrik
This topic is locked and can not be replied to.