Append range corrupting excel

Hello!
I am getting data from 2 excel by read range, processing it using foreach, dt.select() etc and then appending the new data in the one of the excels being used.This is corrupting the data in excel.
Before the data gets corrupted i get an error message as:‘Min(155) must be less than or equal to max(-1) in range object’.
After this the data gets corrupted and the error is displayed as ‘Specified part does not belong in the package while using excel’

Can someone please help?

Regards.

If am not wrong. You are reading Excel A and Excel B , appending the value in Excel B ? or You are reading Excel A and Excel B , appending the value in Excel C ?

Hello @Shatakshi_Mishra,

could you please place the delay activity more than 5 to 7 seconds before “Append Range” activity?

Kind Regards,
Pankaj

Appending in Excel B itself.

Thank you so much!
Delay helps.

Regards

You are welcome,
good to hear !! :slight_smile:

Kind Regards,
Pankaj

Then Use some delay and check . I might solve your problem

Yes it did!
Thank you so much.

Regards