Special Character from Collection to Excel

[RaviKumar3]

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?

------------------------------
Ravi Kumar
Sr Automation Designer
Ericsson
Asia/Kolkata
------------------------------

[krishna.kodimurali9 · Accepted solution]

Hello Ravi,

Does the excel contain the special characters in some specified cells or those are appearing only after reading into the collection?

------------------------------
Murali
RPA Consultant
------------------------------

[RaviKumar3]

Thanks Murli, It worked with below code-
Dim data As String = Nothing
With New Threading.Thread(Sub() data = Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True))
.SetApartmentState(Threading.ApartmentState.STA)
.Start()
.Join()
End With

------------------------------
Ravi Kumar
Sr Automation Designer
Ericsson
Asia/Kolkata
------------------------------

[AnuraagPandey]

You could also check this thread for more information.

https://stackoverflow.com/questions/48180068/blue-prism-replace-non-english-characters

------------------------------
Anuraag Pandey
msg Systems AG
Germany
------------------------------