cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Sort

NiallFee
Level 3
Hi Can anyone advise how I can sort data in Excel using Blue Prism? I have a worksheet with approx. 80,000 rows and 50 columns that I need to sort. I have tried loading to a collection and using the Collection Sort Utility but it fails with an OutOfMemory error. Thanks
2 REPLIES 2

Denis__Dennehy
Level 15
For such an enormous excel worksheet you will either need to break down your use of it into smaller ranges, or look at using the OLEDB VBO object to query it (much like you would query a database, you could do a select statement with an order by)

Thanks. I will try this once I get the latest OLEDB VBO.