Generate large XLSX / CSV file in MVC for min 1 Lac records

Question

I would like to generate large XLSX and CSV file in MVC as given on below URL

http://demos.telerik.com/aspnet-mvc/spreadstreamprocessing

I am unable to download Model and Class File above example.

1) using Telerik.Documents.SpreadsheetStreaming;
2) using Kendo.Mvc.Examples.Models.SpreadStreamProcessing;
3) DocumentSettings class

Please help me to resolve this issue.

Thanks in adv.

Sandy · Answer

I used EPPlus.dll for creating Excel file with more than one lakh records and it is very good library for creating formatted excel in c# MVC. i just read all records to data table and after that create excel using datatable.Use this code to create excel file and render to the browser. using (ExcelPackage package = new ExcelPackage()) { using (SqlConnection con = new SqlConnection(connection)) { using (SqlCommand cmd = new SqlCommand(select * from TableName con)) { using (SqlDataAdapter adap = new SqlDataAdapter(cmd)) { DataSet ds = new DataSet(); adap.Fill(ds); ExcelWorksheet ws = package.Workbook.Worksheets.Add(Accounts); ws.Cells[A1].LoadFromDataTable(ds.Tables[0] true); package.Compression = CompressionLevel.BestSpeed; package.SaveAs(response.OutputStream); } } } } Let me know if you have any issue while creating or downloading the file.