Excel and C#

Question

Hello I al working on a project with Excel and .NET. I have a Excel file with in column A some text like 123,lala,456 I want to split this text as follows : in column B the value 123 in column C the value lala and in column D the value 456. This can be done with the TextToColumns but I cannot get it working. This is what I tried Excel.Application excelApp; excelApp = new Excel.Application(); excelApp.Visible = true; Excel.Workbook wb; wb = excelApp.Workbooks.Open(file,Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing); Excel.Range xls = (Excel.Range)((Excel.Worksheet)excelApp.ActiveWorkbook.Sheets[1]).get_Range("B1","D1"); Excel.Range csv = (Excel.Range)((Excel.Worksheet)excelApp.ActiveWorkbook.Sheets[1]).get_Range("A1","A40"); csv.TextToColumns(xls,Excel.XlTextParsingType.xlDelimited,Excel.XlTextQualifier.xlTextQualifierDoubleQuote,false,false,false,true,false,false,false,false,false,Type.Missing,Type.Missing); What am I doing wrong??? please help me !! Thanks a lot !!!!! Bye bye ;)