How to read excel file which contains different languages and make it into a collection?

[Mani]

Hi,

I am having an issue while reading an excel file which contains different languages (ex: Japanese as:「CAT」とは、次のどの表現を略したものですか。), to make it into a collection getting as, '?CAT????????????????????'.

Can anyone help on this please?

Thanks in advance.

Regards,

------------------------------
Mani K.
------------------------------

[hossein.azimi]

Hello Mani

Thank you for contacting the Blue Prism community. 

Please refer to the following knowledge base:

How can I resolve garbled text when importing from Excel data to Collection?

You need to modify the coding stage in Excel VBO for Unicode support characters.

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------