I have a ASP.Net application and I am exporting the report into excel. It is working fine in my development system which has IIS 5.1. But when I deploy this in the production which has IIS 6.0, it is not showing the excel page. So i created a sample code and deployed in the production and this is also not working. Here is my code
public void DynamicExcel()
Excel.Application excel = new Excel.Application();
excel.Visible = true;
response.write("Visible: " + excel.Visible);
I am calling DynamicExcel function on click of button. In local system out of response.write "Visible: True" but in production it is "Visible: False". I think this is the reason why excel page is not displaying. Is there any do be done to display the excel page?
Thanks in advance