Special Characters from Collection to Excel

[mangal.ravii]

Hello,

I am getting few special characters from Excel to Collection (As it is) but when I am writing back to excel then they are converting into some other character i.e '?' . Pls advise what should I do?

 

[sahil_raina_91]

Hello,

I am getting few special characters from Excel to Collection (As it is) but when I am writing back to excel then they are converting into some other character i.e '?' . Pls advise what should I do?

Its an old issue that was packaged with Blueprism.
Basically the shipped Excel VBO from an older version fetches the data from clipboard in Text format instead of UnicodeText

Open the Global code of Excel VBO and look for line :
Clipboard.GetDataObject().GetData(DataFormats.Text, True)
and update this to:
Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True)