is there any way to convert .xlsx to .xls

[Monserrat Foster]

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. 

[Colin Law]

On 4 October 2013 15:21, Monserrat Foster <monse...@gmail.com> 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...@googlegroups.com.
> To post to this group, send email to rubyonra...@googlegroups.com.
> 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.

[Monserrat Foster]

I meant, any gems, to use on rails

[Joel Pearson]

I've never personally used it, but allegedly
http://rubygems.org/gems/axlsx should work.

--
Posted via http://www.ruby-forum.com/.

[Joel Pearson]

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.

[Monserrat Foster]

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?

[Joel Pearson]

Yes, that's how "editing" files usually works. You overwrite a modified
copy of the file.

[Colin Law]

On 4 October 2013 17:13, Monserrat Foster <monse...@gmail.com> wrote:
> I meant, any gems, to use on rails

I 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

[Ivan Histand]

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