Select the row in Excel


Hello Every community friends.
I come to ask question again.
in this sheet:%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE(9)
I only want get the D2 department’s salary or I just want konw the D2 department’s salary and ID in this sheet.
What activity I can use.
Please help me.
Thank you for your help.


IF you have any confusion in my question, please let me know. My english is not so good. thank you.


You can use Read Range to read your excel sheet into a data table and then use Filter data table activity to filter your rows with department as D2


Hi @chenzhixing.prc,

You can filter the datatable in the assign activity as below"[department]=‘d2’"). copy ToDataTable

Sanjay shankhla


Hi @Chenzhixing.PRC,

  • Use Read Range Activity within Excel application scope.
  • Use Filter Datatable activity to filter.
  • Use Write Range activity within Excel application scope to write the filtered table.





Everytime I get a question and you always help my very soon.
Very appreciate.
Thank you.


Yes I solve it Thank you !!!


I solve it now thank you for your help !!!


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