https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-Characters-are-imported-as-question/m-p/87053#M37814 ​Dear BP Community<BR /><BR />Our Business teams are using RPA to create documents and emails for our internal clients.&nbsp;The inputs for this documents are read from several excel spread sheets and the input&nbsp;includes also special characters e.g. ą , ć. After the migration to Blue Prism 6 and Win10, we noted that few of the special characters, which were display in BPv5/Win7 correctly are imported as questions marks to the collections and documents/emails.<BR /><BR />Attached you can find my input file (Special CharactersCSV.xlsx) in&nbsp;"Column B" are the used characters and an screen shot from my collection (left Win10 and right Win7) as output. I&nbsp;get the collection with the BP BO&nbsp;"MS Excel VBO - Get Worksheet As Collection".<BR /><BR />Maybe someone of you can test on their system, if you are facing the similar issue with BPv6 on Win10? Or someone had this situation in the past too and can give me an advice, how I can solve it.<BR /><BR />Thanks and best regards<BR />Andre<BR /><BR />------------------------------<BR />Andre Köpplin<BR />Senior Business Process Analyst<BR />------------------------------<BR /> Fri, 26 Jul 2019 07:19:00 GMT AndreKöpplin 2019-07-26T07:19:00Z https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-Characters-are-imported-as-question/m-p/87053#M37814 ​Dear BP Community<BR /><BR />Our Business teams are using RPA to create documents and emails for our internal clients.&nbsp;The inputs for this documents are read from several excel spread sheets and the input&nbsp;includes also special characters e.g. ą , ć. After the migration to Blue Prism 6 and Win10, we noted that few of the special characters, which were display in BPv5/Win7 correctly are imported as questions marks to the collections and documents/emails.<BR /><BR />Attached you can find my input file (Special CharactersCSV.xlsx) in&nbsp;"Column B" are the used characters and an screen shot from my collection (left Win10 and right Win7) as output. I&nbsp;get the collection with the BP BO&nbsp;"MS Excel VBO - Get Worksheet As Collection".<BR /><BR />Maybe someone of you can test on their system, if you are facing the similar issue with BPv6 on Win10? Or someone had this situation in the past too and can give me an advice, how I can solve it.<BR /><BR />Thanks and best regards<BR />Andre<BR /><BR />------------------------------<BR />Andre Köpplin<BR />Senior Business Process Analyst<BR />------------------------------<BR /> Fri, 26 Jul 2019 07:19:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-Characters-are-imported-as-question/m-p/87053#M37814 AndreKöpplin 2019-07-26T07:19:00Z https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-Characters-are-imported-as-question/m-p/87054#M37815 Hi Andre,<BR /><BR />Fault lies in Excel VBO most probably. We had the same issue. Action "Get Worksheet As Collection" had this line in code stage:<BR /><BR />Dim data As String = Clipboard.GetDataObject().GetData(<STRONG>DataFormats.Text</STRONG>, True)<BR /><BR />While it should be:&nbsp;<BR /><BR />Dim data As String = Clipboard.GetDataObject().GetData(<STRONG>DataFormats.UnicodeText</STRONG>, True)<BR /><BR />For us it worked. You should correct it in all actions in Excel VBO that uses this part of the code.<BR /><BR />Best regards<BR />Michal<BR /><BR />------------------------------<BR />Michal Szumski<BR />RPA developer<BR />Rockwell Automation<BR />Europe/Warsaw<BR />------------------------------<BR /> Fri, 26 Jul 2019 12:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Collection-from-Excel-Characters-are-imported-as-question/m-p/87054#M37815 MichalSzumski 2019-07-26T12:01:00Z