Get Worksheet as collection

[AndrewHurn]

Hi, I am using the standard Excel VBO object to 'Get Worksheet as Collection' and am inconsistently getting the error message 'Exception: Internal| Could not execute code stage because exception thrown by code stage: Requested Clipboard operation did not succeed'. The spreadsheet has circa 30 columns and can be up to 1000 rows. Is there a limit to the amount of data which can be extracted through this method? If so, can someone advise on the best solution to this? Please note I have minimal experience of using code within Blueprism. Many thanks

[Denis__Dennehy]

For massive amounts of data it would always be good practice to reduce the data you are working in any one time. There is an action that gets a worksheet range as a collection - I would recommend using this to break down what you are trying to do into smaller chunks.