Hi, I have a problem: I have an Excel table in which the columns date (column A as “dd/mm/yyyy”) and status (column D) are listed. I would now like to build a function that first checks whether today’s date combined with the status “Order executed” is already in the file. If yes, the function shoul…

Hi @lope_0238 Ye syou can give column number or name…anything and for datetime…please useToString(“MM/dd/yyyy”) or any other format that matches with your excel If you use filter dt then use dt.rowcount.equals(0) And yes you can use linq as well…for that use dt.asenumerable.where(function(row) ro…

How to filter excel file in if-statement

Help Studio

enslinmarnus0 (Enslinmarnus0) November 18, 2022, 8:58am 6

Thank you for the assistance

1 Like

Topic		Replies	Views
Can Someone help me with filtering excel column which has a date Studio uiautomation	10	1029	March 28, 2022
Filter date using IF activity Help datatable , activities , question	3	1398	December 7, 2019
How can write this condition if condition Help studio	4	1596	December 12, 2019
Condition to filter date from excel Studio activities , studio	20	1679	July 11, 2022
Data table doubt Help	7	1404	March 1, 2019

How to filter excel file in if-statement

Related topics