Read Chinese from Excel and then input to SAP

hello @Michael_zhao
you can simply search on google as chinese font ttf . you will sure find it.

i got a link and i share with you

Thanks

Hi Sandeep,
thanks a lot for the information.
I have downloaded the Chinese font ttf, but what is the next step to use it?
you said go to control panel-> click on font and paste the chinese font there
Could you please tell me the details? if i need to go to UIpath studio or something else?

thanks a lot, it is very important for me .

Michael

yes
you go to control panel-> click on font and paste the chinese font there.
NO need to go to UIpath studio or something else

Thanks

thanks lot.

I understand your point.
but my win7 is in Chinese, do you think i still need to do this?

thanks,
Michael

okay. then i think no need to this…
just to confirm that your excel(microsoft excel) is also a chinese language.

Thanks

yes, my excel is in Chinese

I guess the issue was caused by the UIPATH Studios, but i donot know how to resolve it.
maybe the uipath miss some package?

thanks,
Michael

hello @Pablito @loginerror
Could you please help him in this.

Thanks

Hi @Michael_zhao,

While reading an excel try using (read CSV activity) & passing the encoding parameter,
you will be able to read the chinese characters as required.

Please refer the below link:-

Thanks

1 Like

Hi Ronak,
I am using Excel Application Scope and then read range. two activities i am using .

If i need to use CSV, how to use it?

thanks,
Michael

Hi @Michael_zhao,

You can save your excel file with the CSV format, & read the file directly using read csv activity.

Thanks

Hi Ronak,
the CSV reading works fine, but Chinese Chars still displayed as “???”
I am using encoding gb2312 to in read CSV .

is there any setting i missing?

thanks,
Michael

Hi Michael,

I suppose you have to do a bit of hit & trial,

Try using x-cp20936, or ISO-2022, or iso-8859-1(this one worked for me in case of danish characters).

Thanks

Hi Ronak,

it does not work even i try the encoding you listed .

thanks,
Michael

Hi Michael,

Please refer the link below

It might help…

Thanks

Hi Ronak,
I try to check the option ‘simulate type’ when using type into activity .
but it doest work.
i am not sure if the read CSV is working like read text .

I am crazy …

thanks,
Michael

The problem is still open.
Can anyone help?

it is failed to input to SAP from Excel, but input to notepad works fine .
another point is, when type into Chinese to SAP directly but not from Excel, it works fine.

i already read and that topic not help

Use this method

  1. Set to clipboard
  2. Get from clipboard
  3. set text

Use this method

  1. Set to clipboard
  2. Get from clipboard
  3. set text