Forum: Ruby on Rails is there any way to convert .xlsx to .xls

5a41028798f4e263c2d0692f5b1847ec?d=identicon&s=25 Monserrat Foster (Guest)
on 2013-10-04 16:23
(Received via mailing list)
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.
5f94b9b346c2aa648a80bc259978e5bc?d=identicon&s=25 Colin Law (Guest)
on 2013-10-04 17:42
(Received via mailing list)
On 4 October 2013 15:21, Monserrat Foster <monsefoster@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
5a41028798f4e263c2d0692f5b1847ec?d=identicon&s=25 Monserrat Foster (Guest)
on 2013-10-04 18:14
(Received via mailing list)
I meant, any gems, to use on rails
14b5582046b4e7b24ab69b7886a35868?d=identicon&s=25 Joel Pearson (virtuoso)
on 2013-10-04 18:19
I've never personally used it, but allegedly
http://rubygems.org/gems/axlsx should work.
14b5582046b4e7b24ab69b7886a35868?d=identicon&s=25 Joel Pearson (virtuoso)
on 2013-10-04 18:29
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.
5a41028798f4e263c2d0692f5b1847ec?d=identicon&s=25 Monserrat Foster (Guest)
on 2013-10-04 18:36
(Received via mailing list)
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?
14b5582046b4e7b24ab69b7886a35868?d=identicon&s=25 Joel Pearson (virtuoso)
on 2013-10-04 23:36
Yes, that's how "editing" files usually works. You overwrite a modified
copy of the file.
5f94b9b346c2aa648a80bc259978e5bc?d=identicon&s=25 Colin Law (Guest)
on 2013-10-05 10:38
(Received via mailing list)
On 4 October 2013 17:13, Monserrat Foster <monsefoster@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
62cada4726d8c81ef00bfea442fb30a3?d=identicon&s=25 Ivan Histand (Guest)
on 2013-10-05 14:55
(Received via mailing list)
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-fil...
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.