CSV to Excel
Use IronXL to quickly convert comma separated values text files (.csv) into Excel worksheets.
Shows how to import CSV and "tab separated values" TSV data into Excel WorkSheets in C#.using IronXL;
//This is how we can load csv file and convert it to .xls or .xlsx workbook
//Also we can specify the column list delimiter
WorkBook workbook = WorkBook.LoadCSV("test.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");
WorkSheet ws = workbook.DefaultWorkSheet;
workbook.SaveAs("CsvToExcelConversion.xlsx");
Imports IronXL
'This is how we can load csv file and convert it to .xls or .xlsx workbook
'Also we can specify the column list delimiter
Private workbook As WorkBook = WorkBook.LoadCSV("test.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")
Private ws As WorkSheet = workbook.DefaultWorkSheet
workbook.SaveAs("CsvToExcelConversion.xlsx")
