From Server to Excel file downloading time this Probem Occur

Question

To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off".

Amit Kumar · Answer

worKbooK.Close(); string contentType = "application/excel" ; string path = System.Web.Configuration.WebConfigurationManager.AppSettings[ "ExcelPath" ].ToString() + "SurveyReport.xlsx" ; worKbooK.SaveAs(path); excel.Quit(); if (System.IO.File.Exists(path)) { byte [] fileBytes = System.IO.File.ReadAllBytes(path); return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "Download" + "surveyExcel.xlsx" ); }

Piyush Pansuriya · Answer

Hi, Did you get correct path using ? string path = System.Web.Configuration.WebConfigurationManager.AppSettings[ "ExcelPath" ].ToString() + "SurveyReport.xlsx" ; Please check once putting break point. If yes, Then use below code if (System.IO.File.Exists(path)) { byte [] fileBytes = System.IO.File.ReadAllBytes(path); return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "Download" + "surveyExcel.xlsx" ); } This is for existing file. If you are generating new file than use below code: return File(path, System.Net.Mime.MediaTypeNames.Application.Octet, "Download" + "surveyExcel.xlsx" );

Kalyani Shevale · Answer

@Amit Kumar ur code is executed on the local machine but on server same issue occurred"Web Config " string contentType = "application/excel" ; string path = System.Web.Configuration.WebConfigurationManager.AppSettings[ "ExcelPath" ].ToString() + "SurveyReport.xlsx" ; worKbooK.SaveAs(path); excel.Quit(); if (System.IO.File.Exists(path)) { byte [] fileBytes = System.IO.File.ReadAllBytes(path); return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "Download" + "surveyExcel.xlsx" ); } how to resolved this web config Issue.

Kalyani Shevale · Answer

@Amit Kumar Sir worKbooK.Close(); string contentType = "application/excel" ; string path = System.Web.Configuration.WebConfigurationManager.AppSettings[ "ExcelPath" ].ToString() + "SurveyReport.xlsx" ; worKbooK.SaveAs(path); excel.Quit(); if (System.IO.File.Exists(path)) { byte [] fileBytes = System.IO.File.ReadAllBytes(path); return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "Download" + "surveyExcel.xlsx" ); } this code using excel file generated in server location but how to download this excel file in download Folder.

Kalyani Shevale · Answer

@piyush sir if (System.IO.File.Exists(path)) { byte [] fileBytes = System.IO.File.ReadAllBytes(path); return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "Download" + "surveyExcel.xlsx" ); } but this code througth Code Executed but in excel file data is not display.

Kalyani Shevale · Answer

for Amit Kumar worKbooK.Close(); string contentType = "application/excel" ; string path = System.Web.Configuration.WebConfigurationManager.AppSettings[ "ExcelPath" ].ToString() + "\SurveyReport.xlsx" ; worKbooK.SaveAs(path); excel.Quit(); return File(path, contentType, "Download" + "surveyExcel.xlsx" ); Error occured on this code {"The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))"}

Kalyani Shevale · Answer

