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 the collection is True or False, and on some computers it is True or False in local language.
Could you please help how can I change the setup not to treat these values as flag?

Thank you.

Always Do you want the True or False in upper case?

@erika027

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.

when i am loading data into collection , i am getting as is in text format of TRUE or FALSE what i have in excel

Hi @erika027 ,

Just try with the basic action i.e. MS Excel VBO::Get Worksheet As Collection.

Post how it goes.

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.