topic RE: Data in excel sheet is not in English and header is making errors in Product Forum https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93107#M42748 Hi, Sara,<BR /><BR />it depends on VBO you use. It may be in the action (Code stage) you call or in Initialise action/page. When you click on big rectangle to get to Business Object properties window and then you choose Global code tab you should find it there.<BR /><BR />Regards<BR /><BR />Zdenek<BR /><BR />------------------------------<BR />Zdeněk Kabátek<BR />Head of Professional Services<BR />NEOOPS<BR /><A href="http://www.neoops.com/" target="test_blank">http://www.neoops.com/</A><BR />Europe/Prague<BR />------------------------------<BR /> Mon, 26 Sep 2022 06:33:00 GMT zdenek.kabatek 2022-09-26T06:33:00Z Data in excel sheet is not in English and header is making errors https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93103#M42744 I have Data in excel sheet are not in english, they have been shown as question marks<BR /><BR />how to let this data be shown as readable form?<BR /><BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="24450.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/24583i3A1B781A8C71C6AE/image-size/large?v=v2&amp;px=999" role="button" title="24450.png" alt="24450.png" /></span><BR />another issue that the header in the excel sheet is making this error, I believe it is the same issue above, about the language<BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="24451.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/24584i1E73541B43F7AC15/image-size/large?v=v2&amp;px=999" role="button" title="24451.png" alt="24451.png" /></span></DIV> </DIV> <BR /><BR />------------------------------<BR />Sara Nof<BR />------------------------------ Thu, 22 Sep 2022 10:54:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93103#M42744 SaraNof 2022-09-22T10:54:00Z RE: Data in excel sheet is not in English and header is making errors https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93104#M42745 what are the headers of your excel sheet in question what do they actually say?<BR /><BR />------------------------------<BR />Dexter Whelan<BR />Senior Developer/Mentor<BR />SAS<BR />Europe/London<BR />------------------------------<BR /> Thu, 22 Sep 2022 11:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93104#M42745 Dexter_Whelan_SAS 2022-09-22T11:01:00Z RE: Data in excel sheet is not in English and header is making errors https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93105#M42746 Hi, Sara,<BR /><BR />it is due to non unicode support in your excel VBO. Search the code stage for following string "Clipboard.GetDataObject().GetData(DataFormats.Text, True)" and change it to "Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True)" that should fix your issue.<BR /><BR />Regards<BR /><BR />Zdenek<BR /><BR />------------------------------<BR />Zdeněk Kabátek<BR />Head of Professional Services<BR />NEOOPS<BR /><A href="http://www.neoops.com/" target="test_blank">http://www.neoops.com/</A><BR />Europe/Prague<BR />------------------------------<BR /> Thu, 22 Sep 2022 12:50:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93105#M42746 zdenek.kabatek 2022-09-22T12:50:00Z RE: Data in excel sheet is not in English and header is making errors https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93106#M42747 Hi <SPAN>Zdenek,&nbsp;<BR /><BR />Where to search?</SPAN><BR /><BR />------------------------------<BR />Sara Nof<BR />------------------------------<BR /> Sun, 25 Sep 2022 11:05:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93106#M42747 SaraNof 2022-09-25T11:05:00Z RE: Data in excel sheet is not in English and header is making errors https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93107#M42748 Hi, Sara,<BR /><BR />it depends on VBO you use. It may be in the action (Code stage) you call or in Initialise action/page. When you click on big rectangle to get to Business Object properties window and then you choose Global code tab you should find it there.<BR /><BR />Regards<BR /><BR />Zdenek<BR /><BR />------------------------------<BR />Zdeněk Kabátek<BR />Head of Professional Services<BR />NEOOPS<BR /><A href="http://www.neoops.com/" target="test_blank">http://www.neoops.com/</A><BR />Europe/Prague<BR />------------------------------<BR /> Mon, 26 Sep 2022 06:33:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-in-excel-sheet-is-not-in-English-and-header-is-making/m-p/93107#M42748 zdenek.kabatek 2022-09-26T06:33:00Z