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…