Collection Maximum Size

swapnadeep_deb — Thu, 28 Sep 2023 08:28:00 GMT

Hi Designers,

With ref. to this old thread - Blue Prism Community Site

Blueprism

remove preview

- Blue Prism Community Site

Do we have any update with the newer versions say v7 on the limit to read an excel file ?

Is number of columns still limited to 255 and is the best practice to read a large file say 100K rows is still by reading it in chunks of < 10k ?

What are all the new use cases to read/write large excels to a collection ?

------------------------------
Swapnadeep Deb
RPA Developer
------------------------------

RE: Collection Maximum Size

harish.mogulluri — Thu, 28 Sep 2023 15:20:00 GMT

Hi Swapnadeep Deb,

OLEDB is the best option if you're requirement is to read large amount of data.

Although memory wise BP capability has increased in V7 to handle more data But its always best to work on small data otherwise end up with memory issue after certain limitation

Thanks for the questions, waiting for other responses for the limitation of no of columns and rows BP can handle it compare to older version

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------

topic Collection Maximum Size in Product Forum

Collection Maximum Size

RE: Collection Maximum Size