excel value exceeding 32767 cell limit into collection

PankajWalia1 — Mon, 20 Jan 2020 17:44:00 GMT

Hi , We are having issue with not able to copy text that exceeds 32767 limit (checked online on the cell limit) into a Excel cell. What we are trying is to write to cell and then use "worksheet as collection" to read into collection. Since the entire text exceeds limit , we are not getting all values into a collection .

If there is another way to get the text into collection let us know.

thanks.

------------------------------
Pankaj Walia
Architect
Wipro
America/New_York
------------------------------

RE: excel value exceeding 32767 cell limit into collection

andrea.vezzoni — Tue, 21 Jan 2020 13:53:00 GMT

Hello Pankaj,
The limitation of 32,767 is a limitation of the text box which is used to view the text data within the Object or Process Studio designer interface. The actual data within the Text Data Item is not limited in this way. The Text Data Item is limited only by the limitations of the .NET Framework for text strings, and that is more a memory limitation than a hard character limit. Providing that you do not attempt to VIEW the data in the Data Item, then the data will be preserved.
Hope this helps

------------------------------
Andrea Vezzoni
Customer Support Engineer
Blue Prism
------------------------------

topic RE: excel value exceeding 32767 cell limit into collection in Product Forum

excel value exceeding 32767 cell limit into collection

RE: excel value exceeding 32767 cell limit into collection