Read Chinese from Excel and then input to SAP

hello @Michael_zhao

download Chinese font and go to control panel-> click on font and paste the chinesh font there

its works for me to read hebrew language

Thanks

1 Like

Hi Sandeep,

where I can download the Chinese font? i can not find it .

thanks,
Michael

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