Question of excel

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

HI @purnima_mandan

Check out this XAML file

Compare&DeleteRow.xaml (10.8 KB)

Output Snap

image

Regards
Gokul

Hi @purnima_mandan ,

What about below workflow

Workflow

Input
image

Output
image

Xaml
02.xaml (11.5 KB)

Best,

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

Duplicate post

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

image

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

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

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.

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

Regards
Gokul

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.