How can I get value from column header as below. Thank all
Column A Dynamic Column DC DC DC DC
ITEM No. (MM),(OD X MM) - (PC),(PCS),(PCS.) - (KGS),(MT) - (USD/PCS) - AMOUNT
I want to get all values under desired header columns. That columns dynamic so some name not changes
Col A - - - - - - - Dynamic Column
ex: ITEM No. - (MM),(OD X MM) - (PC),(PCS),(PCS.) - (KGS),(MT) - (USD/PCS) - AMOUNT
put all the column headers you want in a list e.g. filterList (this can be a dynamic list)
e.g. {“item no.”, “discription of goods (mm)”, “quantity(pc)”…}
read datatable from excel e.g. to variable called dt
assign New DataView(dt) to a dataview variable
assign dataView.ToTable(false, filterList.ToArray) to filteredTable variable
now your filteredTable variable will be a table with only columns you want!