Collection Maximum Size

[swapnadeep_deb]

Hi Designers,

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

Blueprism		remove preview
- Blue Prism Community Site View this on Blueprism >

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
------------------------------

[harish.mogulluri]

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
------------------------------