Is there any way to convert .xlsx to .xls

Rails
1

Hello G.s, 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.

2

On 4 October 2013 15:21, Monserrat F. [email protected] wrote:

Hello G.s, 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

3

I meant, any gems, to use on rails

4

Joel P. 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.

5

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

6

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?

7

On 4 October 2013 17:13, Monserrat F. [email protected] 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

8

Yes, that’s how “editing” files usually works. You overwrite a modified
copy of the file.

9

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