How to make any excel related code work in production environment without installing entire Excel

Hi ,
We had faced an issue in one of the sharepoint application.
It was using related to excel :  code to create and generate excel files.
We had entire excel 2013 installed on development environmnet.The functionality was working fine in dev enviroment.
When we move the site to production environment,we found that the code of not working.
We thaught we need to have entire excel installed for this to work.
Since it was a production env,it is not recommended to install Excel
After some reasearch we found that we need to install the following plugin:

You need to install this plugin on all your WFE servers.
After installation go to ODBC Data source 64 bit
odbc1png.png




Here you can see before installing the plugin no excel data source was present.after installing the plugin we added the data source by going to add
odbc.png


Once we added the Driver.It started working.
Thus we need not have the entire excel installed on production server,

Comments