I have an excel having more than 50 Columns out of which I need only 3 Columns “C”,“F” and “AG”. And paste that in new Datatable.
Read C,F and AG column separately using Read column activity and paste in a new data table.
I am stuck here. I unable to paste columns in new Datatable…Cause the output of Read column is Ienumerable . I am unable to convert it into datatable
Other way is to read the data table and loop over all columns but that is not proper way I feel cause my excel size is very big.