Excel file has some unwanted rows of data need to remove those particular rows. By taking one column (Sl. No) as condition how to do this, please help.
Below attached file is the sample file, please look on it.
test_file.xlsx (8.8 KB)
How to do this. Please help me.
You can try with Filter datatable activity
i tried but its deleting whole excel file. What to do.
Read Range into a datatable. Remove the rows you don’t want, from the datatable. Write to a new Excel file. Delete old Excel file.
You can filter your excel like this.
After, you can write filtered table to the excel.
Thanks a lot helping. I tried using “SI. No” = “PW980”, its was deleting all the rows.
Thanks & Regards,
I’m glad this activity works, i thought you need to specify the rows start with PW
Have a nice day.
“Sl no.” = “PW980”
That column name is wrong. It’s “SI. No”
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.