topic How to read excel file which contains different languages and make it into a collection? in Product Forum https://community.blueprism.com/t5/Product-Forum/How-to-read-excel-file-which-contains-different-languages-and/m-p/48577#M4089 <P>Hi,</P> <H6>I a<SPAN style="color: rgb(0, 0, 0);">m having a</SPAN>n issue while reading an excel file which contains different languages (ex: Japanese as:「CAT」とは、次のどの表現を略したものですか。), to make it into a collection getting as,<SPAN> '?CAT????????????????????'.</SPAN></H6> <P><SPAN>Can anyone help on this please?</SPAN></P> <P><SPAN>Thanks in advance.</SPAN></P> <P><SPAN>Regards,<BR /></SPAN></P><BR /><BR />------------------------------<BR />Mani K.<BR />------------------------------<BR /> Thu, 23 Nov 2023 07:40:00 GMT Mani 2023-11-23T07:40:00Z How to read excel file which contains different languages and make it into a collection? https://community.blueprism.com/t5/Product-Forum/How-to-read-excel-file-which-contains-different-languages-and/m-p/48577#M4089 <P>Hi,</P> <H6>I a<SPAN style="color: rgb(0, 0, 0);">m having a</SPAN>n issue while reading an excel file which contains different languages (ex: Japanese as:「CAT」とは、次のどの表現を略したものですか。), to make it into a collection getting as,<SPAN> '?CAT????????????????????'.</SPAN></H6> <P><SPAN>Can anyone help on this please?</SPAN></P> <P><SPAN>Thanks in advance.</SPAN></P> <P><SPAN>Regards,<BR /></SPAN></P><BR /><BR />------------------------------<BR />Mani K.<BR />------------------------------<BR /> Thu, 23 Nov 2023 07:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-read-excel-file-which-contains-different-languages-and/m-p/48577#M4089 Mani 2023-11-23T07:40:00Z RE: How to read excel file which contains different languages and make it into a collection? https://community.blueprism.com/t5/Product-Forum/How-to-read-excel-file-which-contains-different-languages-and/m-p/48578#M4090 <P>Hello Mani</P> <P>Thank you for contacting the Blue Prism community.&nbsp;</P> <P>Please refer to the following knowledge base:</P> <P><A href="https://support.blueprism.com/en/support/solutions/articles/7000084406-how-can-i-resolve-garbled-text-when-importing-from-excel-data-to-collection-">How can I resolve garbled text when importing from Excel data to Collection?</A></P> <P>You need to modify the coding stage in Excel VBO for Unicode support characters.</P> <P></P> <P></P> <P></P><BR /><BR />------------------------------<BR />Hossein Azimi<BR />Customer Support Engineer, APAC<BR />Blue Prism<BR />Sydney NSW<BR />------------------------------<BR /> Tue, 16 Jan 2024 22:56:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-read-excel-file-which-contains-different-languages-and/m-p/48578#M4090 hossein.azimi 2024-01-16T22:56:00Z