Excel data overwrite

Help
, ,
1

Main.xaml (11.3 KB)

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

1 Like
2

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

3

HI Buddy @priyesh

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

Hope it would help you

Cheers

4

Did that work for you buddy @priyesh

5

Not working.

6

Buddy may i know what was the error buddy…
Cheers

7

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

8

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.

9

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

Cheers

10

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.

11

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

12

Main.xaml (11.4 KB)

13

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
14

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

1 Like
15

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

1 Like
16

good! Happy Automation!

1 Like
17

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