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.
on 2007-03-29 21:56
on 2007-03-29 22:07
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
on 2007-03-29 22:09
gem install spreadsheet-excel gem install parseexcel Fredrik