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.
Can you send the sample input file, so that we can work on it??
The easiest way you can achieve this is by using datatables:
- read both xlsx files into datatables (=> dtfile1 and dtfile2)
- filter dtfile1 using filter datatable activities by records of interest
- iterate through filtered rows and take two actions 1. insert row in dtfile2 and 2. delete row in dtfile1
- write back to xlsx using write range both dtfile1 > file1.xlsx and dtfile2 > file2.xlsx
Hope I explained it clearly, but I can add details if required.
can you provide a sample xaml file.
I tried this and this is exactly what the output I’m expecting.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.