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

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.

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sandy9y ago
Accepted 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.
0