topic RE: Czech characters Excel VBO compatability in Product Forum

Czech characters Excel VBO compatability

PaulTrouton — Mon, 09 Sep 2019 09:06:00 GMT

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
------------------------------

RE: Czech characters Excel VBO compatability

sumire — Tue, 10 Sep 2019 06:21:00 GMT

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
------------------------------

RE: Czech characters Excel VBO compatability

MichalSzumski — Tue, 10 Sep 2019 06:42:00 GMT

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#bm4763d76f-c65b-44f5-9c67-d2e7358604a1

Best regards,
Michal

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

RE: Czech characters Excel VBO compatability

ChenglungTsai1 — Tue, 10 Sep 2019 07:21:00 GMT

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
------------------------------

RE: Czech characters Excel VBO compatability

PaulTrouton — Tue, 10 Sep 2019 09:34:00 GMT

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

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