Converting a file in c.sv format to excel

Question

Hello I am looking for an application that can convert a file in csv format to excel

Ramesh Maruthi · Answer

Hi Samuel You can go with the Microsoft.Office.Interop.Excel assembly. Just reference it in your project and you can use it to manipulate Excel documents in any way you want. Here's a very simple example of how to open a txt file and save it to Excel. You can enhance it to open a csv file by paying attention to the .Workbooks.OpenText() procedure. I haven't had the chance to test this but let me know if it helped you out. //Open the .txt file in excel as a csv and save it as an excel document Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.ApplicationClass(); try { Microsoft.Office.Interop.Excel.Workbook wb; Object mv = System.Reflection.Missing.Value;//Represents the null parameters xl.Workbooks.OpenText(Server.MapPath(~/Uploads/ + strRandomName + .txt) mv 1 Microsoft.Office.Interop.Excel.XlTextParsingType.xlDelimited Microsoft.Office.Interop.Excel.XlTextQualifier.xlTextQualifierDoubleQuote mv mv mv true mv mv mv mv mv mv mv mv mv);//Open the excel sheet wb = xl.Workbooks[1];//Get the only workbook that was just created by the OpenText command wb.SaveAs(Server.MapPath(~/Uploads/ + strRandomName + .xls) Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel5 mv mv mv mv Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange Microsoft.Office.Interop.Excel.XlSaveConflictResolution.xlLocalSessionChanges mv mv mv mv);//Save as an EXCEL file wb.Close(false false false);//This is done to avoid the message Do you want to save the changes to myfile.xls? Microsoft Office Excel recalculates formulas when opening files last saved by an earlier version of Excel even though the file was opened in readonly mode and no changes happened. } catch (Exception ex) { //Do what you have to do with the exception } finally { xl.Quit(); } c this link : https://www.linkedin.com/groups/How-can-i-convert-csv-40949.S.129008529 Hope this helps you :)