Excel data overwrite

Main.xaml (11.3 KB)

my excel data is overwrite. how can i solve this problem.

1 Like

Use append range instead of write range. Give it a try and see if it helps.

HI Buddy @priyesh

Here is the updated xaml buddy
Main (5).xaml (12.5 KB)

Hope it would help you


Did that work for you buddy @priyesh

Not working.

Buddy may i know what was the error buddy…

actually data is overwrite when i put write range.
but when i used append range data is empty.

Simply my question is how can i resolved this overwrite thing.

okay, this problem also happened, when i merge multiple excel data in one excel file, same overwrite problem happened here.

May i have a view on your recently updated xaml with append range activity


Instead write range … you could create a DataTable Result, and inside your foreach Merge the DataTable result with each ExtractDataTable, and in the end out the foreach write the DataTable Result to a new excel with write range.

Let us know if this idea solve your problem.

can you do this with my .xaml file. And show me how it is work.

Main.xaml (11.4 KB)

I saw your workflow but I think that you need learn before how works the selectors.

Your goal here is to get all the names? right? well see if this way work for you.

Main (1).xaml (18.2 KB)

1 Like

@priyesh Let me know if that solve your problem. Or if you have another question :slight_smile:

1 Like

@carmen Thank you. yes problem solved.
Now i am practicing on Re-framework and have many questions to ask.:sweat_smile:

1 Like

good! Happy Automation!

1 Like

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