Get worksheet range as Collection

[shuangchang1]

​Hi, Dear members.
I some troubles to get worksheet as collection.
when there are too many words in the excel cell I can't get the value of that row.
I want to know how many words the Blueprism collection values can store at most

I will very appreciate if you can help me to solve this problem
Thanks you all.

------------------------------
shuang chang
PCS
Accenture
Asia/Shanghai
------------------------------

[david.l.morris]

I've no idea how many characters can be stored in a single value in a collection. I imagine it's tied to .NET limitations coupled with that Blue Prism is a 32-bit application, so I'd guess it's one of those 'whichever comes first' kind of things. What error message do you receive? And how many characters were in the Excel cell when it failed?

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

[rajeshkumarmuthineni]

​Hi I tried 855 words from excel cell to collection. I did not get any errors. If you are trying to get multiple rows and if the error is "out of memory exception" please use OLEDB and get single row instead multiple rows.

------------------------------
Rajesh kumar Muthineni
RPA Developer
Highmark Health
America/Chicago
------------------------------

[david.l.morris]

Hahahaha! Very ​cheeky, Rajesh. lol using our conversation for the test.

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

[rajeshkumarmuthineni]

​Haha I do not want to upload any PHI 🙂

------------------------------
Rajesh kumar Muthineni
RPA Developer
Highmark Health
America/Chicago
------------------------------