Data gathered from the first Excel spreadsheet is not appended to another when i use append activity . can anyone suggest how to solve this

Help Studio
,
1

data gathered from the first Excel spreadsheet is not appended to another when i use append activity . can anyone suggest how to solve this

2

@ashritha

Welcome to forums

Is the datatable you used for append Range activity contains the data?

Cross check again

Also can you share the screenshot of your workflow?

Thanks

3

Capture1

This is the workflow. The datatable i used for append Range activity contains data.

Thanks for your reply.

4

Hi,

Append Range activity usually we use it to append the rows in the same sheet.

i think you could use workbook Write range activity and assign file path, sheet name and data table as shown in the image. i assume GetRange is datatable output form the read range.

image
image766×273 7.17 KB

5

Its worked. Thank you.

1 Like
6

Hi,

If you think it is solution please mark my post as solution. Marking solution would help others to refer the solution for the similar issues. thanks for understanding.

7

your welcome @ashritha