How to convert Data table into this csv format

Question

I want to convert my data table into this csv format.Please help me if anyone have idea how to do that

Hamid Khan · Answer

Hi Aman https://www.codeproject.com/Tips/665519/Writing-a-DataTable-to-a-CSV-File Or with the help of extenstion method you can use this that will be reusable as well: myTable.ConvertToCsvFile( "D:\MyTable.csv" ); public static class DataTableExtensionsClass { public static void ConvertToCsvFile( this DataTable dataTable, string filePath) { StringBuilder fileContent = new StringBuilder(); foreach (var col in dataTable.Columns) { fileContent.Append(col.ToString() + "," ); } fileContent.Replace( "," , System.Environment.NewLine, fileContent.Length - 1, 1); foreach (DataRow dr in dataTable.Rows) { foreach (var column in dr.ItemArray) { fileContent.Append( """ + column.ToString() + ""," ); } fileContent.Replace( "," , System.Environment.NewLine, fileContent.Length - 1, 1); } System.IO.File.WriteAllText(filePath, fileContent.ToString()); } }

Leon D · Answer

You can install Free Spire.XLS API via nuget and use the below code to simply convert data table to csv. //export datatable to excel Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; sheet.InsertDataTable(datatable, true , 1, 1); //save as csv file sheet.SaveToFile( "sample.csv" , "," , Encoding.UTF8);

Nisha Regil · Answer

Please refer to link https://stackoverflow.com/questions/4959722/c-sharp-datatable-to-csv One article from C# corner itself https://www.c-sharpcorner.com/UploadFile/deveshomar/export-datatable-to-csv-using-extension-method/

How to convert Data table into this csv format

Answers (3)