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
Gokul001
(Gokul Balaji)
December 2, 2022, 5:13am
2
HI @purnima_mandan
Check out this XAML file
Compare&DeleteRow.xaml (10.8 KB)
Output Snap
Regards
Gokul
RajKumar_DC
(RajKumar Durai)
December 2, 2022, 5:21am
3
Hi @purnima_mandan ,
What about below workflow
Workflow
Input
Output
Xaml
02.xaml (11.5 KB)
Best,
but it was written in same file
Gokul001
(Gokul Balaji)
December 2, 2022, 5:31am
5
purnima_mandan:
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
Gokul001
(Gokul Balaji)
December 2, 2022, 5:35am
7
Can you share the expected output? @purnima_mandan
Gokul001
(Gokul Balaji)
December 2, 2022, 5:37am
9
Hi @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
Regards
Gokul
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
Gokul001
(Gokul Balaji)
December 2, 2022, 5:42am
11
What is not correct based on the topic description the output is derived. So if not correct your topic and your topic not good.
?? @purnima_mandan
your output was correct but i want to write output in only sheet not on result sheet
Gokul001
(Gokul Balaji)
December 2, 2022, 5:46am
13
Check out this XAML file @purnima_mandan
Compare&DeleteRow.xaml (15.1 KB)
Regards
Gokul
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.
Gokul001
(Gokul Balaji)
December 2, 2022, 6:09am
15
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
Forum FAQ - How to mark a post as a solution
This document is part of our beginners guide .
This article will teach you how to properly mark a post as a solution.
We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them.
When is the topic resolved?
The topic can be considered resolved when the topic author has fo…
Regards
Gokul
system
(system)
Closed
December 5, 2022, 6:10am
16
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.