I have an excel file(file1.xlsx) that contains data and there is a specific column “Account Type” that contains the dynamic value. I would like to remove the entire row that contains the value of PEP, DOSRI, and RPT and move it to a new file (file2.xslx)
file1.xlsx --> origin of data
file2.xsls --> Data that was extracted from file1.xlsx
file1.xlsx should look like this after extracting the details
Can you provide a sample XAML that I can reference to in developing this exercise script.
Thanks in advance.