Unable to download excel file extracted from our application

Question

Hi I will be happy if you can help suggest solution to our problem our site hosted is generating excel file when a visitor click the specific button if that is done it generate the following error Could not load file or assembly 'Microsoft.Office.Interop.Excel Version=15.0.0.0 Culture=neutral PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) . i have use the excel.Application Visible =False. and i have directed the output to a stream for download string PathsTo = directoryPath +drpProgramArea.SelectedItem.Text.Trim()+-+drpYears.SelectedItem.Text.Trim()+-+drpYears2.SelectedItem.Text + .xls; //============ Download Excel file ===================== Response.Clear(); Response.Buffer = true; Response.Charset = ; Response.ContentType = application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; Response.AddHeader(content-disposition attachment;filename= + PathsTo); using (MemoryStream MyMemoryStream = new MemoryStream()) { xlWBK.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } this is what i have tried. any suggestion will be appreciated.

Nilesh Sawardekar · Answer

In web.config file and many other office assemblies. The thing I have done is that I have removed all the assemblies from web.config file and had added dlls as a reference - Microsoft.Office.Interop.Excel.dll in this case. I am not an expert and I just thinking loudly that web.config file is trying to pull dll. file from C:\Windows\assembly\ and if there if it could not be foud returns error. You don't have to install office or other unneccessary stuff on you server. or else Install MS Office (MS Excel)