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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 29 Mrz., 21:53, "kb" <KKBarr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
gem install spreadsheet-excel gem install parseexcel Fredrik On Mar 29, 2:53 pm, "kb" <KKBarr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---