Convert csv file into excel

Question

Hi how to convert csv file into excel in c#. Thanks allot Darma

Constance Swinton · Answer

Hi there are actually a lot of ways you can achieve this you can use an excel automation codes to manipulate with MS Excel you can use OLEDB to create a new Excel file based on the CSV data. Also if you require an XLSX format only then you can use an OpenXML SDK. And also there are third party members as mentioned here that can achieve this with ease. For example I use this C# component for my excel tasks  here is the all the code needed to achieve the conversion of CSV file to an XLS format in C# : ExcelFile .Load( Input.csv ).Save( Output.xls ); I would say it is straightforward as much as it can be

Michael Steward · Answer

Try out this csv to xls/xlsx converter . It supports many other formats.

Lacy Michelle · Answer

You can get this by downloading it in the Bin Folder: http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

darma teja · Answer

Hi Thanks allot for the replies. Actually all your solution works with only Spier.xls dll. I did not get this dll in google. Where Can i find it. Thanks Darma

Timothy Foster · Answer

You can easily convert csv files into xls or xlsx with C# Excel Writer . Look at this C# example: ExcelWorkbook Wbook = ExcelWorkbook.ReadCSV(@..\input.csv); // For xls Wbook.WriteXLS(@..\output.xls); // For xlsx Wbook.WriteXLSX(@..\output.xlsx);

White Evaln · Answer

see code below: Workbook workbook = new Workbook(); workbook.LoadFromFile(@D:\michelle\my file\csv2xls.csv  1 1); Worksheet sheet = workbook.Worksheets[0]; workbook.SaveToFile(result.xls ExcelVersion.Version97to2003); sheet.Name = csv to excel; Details can be seen : Convert CSV to Excel with C#

Dorababu Meka · Answer

check here http://www.dotnetfunda.com/Blogs/Lacy/2532/easy-way-to-save-excel-file-as-csv-with-csharp-vbnet