Parse excel file


#1

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.


#2

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 :smiley:


#3

gem install spreadsheet-excel
gem install parseexcel

Fredrik