Question

How the collection size in blue prism is consumed for memory it includes row count or both columns and rows

Answer 1

It is always advised to limit the rows to <10k.

If you have a large number of rows in your excel you need to split the file into smaller chunks and then load the data that way. But you need to disable logging if you loop'ing with such a big amount, or else the process will die.

Hope this helps!

Comments

Its greater than 10K

---

If your file has a large number of entries it is advisable to split the contents as the file loading would be extremely slower.