How to Import/Download csv file in Jquery datatable

Question

Dear Developers, I am creating an application , in that i have to download jquery datatable as csv file. Now am downloading as pdf file using the below code on GenericReportController.cs C# Code public FileResult ExportCsv( string viewdataName, string fileName) { var data = "" ; data = TempData[viewdataName].ToString(); TempData[viewdataName] = data; var dt = (DataTable) JsonConvert.DeserializeObject(data, ( typeof (DataTable))); if (dt.Rows.Count > 0) { dt.TableName = fileName.Replace( '/' , '_' ); using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dt); using (MemoryStream stream = new MemoryStream()) { wb.SaveAs(stream); return File(stream.ToArray(), "application/octet-stream" , fileName + ".csv" ); } } } else return null ; } How can I download to CSV file, kindly suggest me to I am done this task. Regards Paul.S

Sachin Singh · Answer

as you are downliding pdf, the same can be done for CSV , pass the C# datatable obj which contains data and path where you want to save csv in below code. public static void ToCSV( DataTable dtDataTable, string strFilePath) { StreamWriter sw = new StreamWriter(strFilePath, false ); //headers for ( int i = 0; i sw.Write(dtDataTable.Columns[i]); if (i sw.Write( "," ); } } sw.Write(sw.NewLine); foreach(DataRow dr in dtDataTable.Rows) { for ( int i = 0; i if (!Convert.IsDBNull(dr[i])) { string value = dr[i].ToString(); if (value.Contains( ',' )) { value = String.Format( "\"{0}\"" , value); sw.Write(value); } else { sw.Write(dr[i].ToString()); } } if (i sw.Write( "," ); } } sw.Write(sw.NewLine); } sw.Close(); }