hi, how i want to delete each row that has other than number at my first column?this is the example, i want to delete in column name ‘ain’ that contain other than number EXAMPLE.xlsx (9.0 KB)

How to delete rows excel that contain unwanted data

Yoichi (Yoichi) December 11, 2022, 2:34pm 3

Hi,

Another approach:

We can use DeleteRows activity as the following, for example.

Regards,

Topic		Replies	Views
Delete row in excel if it contains aprticular element Help excel , uiautomation , activities , regex , question	9	1762	December 22, 2020
Delete specific rows in excel StudioX excel	10	1589	June 6, 2022
Delete row that column Name = #N/A Activities excel , activities , question	3	1225	March 5, 2022
Delete Entier row met condition Studio uiautomation	9	248	January 17, 2024
Deleting Zeros in specific column Studio excel , use-excel-file	6	860	April 22, 2023