I was tasked to extract data from images of receipts, for which I was successfully able to. So now my question is, how can I extract only the price in Blueprism from the below-extracted data (e.g The price is in Rands: R310.00) :
LIFE GRAND CAFE
(#* APPROVED *)
INVOICE NR.: 195
Any wants to code for the Refresh Data on the file open. or want to reduce the size of file you can use the following code stage i am sharing the code
Dim wb, ws As Object
Dim excel, sheet As Object
wb = GetWorkbook(Handle, Workbook)
ws = GetWorksheet(Handle, Workbook, Worksheet)
excel = ws.Application
sheet = excel.ActiveSheet
sheet.PivotTables(PivotName).SaveData = F
Is there any option to check if one collection is empty or not other than using 'Count Row' action from internal VBO 'Collection'?
It is an undefined collection. As per the business scenario, sometime the object will get some value from the target application and put it in the collection and sometime it is not when the application is not having any value.