topic RE: Special Character from Collection to Excel in Product Forum

Special Character from Collection to Excel

RaviKumar3 — Mon, 04 Oct 2021 08:35:00 GMT

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

RE: Special Character from Collection to Excel

krishna.kodimurali9 — Mon, 04 Oct 2021 08:45:00 GMT

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

RE: Special Character from Collection to Excel

RaviKumar3 — Mon, 04 Oct 2021 08:56:00 GMT

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

RE: Special Character from Collection to Excel

AnuraagPandey — Mon, 04 Oct 2021 13:07:00 GMT

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