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.
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.