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.

piya senPosted Sep 30, 2015, 11:44 PM
Ashish SinghalPosted Sep 30, 2015, 6:45 AM
https://social.msdn.microsoft.com/Forums/en-US/791abf22-d16a-44af-9e9d-4dfafbeb1694/how-to-add-multiple-csv-files-to-one-exel-workbook-in-vbnet?forum=vbinterop