xml version = "1.0" encoding = "utf-8" ?> For more information on how to configure your ASP.NET application, please visit http://go.microsoft.com/fwlink/? LinkId = 301880 -- > configuration > configSections > section name = "entityFramework" type = "System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission = "false" /> configSections > connectionStrings > add name = "CMSEntities" connectionString = "Data Source=192.168.1.117;Initial Catalog=vecino;User ID=sa;Password=mipl@123" providerName = "System.Data.SqlClient" /> connectionStrings > appSettings > add key = "myFilePath" value = "D:\Kalyani Work\VIcino\DailyExcelFileUploadCode\WebApp\Images\" /> add key = "ExcelPath" value = "D:\Kalyani Work\VIcino\DailyExcelFileUploadCode\WebApp\Excel\" /> add key = "FileUploadPath" value = "C:/Users/COM-C/Source/Workspaces/InhouseDailyExpenseExcelProject/DailyExcelFileUploadCode/WebApp/UploadedFiles/" /> add key = "webpages:Version" value = "3.0.0.0" /> add key = "webpages:Enabled" value = "false" /> add key = "ClientValidationEnabled" value = "true" /> add key = "UnobtrusiveJavaScriptEnabled" value = "true" /> appSettings > system.web > compilation debug = "true" targetFramework = "4.5" /> httpRuntime targetFramework = "4.5" /> httpModules > add name = "ApplicationInsightsWebTracking" type = "Microsoft.ApplicationInsights.Web.ApplicationInsightsHttpModule, Microsoft.AI.Web" /> httpModules > system.web > runtime > assemblyBinding xmlns = "urn:schemas-microsoft-com:asm.v1" > dependentAssembly > assemblyIdentity name = "Newtonsoft.Json" culture = "neutral" publicKeyToken = "30ad4fe6b2a6aeed" /> bindingRedirect oldVersion = "0.0.0.0-6.0.0.0" newVersion = "6.0.0.0" /> dependentAssembly > dependentAssembly > assemblyIdentity name = "System.Web.Optimization" publicKeyToken = "31bf3856ad364e35" /> bindingRedirect oldVersion = "1.0.0.0-1.1.0.0" newVersion = "1.1.0.0" /> dependentAssembly > dependentAssembly > assemblyIdentity name = "WebGrease" publicKeyToken = "31bf3856ad364e35" /> bindingRedirect oldVersion = "0.0.0.0-1.5.2.14234" newVersion = "1.5.2.14234" /> dependentAssembly > dependentAssembly > assemblyIdentity name = "System.Web.Helpers" publicKeyToken = "31bf3856ad364e35" /> bindingRedirect oldVersion = "1.0.0.0-3.0.0.0" newVersion = "3.0.0.0" /> dependentAssembly > dependentAssembly > assemblyIdentity name = "System.Web.WebPages" publicKeyToken = "31bf3856ad364e35" /> bindingRedirect oldVersion = "1.0.0.0-3.0.0.0" newVersion = "3.0.0.0" /> dependentAssembly > dependentAssembly > assemblyIdentity name = "System.Web.Mvc" publicKeyToken = "31bf3856ad364e35" /> bindingRedirect oldVersion = "1.0.0.0-5.2.3.0" newVersion = "5.2.3.0" /> dependentAssembly > dependentAssembly > assemblyIdentity name = "DocumentFormat.OpenXml" publicKeyToken = "8fb06cb64d019a17" culture = "neutral" /> bindingRedirect oldVersion = "0.0.0.0-2.8.0.0" newVersion = "2.8.0.0" /> dependentAssembly > assemblyBinding > runtime > system.codedom > compilers > compiler language = "c#;cs;csharp" extension = ".cs" type = "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel = "4" compilerOptions = "/langversion:6 /nowarn:1659;1699;1701" /> compiler language = "vb;vbs;visualbasic;vbscript" extension = ".vb" type = "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel = "4" compilerOptions ="/langversion:14 /nowarn:41008 /define:_MYTYPE=\" Web \" /optionInfer+" /> compilers > system.codedom > system.webServer > validation validateIntegratedModeConfiguration = "false" /> modules > remove name = "ApplicationInsightsWebTracking" /> add name = "ApplicationInsightsWebTracking" type = "Microsoft.ApplicationInsights.Web.ApplicationInsightsHttpModule, Microsoft.AI.Web" preCondition = "managedHandler" /> modules > system.webServer > entityFramework > defaultConnectionFactory type = "System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" /> providers > provider invariantName = "System.Data.SqlClient" type = "System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /> providers > entityFramework > configuration >

Amit Kumar · Answer

last few line change your code becaue you create excel wrookbook and bind data but you did not save this workbook in your local system with respected directory so it is not diownlaod. worKbooK.Close(); string contentType = "application/excel" ; string path = System.Web.Configuration.WebConfigurationManager.AppSettings[ "ExcelPath" ].ToString() + "\SurveyReport.xlsx" ; worKbooK.SaveAs(path); excel.Quit(); return File(path, contentType, "Download" + "surveyExcel.xlsx" );

Amit Kumar · Answer

Please share web.config also. and change your code string path = System.Web.Configuration.WebConfigurationManager.AppSettings["ExcelPath"].ToString() + "//SurveyReport.xlsx";

Kalyani Shevale · Answer

