search

glebm / to_spreadsheet

Render XLSX from Rails using existing views (html ⇒ xlsx)
Other
91 stars 37 forks source link

Testing with MS Excel (MacOffice v15) #25

Open petrosp opened 8 years ago

petrosp commented 8 years ago

Hi there, Excel does not seem to like the format that this gem creates. I am using Yosemite 10.10.5 and Microsoft Excel 2015.

I am following the instructions as documented in the README file, and when I use the xslx format, I get an errors from MS Excel:

The file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

If I change the format to xls, I can open with Excel but it complaints before:

The file format and extension of 'comptoxls-12.xls' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?