Append range corrupting excel


#1

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.


#2

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 ?


#3

Hello @Shatakshi_Mishra,

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

Kind Regards,
Pankaj


#4

Appending in Excel B itself.


#5

Thank you so much!
Delay helps.

Regards


#6

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

Kind Regards,
Pankaj


#7

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


#8

Yes it did!
Thank you so much.

Regards