Hello Guys, does anybody know if there''s anyway to upload a .xlsx file and then convert it to .xls file for later processing? i''d like to use spreadsheet to write a new xls file but it doesn''t support xlsx and the file is only importable with that format sadly. I saw roo but I don''t know if there''s a direct way to do it. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/db5f3c31-193c-4df2-adc3-6f2b317a9aef%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
On 4 October 2013 15:21, Monserrat Foster <monsefoster-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hello Guys, does anybody know if there''s anyway to upload a .xlsx file and > then convert it to .xls file for later processing? > > i''d like to use spreadsheet to write a new xls file but it doesn''t support > xlsx and the file is only importable with that format sadly.Use LibreOffice (free) to make your spreadsheet, it can read and write virtually any format including xls and xlsx. Colin> > I saw roo but I don''t know if there''s a direct way to do it. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/db5f3c31-193c-4df2-adc3-6f2b317a9aef%40googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out.-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLuYAYhNtF%3DqdhDhNWd53%2Bm7KBN67tA1%2BworbDeG30KE4g%40mail.gmail.com. For more options, visit https://groups.google.com/groups/opt_out.
I meant, any gems, to use on rails On Friday, October 4, 2013 11:10:33 AM UTC-4:30, Colin Law wrote:> > On 4 October 2013 15:21, Monserrat Foster <monse...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:>> > wrote: > > Hello Guys, does anybody know if there''s anyway to upload a .xlsx file > and > > then convert it to .xls file for later processing? > > > > i''d like to use spreadsheet to write a new xls file but it doesn''t > support > > xlsx and the file is only importable with that format sadly. > > Use LibreOffice (free) to make your spreadsheet, it can read and write > virtually any format including xls and xlsx. > > Colin > > > > > I saw roo but I don''t know if there''s a direct way to do it. > > > > -- > > You received this message because you are subscribed to the Google > Groups > > "Ruby on Rails: Talk" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to rubyonrails-ta...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org <javascript:>. > > To post to this group, send email to rubyonra...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<javascript:>. > > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/rubyonrails-talk/db5f3c31-193c-4df2-adc3-6f2b317a9aef%40googlegroups.com. > > > For more options, visit https://groups.google.com/groups/opt_out. >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/8e146e6c-d22a-4233-9371-8afb52b930da%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
I''ve never personally used it, but allegedly http://rubygems.org/gems/axlsx should work. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/a2e80eb62cc93d3ffd1fa0b374a16d5d%40ruby-forum.com. For more options, visit https://groups.google.com/groups/opt_out.
Joel Pearson wrote in post #1123519:> I''ve never personally used it, but allegedly > http://rubygems.org/gems/axlsx should work.My mistake, that only outputs xlsx. Roo seems to be the obvious choice. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/1c91087622ffd2d7a6b8a0429a09a4aa%40ruby-forum.com. For more options, visit https://groups.google.com/groups/opt_out.
according to this, http://roo.rubyforge.org/ roo only access .xls and .xslx files as read only, so, that means I should read it with roo and write it with another gem in .xls format? On Friday, October 4, 2013 11:59:06 AM UTC-4:30, Ruby-Forum.com User wrote:> > Joel Pearson wrote in post #1123519: > > I''ve never personally used it, but allegedly > > http://rubygems.org/gems/axlsx should work. > > My mistake, that only outputs xlsx. Roo seems to be the obvious choice. > > -- > Posted via http://www.ruby-forum.com/. >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/9083cfdf-8b58-46a9-a882-a43e1806dc74%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Yes, that''s how "editing" files usually works. You overwrite a modified copy of the file. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/ea1f8163c57b99f25c40477c7815bd08%40ruby-forum.com. For more options, visit https://groups.google.com/groups/opt_out.
On 4 October 2013 17:13, Monserrat Foster <monsefoster-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I meant, any gems, to use on railsI know you did, I was just pointing out that you could remove the problem by using LibreOffice to make the spreadsheet in the first place. If you must use MS Office then again the best solution would surely be to pay for an Office upgrade. Colin> > On Friday, October 4, 2013 11:10:33 AM UTC-4:30, Colin Law wrote: >> >> On 4 October 2013 15:21, Monserrat Foster <monse...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >> > Hello Guys, does anybody know if there''s anyway to upload a .xlsx file >> > and >> > then convert it to .xls file for later processing? >> > >> > i''d like to use spreadsheet to write a new xls file but it doesn''t >> > support >> > xlsx and the file is only importable with that format sadly. >> >> Use LibreOffice (free) to make your spreadsheet, it can read and write >> virtually any format including xls and xlsx. >> >> Colin >> >> > >> > I saw roo but I don''t know if there''s a direct way to do it. >> > >> > -- >> > You received this message because you are subscribed to the Google >> > Groups >> > "Ruby on Rails: Talk" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an >> > email to rubyonrails-ta...-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> > To post to this group, send email to rubyonra...-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> > To view this discussion on the web visit >> > >> > https://groups.google.com/d/msgid/rubyonrails-talk/db5f3c31-193c-4df2-adc3-6f2b317a9aef%40googlegroups.com. >> > For more options, visit https://groups.google.com/groups/opt_out.-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLu0a85k6dBveqL_kCYoLGpwCg%2BbwjMjeTr8ZO%2BKg-rXUg%40mail.gmail.com. For more options, visit https://groups.google.com/groups/opt_out.
Here''s some good info, I have not tried any of the methods they suggest but they look good: http://xmodulo.com/2012/06/how-to-convert-xlsx-files-to-xls-or-csv.html -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/2d76aa39-1791-4e1f-bf1b-f3084723e382%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.