My project contains 3 sections where I need to “Write Cell/Range” and every time it causes UiPath to break and give me an error message (copied from a similar topic so job name is different, otherwise the same):
Essentially the process goes into 2 excel files, manipulates the data slightly, reads the ranges into datatables, then should paste them into a third excel file.
When I comment out one Write Cell section (which works on it’s own when not part of the larger process), it will proceed past this point, and then it causes the same error message at a later stage when I “Write Range”. On the first part, where Write Cell is used in a loop it will actually do about 10 or so (out of 30) before stopping, but on the Write Range it just won’t budge. I’ve seen mention of message sizes elsewhere, and that on latest versions 1MB is the maximum, but as I know this component works elsewhere is it perhaps the 3 datatables which are being stored are “too big” somehow?
Not sure what else I can do unless I chop up the process and change when the datatables are written so that they do not need to be stored in memory?