Why excel write workbook creates entire new sheet instead of write the data into it

Help Activities
, ,
1

I am updating an excel column by comparing with other column in the same sheet and somehow It is creating new sheet to write that data. I want to write it in same sheet.

Used Read workbook to read that sheet.
Assign activity to filter and save.
Write range activity to write that data.

2

Hello @Pal_Patel ,

Have you double checked the Sheet name during the Write Range Workbook Activity?

Thanks,
Erigert

1 Like
3

@Pal_Patel,

This only happen when the Sheet name is different than the current sheet name in file.

Solution:
Check the Sheet name in your file and Write Range Activity.

Thanks,
Ashok :slight_smile:

4

Thanks , there was a space in the file name.

5

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