Book.xlsx (9.6 KB)
this is my excel file
compair the sheet and file1 in excel file.
and compare with file1 after that
if same data are present in sheet file of ‘Customer_ID’ column, then delete the full rows
can you do this program please in your studio
Check out this XAML file
Compare&DeleteRow.xaml (10.8 KB)
Hi @purnima_mandan ,
What about below workflow
02.xaml (11.5 KB)
but it was written in same file
Where did you need to write the data?
it was written in same file but output was not correct
but i am write in new file than give the write output
than what changes i have to done in the file
Can you share the expected output? @purnima_mandan
If you need to write the Output in the new file then check out this XAML file
Compare&DeleteRow.xaml (16.3 KB)
You need to update the workbook file name here
i dont wan to write in new file i have to only write in same file
i was write same you send the file but output was not correct
What is not correct based on the topic description the output is derived. So if not correct your topic and your topic not good.
your output was correct but i want to write output in only sheet not on result sheet
Check out this XAML file @purnima_mandan
Compare&DeleteRow.xaml (15.1 KB)
thank you i got the output after
that i have to do
Book (1).xlsx (9.9 KB)
the date Column,
if the date is greater then current date, Delete the full row.
For this You can create the New topic @purnima_mandan
One topic is for one issue. Kindly close this topic by mark as solved. It will help for others
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.