Search results

  1. E

    Excel Get Worksheet as Collection gives different values as in the Excel

    Finally we figured it out, that it depends on the Excel office display language. When we changed it to English it is working now. If it is local language the values are changing.
  2. E

    Set Column Names from Expected Collection causes internal error

    Hi, I have a simple process, read table from a webpage and then I would like to rename the collection headers to the predefined header names. When I use the "Set column names from expected collection" action I always get the following error message: Internal : Collection fields are defined but...
  3. E

    Excel Get Worksheet as Collection gives different values as in the Excel

    I would like to have the data exactly as in the Excel file, so uppercase TRUE and FALSE. Somehow any other option like True, False or local language translation should be excluded. I do not know if it is depend on the Windows setting, or Excel setting or Excel VBO setting.
  4. E

    Excel Get Worksheet as Collection gives different values as in the Excel

    Hi, I am working on the Blue Prism Consolidation Exercise, and when I using the MS Excel VBO::Get Worksheet As Collection (Fast) action to read the Excel data in the collection it gives back different values regarding the Priority Order column. In the Excel the value is TRUE or FALSE, but in...
Top