How to copy only specific Columns from excel contains keywords

Hi Team,
How to copy only specific Columns from excel contains keywords(EL or DAG or DBF or is or Mandatory).
When i convert text file to excel file,the no of columns are different because of text file contains different data every time.
So as per the excel I want to copy the columns contains specific key words .Sequence12.xaml (9.3 KB) Excel Validation (2).zip (10.2 KB)

we can use this method
yourdatatable = yourdatatable.DefaultView.ToTable(False,“Columnname1”,“Collumnname2”).CopyToDatatable()
if we know the columns we want…

Cheers @RajeshT

1 Like

Output.xlsx (7.3 KB) GetRequiredColumns.xaml (19.3 KB)

I have tried to replicate your scenario. Please have a look.

Thanks!