Unable to read excel files in Production environment but working in dev environment

Question

Using Spreadsheet GEM, I am able to read xls files in development environement. As I move to production server, application is unable to read xls files.

Please help what can be the likely changes I am missing on to make it work in production environment too.

Thanks in advance

Answer 1

Do you have the gem installed on the production server?

Answer 2

Spreadsheet Gem is installed already. I am getting no error while uploading files. But the data in the xls files I am not able to read.

For. e.g my xls has 4 cols. A,B,C,D and data is present in 2 rows.

First Row has data : P1,P1,P3,P4 Second Row has data : Q1,Q2,Q3,Q4

In dev. env. I get the data as P1,P1,P3,P4 for first row and Q1,Q2,Q3,Q4 for second row.

But in prod. env. I get the no data. It gives blank for all columns.