Czech characters Excel VBO compatability

[PaulTrouton]

POST A REPLY

Does anyone have a solution for reading Czech characters (ě, ř, Č) into Blue Prism with the Excel VBO? When I use Get Worksheet As Collection action the Czech characters are replaced with a question mark. e.g. the Czech town Nové Město na Moravě becomes Nové M?sto na Morav? after reading into a collection.

Running Blue Prism 6.2

------------------------------
Paul Trouton
RPA Specialist
Allen & Overy
Europe/London
------------------------------

[sumire]

Hi I am Japanese and know nothing about Czech language, but I use Japanese characters in Blue Prism.

You already set Czech language font on Blue Prism? The place to set is system - font.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

[MichalSzumski]

Hi Paul,

Please check following thread:
https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=4763d76f-c65b-44f5-9c67-d2e7358604a1&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer#bm...

Best regards,
Michal

------------------------------
Michal Szumski
RPA developer
Rockwell Automation
Europe/Warsaw
------------------------------

[ChenglungTsai1 · Accepted solution]

Hi Paul,

This is a little bit tricky issue.

The Get Worksheet As Collection action is using clipboard to parse the data from excel sheet to the collection.
So the reason causing this ?mark error is on "Clipboard.GetDataObject()" function which is defined by global code page. This is no thing to do with Excel itself.

To dive into this issue, you can try "get cell value" to extract the Czech characters and you will find anything is fine, because the "get cell value" action extract the value from excel sheet directly.

But when you using Get Worksheet As Collection action, you can find this action using the function called "GetClipboardText()" to transfer the datatable from clipboard to the collection.

And this process of putting data into clipboard cause this ?mark issue because this function does not accept the unique characters.

To solve this issue, please go to initialize page and open the global code and replace the code below.

Before:
With New Threading.Thread(Sub() data = Clipboard.GetDataObject().GetData(DataFormats.Text, True))

After:
With New Threading.Thread(Sub() data = Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True))




------------------------------
Chenglung Tsai
Consultant
Avanade
------------------------------

[PaulTrouton]

Thanks, changing that line of code in the Excel VBO global code fixed the issue.

------------------------------
Paul Trouton
RPA Specialist
Allen & Overy
Europe/London
------------------------------