Quick Export to Excel using c#
Export Records in Excel Very Quickly. Step 1: Add Package of EPPlus https://www.nuget.org/packages/EPPlus/ dotnet add package EPPlus --version 6.1.3 ================================================================== Step 2: Implementation on .cs page. using OfficeOpenXml; namespace ExportExcel { private async void Export() { // Collect data from database and store in DataTable object System.Data.DataTable dt = await GetDataToExport(); using (var package = new ExcelPackage()) { // Add a new worksheet to the package var worksheet = package.Workbook.Worksheets.Add("Sheet1"); for (int i = 0; i < dt.Rows.Count; i++) { await Task.Run(() =>...