Thanks for sharing, It’s very informative and to the point. I came across another API by the name of Aspose.Cells which is also considered good with CSV & XLS/XLSX reading and conversion. Could you please share some code for this API and also you thoughts?
{
File.Delete(Util.XLSXFileName);
}
//Save as xlsx using Spire
Workbook workbook = new Workbook();
workbook.LoadFromFile(Util.CSVFileName, ",", 1, 1);
Worksheet sheet = workbook.Worksheets[0];
sheet.Name = "csv to excel";
workbook.SaveToFile(Util.XLSXFileName, ExcelVersion.Version2010);