Excel Sort

[NiallFee]

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

[Denis__Dennehy]

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)

[NiallFee]

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