Exporting Data to Excel in Discountasp.nt

[Muralikanacheen]

Hi to all,

We are using Interop.Excel.dll for exporting the data from asp.net 2.0 application to excel through programming. In our local system is working fine, but the same is uploaded in our server ie., in discountasp.net is not working and just it open a empty excel sheet.

Any idea on how to export data from discountasp.net server to excel


Thanks,
Murali

[steveor]

Did you try putting the Interop.Excel.dll in your /bin directory ?

If the Interop.Excel.dll needs to be registered, I am afraid we would be unable to register the dll it on the server. You would need to find an alternate method for exporting your data.

Some alternate methods for exporting data (http://blogs.msdn.com/erikaehrli/archive/2009/01/30/how-to-export-data-to-excel-from-an-asp-net-application-avoid-the-file-format-differ-prompt.aspx)

[raymondp]

This is not going to work on Discountasp's server. You will still need the Excel application installed on the server which we do not have.