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
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
Once we added the Driver.It started working.
Thus we need not have the entire excel installed on production server,
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
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
Once we added the Driver.It started working.
Thus we need not have the entire excel installed on production server,
Comments
Post a Comment