Export Excel not working in Server

Question

Hello All,   I am working with Excel. i have a an issue if i export to excel in local Machine it's working fine when i Deploy in server it's not working i got an error like Request failed.    Here is my code:     public JsonResult ExportEMCTSReleaseDetails() {         Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();    try    {          Excel.Workbook xlWb;          Excel.Worksheet xlWs;          long lnRelease = 0;          int iRevision;          string strHeader = string.Empty;          string strEMCTSRelease = string.Empty;          string strShtName = string.Empty;          string strProject = string.Empty;          string strDesign = string.Empty;           string strDRevision = string.Empty;           for (int j = 0; j           {                      if (SearchRecords[j].Comments == "History Starts")                      {                            SearchRecords.RemoveRange(j, SearchRecords.Count() - j);                              break;                        }             }             xlApp.SheetsInNewWorkbook = SearchRecords.Count();             xlWb = xlApp.Workbooks.Add();          List RelDetailsSearchRecords = new List ();             int r;             for (int i = 0; i             {                   lnRelease = SearchRecords[i].ReleaseID;                   iRevision = (int)SearchRecords[i].Revision;                   RelDetailsSearchRecords = null;                   RelDetailsSearchRecords = GetEMCTSReleaseVersionRecords(lnRelease, iRevision);                   r = 5;                   xlWs = xlWb.Worksheets.get_Item(i + 1);                   RelDetailsSearchRecords.ForEach(delegate(IndexEmctestSetup e)                   {                   strEMCTSRelease = e.ReleaseName;                   strProject = e.Project;                   xlWs.Cells[r, 1] = e.ReleaseName + " - " + e.ReleaseRevision;                strShtName = e.ReleaseName + " - " + e.ReleaseRevision;                xlWs.Cells[r, 2] = e.Project;                   xlWs.Cells[r, 3] = e.ECSEMCTestSetupId + " - " + e.Revision;                xlWs.Cells[r, 4] = e.ECSSuitcaseTesterId;                xlWs.Cells[r, 5] = e.ECSSuitcaseControllerId;                xlWs.Cells[r, 6] = e.ECSEMCLoadBoxId;                xlWs.Cells[r, 7] = e.ECSEMCModuleId;                  xlWs.Cells[r, 8] = e.HarnessId;                   xlWs.Cells[r, 9] = (!string.IsNullOrEmpty(e.DataCollector)) && (e.DataCollector != clsLists.NA) ? e.DataCollector : clsLists.NA;                xlWs.Cells[r, 10] = (!string.IsNullOrEmpty(e.TriggerBox)) && (e.TriggerBox != clsLists.NA) ? e.TriggerBox : clsLists.NA;                  xlWs.Cells[r, 11] = e.Location;                   xlWs.Cells[r, 12] = e.Disposition;                xlWs.Cells[r, 13] = e.Comments;                   r++;                }); strHeader = "EMCTestSetup Release \"" + strShtName + "\" Exported on: " + System.DateTime.Now.ToString() + " by \"" + clsLists.getCurrentUserEmail() + "\""; project pr = ReleaseEMCTSDB.projects.Where(x => x.ProjectName == strProject).FirstOrDefault(); platform pf = ReleaseEMCTSDB.platforms.Where(x => x.PlatformId == pr.Platform_Proj).FirstOrDefault(); strProject = "Project: " + strProject + "(" + pr.ProjectDescription + ")"; releasesemctestsetup rel = ReleaseEMCTSDB.releasesemctestsetups.Where(m => m.ReleaseName == strEMCTSRelease).FirstOrDefault(); strDesign = "Release Design: " + clsLists.getDesigns().Find(x => x.Value == rel.Design).Text; strDRevision = "Release Design Revision: " + rel.DesignRevision.ToString(); xlWs.Cells[1, 1] = strHeader; xlWs.Cells[2, 1] = strProject; xlWs.Cells[3, 1] = strDesign; xlWs.Cells[3, Convert.ToInt32(clsLists.getEMCTSReleaseDetailsExportParamList().Count / 2)] = strDRevision; int col = 1; clsLists.getEMCTSReleaseDetailsExportParamList().ForEach(delegate(string strParam) { xlWs.Cells[4, col] = strParam; col++; }); xlWs.Name = strShtName; Excel.Range rng; rng = xlWs.get_Range((Excel.Range)xlWs.Cells[1, 1], (Excel.Range)xlWs.Cells[1,…

Bobby Milligan · Answer

You really should reconsider using the COM based automation (Excel Interop) on the server side, this is highly un-recommended by MS, see here why . Instead you should use some other approach for generating your spreadsheets, for example you may want to take a look at this .NET library for excel files . Here is an article that shows how to both read and write excel file in ASP.NET application .

Hari B · Answer

I have seen same issue in msdn like below for excel permissions
goto Controlpanel --> Administrative tools-->Component Services -->computers --> myComputer -->DCOM Config --> Microsoft Excel Application.
https://social.msdn.microsoft.com/Forums/en-US/b6388275-b295-4e55-8c25-6d8788eac1ca/error-while-creating-excel-object
my system is windows 7 64-bit. i could not found excel application.

Guest User · Answer

Then you do not have permission to access Excel. Contact the administrator.

Hari B · Answer

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{00024500-0000-0000-C000-000000000046}
when i observe the log i got this issue

Guest User · Answer

Writing it to a file is the simplest method.

Hari B · Answer

Local system or any other system working fine. while i put it in server not working so how can i log the exception Message??

Guest User · Answer

There is no exception because you catch it and return a JSON message stating failed. At that point you should log the exception message and stacktrace. It's the only way to find out what the problem is.

Hari B · Answer

Popup came in View Page

Guest User · Answer

Where does the popup come from then? It has to be coded somewhere.

Hari B · Answer

There is no exceptions. just came popup like Request Failed