excel value exceeding 32767 cell limit into collection

[PankajWalia1]

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

[andrea.vezzoni]

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