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
11155
(-- --)
October 4, 2013, 4:19pm
4
I've never personally used it, but allegedly
axlsx | RubyGems.org | your community gem host should work.
11155
(-- --)
October 4, 2013, 4:29pm
5
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?
11155
(-- --)
October 4, 2013, 9:36pm
7
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