C# - I want to convert a csv file to xlsx format on a server

Question

C# - I want to convert a csv file to xlsx format on a server where office is not installed. Dont know the work sheet name and data of csv

alice yang · Answer

Hi Refer below link to convert csv to xlsx without installing office: http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/CSV-to-Excel-Convert-CSV-to-Excel-with-C-VB.NET.html

Kamal K · Answer

if ( File .Exists( Util .XLSXFileName)) { 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); //Delete Evaluation Warning using EPPlus var workbookFileInfo = new FileInfo ( Util .XLSXFileName); using ( var excelPackage = new ExcelPackage (workbookFileInfo)) { var worksheet = excelPackage.Workbook.Worksheets.SingleOrDefault(x => x.Name == Evaluation Warning ); excelPackage.Workbook.Worksheets.Delete(worksheet); excelPackage.Save(); }

Lokesh Kumar · Answer

Hi Friend You can easily convert csv files into xls or xlsx with C# Excel Writer . Please follow C# example: ExcelWorkbook wrkBook = ExcelWorkbook.ReadCSV(@..\input.csv); // For (Excel 97/2003) xls wrkBook .WriteXLS(@..\output.xls); // For (Excel 2007) xlsx wrkBook .WriteXLSX(@..\output.xlsx);

Dhananjay Kumar · Answer

http://www.codeproject.com/Articles/246772/Convert-xlsx-xls-to-csv