I wanted to know an easy way to insert data from a Data table into an excel work sheet which already has a couple of columns populated.
What I mean by this is say suppose I have an excel file and in WorkSheet 1 there are already two columns populated.
Now I would like to use this data table and which say has 7 columns and insert into worksheet 1 in such a way that I dont delete the first 2 columns.
So the finally the Worksheet1 will have 2 ( Already exisiting coulms ) + the 7 new columns from the data table.
Also I would like to insert the Data table column names into excel as its column names ..
Any help would be greatly appreciated.