Read Chinese from Excel and then input to SAP

Help
21

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

22

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

Thanks

23

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
24

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

25

Hi @Michael_zhao,

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

Thanks

26

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

27

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

28

Hi Ronak,

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

thanks,
Michael

29

Hi Michael,

Please refer the link below

It might help…

Thanks

30

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

31

The problem is still open.
Can anyone help?

32

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.

33

i already read and that topic not help

34

Use this method

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

Use this method

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