Microsoft.Office.Interop.Excel.Application excel; Microsoft.Office.Interop.Excel.Workbook worKbooK; Microsoft.Office.Interop.Excel.Worksheet worKsheeT; Microsoft.Office.Interop.Excel.Range celLrangE; excel = new Microsoft.Office.Interop.Excel.Application(); excel.Visible = false ; excel.DisplayAlerts = false ; worKbooK = excel.Workbooks.Add(Type.Missing); worKsheeT = (Microsoft.Office.Interop.Excel.Worksheet)worKbooK.ActiveSheet; var Question = new BussinessLogic.Admin.UserSurvey( new UserSurveyRepository( new CRMContext())).GetAllUserSurvey().Where(m => m.SurveyId == 9); worKsheeT.Name = "Admission Data" ; int i = 1; int j = 1; int kk = 2; var eachSurvey = new BussinessLogic.Answer.Answer( new AnswerRepository( new CRMContext())).GetAllAnswer().Where(a=>a.SurveyId==SurveyId).Select(a => a.EachSurveyUniqueNo).Distinct(); int cou = eachSurvey.Count(); #region foreach (var q in Question) { var QuestionRow = new BussinessLogic.Admin.QuestionAnswer( new QuestionAnswerRepository( new CRMContext())).GetAllQuestionAnswer().Where(k => k.QuestionId == q.Id && k.ColumnOption == null ); if (q.QuestionTypeId == 1) { worKsheeT.Cells[1, i] = q.QuestionText; kk = 2; var eachSurvey1 = new BussinessLogic.Answer.Answer( new AnswerRepository( new CRMContext())).GetAllAnswer().Where(a => a.SurveyId == SurveyId).Select(a => a.EachSurveyUniqueNo).Distinct(); foreach (var sam in eachSurvey1) { var ans = new BussinessLogic.Answer.Answer( new AnswerRepository( new CRMContext())).GetAllAnswer().Where(m => m.QuestionId == q.Id && m.EachSurveyUniqueNo == sam).ToList(); if (ans.Count() != 0) { foreach (var an in ans) { var Ques = new BussinessLogic.Admin.QuestionAnswer( new QuestionAnswerRepository( new CRMContext())).GetAllQuestionAnswer().Where(k => k.Id == an.SelectedAnswerOptionId).FirstOrDefault(); worKsheeT.Cells[kk, i] = Ques.AnswerOption; kk++; } } else { worKsheeT.Cells[kk, i] = "NA" ; kk++; } } i++; } if (q.QuestionTypeId == 2) { var Ques = new BussinessLogic.Admin.QuestionAnswer( new QuestionAnswerRepository( new CRMContext())).GetAllQuestionAnswer().Where(k => k.QuestionId == q.Id).ToList(); foreach (var anss in Ques) { kk = 2; worKsheeT.Cells[1, i] = q.QuestionText + ": " + anss.AnswerOption; var eachSurvey1 = new BussinessLogic.Answer.Answer( new AnswerRepository( new CRMContext())).GetAllAnswer().Where(a => a.SurveyId == SurveyId).Select(a => a.EachSurveyUniqueNo).Distinct(); foreach (var sam in eachSurvey1) { var ans1 = new BussinessLogic.Answer.Answer( new AnswerRepository( new CRMContext())).GetAllAnswer().Where(m => m.QuestionId == q.Id && m.SelectedAnswerOptionId == anss.Id && m.EachSurveyUniqueNo == sam).ToList(); int len = ans1.Count(); if (len == 0) { worKsheeT.Cells[kk, i] = "NA" ; kk++; } else if (len == 1) { foreach (var b in ans1) { var Quesoption = new BussinessLogic.Admin.QuestionAnswer( new QuestionAnswerRepository( new CRMContext())).GetAllQuestionAnswer().Where(k => k.Id == b.SelectedAnswerOptionId).FirstOrDefault(); worKsheeT.Cells[kk, i] = Quesoption.AnswerOption; kk++; } } else { foreach (var b in ans1) { var Quesoption = new BussinessLogic.Admin.QuestionAnswer( new QuestionAnswerRepository( new CRMContext())).GetAllQuestionAnswer().Where(k => k.Id == b.SelectedAnswerOptionId).FirstOrDefault(); worKsheeT.Cells[kk, i] = Quesoption.AnswerOption; kk++; } } } i++; j++; } } } #endregion celLrangE = worKsheeT.Range[worKsheeT.Cells[1, 1], worKsheeT.Cells[1, 150]]; celLrangE.EntireColumn.AutoFit(); Microsoft.Office.Interop.Excel.Borders border = celLrangE.Borders; border.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous; border.Weight = 2d; celLrangE = worKsheeT.Range[worKsheeT.Cells[1, 1], worKsheeT.Cells[2, 150]]; worKbooK.Close(); excel.Quit(); string contentType = "application/excel" ; string path = System.Web.Configuration.WebConfigurationManager.AppSettings[ "ExcelPath" ].ToString() + "SurveyReport.xlsx" ; return File(path, contentType, "Download" + "surveyExcel.xlsx" );

Amit Kumar · Answer

Hi Please share your code.

Piyush Pansuriya · Answer

Hi, Please share your downloading file code. Problem is not in web.config.