Imorting .csv into excel
Hi i want to import a csv file into excel . the file is imported but it does not put the comma separated values in different columns . Any help would b appreciated :) heres my code
Excel.Application xlAppl;
Excel._Workbook xlWB;
Excel._Worksheet xlSheet;
Excel.Range oRng;
xlAppl = new Excel.Application();
xlAppl.Visible = true;
xlWB = (Excel._Workbook)(xlAppl.Workbooks.Add(Missing));
xlSheet = (Excel._Worksheet)xlWB.ActiveSheet;
//Add table headers going cell by cell.
xlAppl.Workbooks.Open(@"d:\csvtest.csv",false,fals e,5,"","",true,Excel.XlPlatform.xlWindows," ",true,false,null,false,null,false);
|