Convert CSV to Excel or XLSX/XLS to CSV with C# VB.NET

readme.md

You can read all details at: Convert CSV to Excel Files or Excel to CSV using C# VB.NET

CSVtoExcel.cs

// Create LoadOptions for CSV file
LoadOptions loadOptions = new LoadOptions(LoadFormat.CSV);

// Create a Workbook object and initialize with CSV file's path and the LoadOptions object
Workbook workbook = new Workbook("Sample.csv", loadOptions);

// Save CSV file as XLSX
workbook.Save("CSVtoExcel.xlsx", SaveFormat.Xlsx);

ExcelToCSV.cs

// Load the input Excel file
Workbook workbook = new Workbook("CSVtoExcel.xlsx");

// Save XLSX as CSV file
workbook.Save("ExcelToCSV.csv", SaveFormat.CSV);