How to Import/Download csv file in Jquery datatable

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

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 < dtDataTable.Columns.Count; i++) {
sw.Write(dtDataTable.Columns[i]);
if (i < dtDataTable.Columns.Count - 1) {
sw.Write(",");
}
}
sw.Write(sw.NewLine);
foreach(DataRow dr in dtDataTable.Rows) {
for (int i = 0; i < dtDataTable.Columns.Count; 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 < dtDataTable.Columns.Count - 1) {
sw.Write(",");
}
}
sw.Write(sw.NewLine);
}
sw.Close();
}

1 Reply

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

Sachin Singh5y ago
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 < dtDataTable.Columns.Count; i++) {
        sw.Write(dtDataTable.Columns[i]);
        if (i < dtDataTable.Columns.Count - 1) {
            sw.Write(",");
        }
    }
    sw.Write(sw.NewLine);
    foreach(DataRow dr in dtDataTable.Rows) {
        for (int i = 0; i < dtDataTable.Columns.Count; 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 < dtDataTable.Columns.Count - 1) {
                sw.Write(",");
            }
        }
        sw.Write(sw.NewLine);
    }
    sw.Close();
}