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

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

Answers (4)