How to get particular column

How to get specific column in the data and write that in another excel sheet
what is the logic used.

@anjani_priya

finaldt=dt.defaultview.totable(false,"ColumnName")
1 Like

Hi @anjani_priya
Dt_TableData is the datatable you which you get in Read Range workbook

final_dt= Dt_TableData.DefaultView.ToTable(False,"column names")

Hope it helps!!

I have another doubt
I have a excel file from sap and I want to extract the column from that excel file
who to set the excel file dynamically

@anjani_priya

try this

in assign

 final_data_table  = dataTable.DefaultView.ToTable(False, "ColumnName")

cheerss…!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.