Search results

  1. A

    Retrieve large number of rows in collection through SQL

    Hi All, I am trying to fetch a large number of rows into Blueprism collection through SQL. The issue is, it is able to retrieve the rows(somewhere around 50,000) but it starts giving error right after. My motive is to filter it and then write this collection into an Excel file. Please let me...
  2. A

    Close one of thee two open excel workbook

    I am opening a new Excel workbook through one excel workbook(AFO) which is already open. Now after opening the new workbook I am getting issues with attaching. But if I manually close the previous workbook(the not required one), then everything seems to work perfectly. Is there a way to close...
  3. A

    Need a code to remove empty columns (similiar to removing empty rows)

    Hi All, I am searching for VBA code to delete all empty columns from a collection which works similar to removing empty rows action.
  4. A

    Read previous row based on value of next row

    Hi all, I am trying to extract data using string manipulation. Although there is a row that doesn't consist of any fix keyword but there is a fix keyword in the next row. How do I get this done using Utility-Collection Manipulation or is there any other alternate?
  5. A

    Convert to euros dynamically

    Hi everyone. I am trying to develop a module where we need to convert the currency from the excel workbook to euros and this needs to be done for multiple data several times a week. So converting to euros using an online tool is really time taking. Does anyone know some alternative so that I...
  6. A

    Solved String to get text between two words

    Can we create a string in the calculate stage that can get the text between two words? For example: "Hi its me" So the output should be "its".
Top