How can I export data in excel file in C# project?

Question

In a 'demo.cshtml' page of my C# MVC project, I'm displaying a list of users. I would like to export this data to an Excel file. Could someone assist me with this?

Amit Mohanty · Answer

You can use the EPPlus library to easily export data to an Excel file. In your controller, create a method to generate the Excel file. This method will take the list of users as input and create an Excel file containing the user data. using OfficeOpenXml; using System.IO; using System.Web.Mvc; public class UserController : Controller { public ActionResult ExportToExcel() { // Get the list of users from your data source List users = GetUsersFromDataSource(); ExcelPackage excelPackage = new ExcelPackage(); ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Users"); worksheet.Cells[1, 1].Value = "Name"; worksheet.Cells[1, 2].Value = "Email"; int row = 2; foreach (var user in users) { worksheet.Cells[row, 1].Value = user.Name; worksheet.Cells[row, 2].Value = user.Email; row++; } Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment; filename=Users.xlsx"); Response.BinaryWrite(excelPackage.GetAsByteArray()); Response.End(); return new EmptyResult(); } // Method to get users from your data source private List GetUsersFromDataSource() { return new List { new User { Name = "Abc", Email = "abc@example.com" }, new User { Name = "Xyz", Email = "xyz@example.com" } }; } } Now add a button or link to trigger the export action. For example: Export to Excel

Jignesh Kumar · Answer

Hello Rinki, Please refer to this article, https://www.c-sharpcorner.com/article/export-data-in-excel-pdf-csv-word-json-xml-and-text-file-in-mvc-application/ https://www.c-sharpcorner.com/article/export-data-excel-in-asp-net-mvc/ https://www.c-sharpcorner.com/article/excel-export-in-mvc-net2/

Darshan Adakane · Answer

You can achieve this in two parts : Make a function in your MVC controller that makes the Excel file. Put a button or link on your 'demo.cshtml' page to start the export. Part 1 : using System.Collections.Generic; using System.Web.Mvc; using OfficeOpenXml; using System.IO; using YourNamespace.Models; // Import your user model namespace public class UserController : Controller { // Action method to export users to Excel public FileResult ExportUsersToExcel() { // Get list of users List users = GetUserList(); // Create Excel file using (ExcelPackage excelPackage = new ExcelPackage()) { // Add a worksheet ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Users"); // Set column headers worksheet.Cells[1, 1].Value = "Name"; worksheet.Cells[1, 2].Value = "Email"; // Populate data int row = 2; foreach (var user in users) { worksheet.Cells[row, 1].Value = user.Name; worksheet.Cells[row, 2].Value = user.Email; row++; } // Save Excel file to memory stream MemoryStream stream = new MemoryStream(); excelPackage.SaveAs(stream); // Set content type and file name string fileName = "Users.xlsx"; string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; // Return Excel file as FileResult return File(stream.ToArray(), contentType, fileName); } } // Sample method to retrieve list of users (Replace with actual logic) private List GetUserList() { // Example: hardcoded list of users return new List { new User { Name = "John Doe", Email = "john@example.com" }, new User { Name = "Alice Smith", Email = "alice@example.com" }, new User { Name = "Bob Johnson", Email = "bob@example.com" } }; } } Part 2: @Html.ActionLink("Export to Excel", "ExportUsersToExcel", "Demo") Hope this works. Thanks.

Ishika Tiwari · Answer

Hello Rinky, Please go through this. I hope you will get your answer. https://www.c-sharpcorner.com/article/how-to-export-html-table-in-excel-using-jquery/

Jaimin Shethiya · Answer

Hello Rinki, Please refer below link. https://docs.closedxml.io/en/latest/ https://github.com/ClosedXML/ClosedXML https://www.c-sharpcorner.com/article/excel-sheet-closed-xml-mvc5/ Thanks

Jayraj Chhaya · Answer

Hi Rinki, To export data to an Excel file in a C# MVC project, you can use the EPPlus library, which simplifies Excel generation. First, install the EPPlus NuGet package in your project. Then, you can create an Excel package, add a worksheet, and populate it with your data. using OfficeOpenXml; using System.IO; public void ExportToExcel(List users) { using (ExcelPackage excelPackage = new ExcelPackage()) { ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Users"); worksheet.Cells["A1"].LoadFromCollection(users, true); FileInfo excelFile = new FileInfo("Users.xlsx"); excelPackage.SaveAs(excelFile); } } ExportToExcel method takes a list of users and generates an Excel file named "Users.xlsx" with the user data. You can call this method from your controller to export the data.