How to remove multiple columns from an excel datatable?

[aksh1yadav (AKSHAY YADAV)]

@Snowman

as I have too many columns to remove ?

Instead of that i would prefer to use Dataview.

For more information look into this thread:

How to get data table with selected columns from excel sheet

well you can use excql as a data source and use queries but i have one more way to do this here for example purpose it will show only two columns data i.e. Date and Close Column Datatable Results_of_two_cols = Yourdatatable.Select().CopyToDataTable().DefaultView.ToTable(False, “Date”, “Close”) Note - If you wants rows that have distinct values for all its columns then just set DefaultView.ToTable(True, “Date”, “Close”) Regards…!! Aksh

How to get data table with selected columns from excel sheet

For your Reference @abskulkarni - sample_for_kulkarni.zip (3.3 KB) This will write the new datatable to an output.xlsx file in the same directory. Regards…!! Aksh

Regards…!!
Aksh