Mvc download excel file

Cells[1, 2]. Cells[1, 3]. Cells[1, 4]. Cells[1, 5]. Cells[1, 6]. Cells[recordIndex, 1]. ToString ; workSheet. Cells[recordIndex, 2]. EmpNo; workSheet. Cells[recordIndex, 3]. Name; workSheet. Cells[recordIndex, 4]. JoinedDate; workSheet. Cells[recordIndex, 5]. Designation; workSheet. Cells[recordIndex, 6]. Email; workSheet. Cells[recordIndex, 7]. Column 1. AutoFit ; workSheet. Column 2. Column 3. Column 4. Sometimes, it is required to export your data into the Excel file in the Web Application.

In this demonstration, I will show you the data on the Application and on the button click, we will export the data into Excel file and download it on our local system. Create ASP. NET Web Application. It will give you another dialog Window, where you can choose the type of the ASP. Hence, we are going to get the data from the database. Add some entity classes and database access class. AGuyCalledGerald 7, 16 16 gold badges 67 67 silver badges bronze badges.

Luchian Luchian 2 2 silver badges 3 3 bronze badges. How exactly would you do that? Sounds interesting. An example would be nice i mean how to store it in the cache, not generating the excel file.

How scalable is this though? If a user is downloading several large reports? SaveXlsx stream ; stream. Andy S Andy S 1 1 silver badge 2 2 bronze badges.

I had a similar approach. WriteDataTableToExcel dt, ". Create, FileAccess. Write ; exportData. WriteTo file ; file. Result as FilePathResult. Elvin Acevedo Elvin Acevedo 99 1 1 silver badge 6 6 bronze badges.

Chris Andrews 33 6 6 bronze badges. Niclas Niclas 3 3 silver badges 9 9 bronze badges. Nichlas I had started using TempData also, your answer prompted me to update mine to reflect this! SerializeObject dbcontext. DeserializeObject Emplist, typeof DataTable ; dt RAO G. RAO 91 1 1 silver badge 3 3 bronze badges. ToArray , System. Octet, "TeamMembers. Set handle, memoryStream. SetSlidingExpiration TimeSpan. Now there is some extra code for setting up MemoryCache Memory; namespace MySolution.

AddDistributedMemoryCache ;. NewGuid ; HttpContext. Insert guid. ToString , input, null, DateTime. AddMinutes 5 , Cache. NoSlidingExpiration ; return guid. ToString ]; Machinegon Machinegon 1, 1 1 gold badge 26 26 silver badges 43 43 bronze badges. Raw Url. URL window. I may sound quite naive, and may attract quite a criticism, but here's how I did it, It doesn't involve ajax for export, but it doesn't do a full postback either Thanks for this post and this answer.

Add "Sheet1" ; ws. SaveAs memoryStream ; return File memoryStream. That can be done while 'searching' the data.. Irf Irf 3, 2 2 gold badges 33 33 silver badges 47 47 bronze badges.

That's my problem. WriteXls filePath, "Text. Response; response.