I have 3 csv files and want to import all data respectively to an excel with data transferred to 3 sheets(sheet1,sheet2,sheet3) in a single workbook using c#.net.Any help is appreciated. Excel.Application xl=new Excel.Application; Excel.Workbook wb=new Excel.Workbook; Excel.Worksheet ws1=new Excel.worksheet; Excel.Worksheet ws2=new Excel.worksheet; Excel.Worksheet ws3=new Excel.worksheet; string csv1=@"c:\SS1.csv"; string csv2=@"c:\SS2.csv"; string csv3=@"c:\SS3.csv"; wb=xl.Workbooks.Open(csv1);
I'm stuck here.How do i access the other 2 csv files.