Write range doesnot overwrite the existing data instead appending the data

Help Studio
, ,
1

I need to cut the rows from an excel sheet based on conditions and paste it to different sheet,
based on conditions i could append those rows to other sheet
but i need to cut them from main sheet so after filtering i used write range to write it back to main sheet , but write range causing error. @Palaniyappan could u please help sir?

2

Hi @kavya.s16,

Are you getting any error messages on your Write Range?

3

No I am not getting any error

4

Hi @kavya.s16 ,

Based on your explanation, I think you’re trying to write the data to the same excel which you have read using read range.
So, I hope you would have used for each row in datatable activity to iterate each row, so when you try to write to the same datatable which you read before then it will throw you an error.

Instead, try to write at the end of the flow using the write range.

Thanks,
@90s_Developer

5

I didnt get error because i am using different datatables for performing different condtions and i am using write range at the end itself

6

@kavya.s16 ,

Can you please share the screenshot of the error you’re facing or share the workflow screenshot, so it would be easy to identify the issue.

Thanks,
@90s_Developer

7

sorry but i cannot share screenshot , since its subjected to client environment

8

@kavya.s16,

You can share the error screenshot alone, because without that unable to proceed further.

Thanks,
@90s_Developer

9

Hi @kavya.s16 ,

From your problem statement you are trying to cut a set of data from say sheet1 and paste that data into sheet2 right ? and while pasting in sheet 2 you are getting error in write range. Only this is the issue? you can type/share only the error encountered.

Thanks,
Shikhar