is there any way to convert .xlsx to .xls

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.

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 meant, any gems, to use on rails

I've never personally used it, but allegedly axlsx | RubyGems.org | your community gem host should work.

Joel Pearson wrote in post #1123519:

I've never personally used it, but allegedly axlsx | RubyGems.org | your community gem host should work.

My mistake, that only outputs xlsx. Roo seems to be the obvious choice.

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?

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

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

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