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.

1 Like

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

1 Like

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
Dt=Dt.select(“[department]=‘d2’”). copy ToDataTable

Regards
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.

image

image

image

1 Like

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

1 Like

Yes I solve it Thank you !!!

1 Like

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

1 Like

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