Excel Translator Addin English to Chinese returns pinyin, not Chinese characters

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 4.75 out of 5)
Loading...
Go back to All Questions Login or Register
485 views
0

When I use the Excel translation add-in to translate from English to Chinese, the output is not Chinese characters, but pinyin spelling of the Chinese.

Example: Say hello to me = Duì wǒ hào wèn, but I want to see 对我好问

Have others observed this and do you know if it’s a function of your add-in or if there’s an Excel setting I need to change? Otherwise, love this add-in, very useful.

0

Hi Christa thank you for your feedback. Indeed there is currently no way to het the chinese character response. However the add in simply interacts with Google Translate and Google does return 2 responses – first is the arabic character response and the other is the original chinese character response. It is simply the add in the scrapes only the 1 response. To get chinese characters it is need to modify the Regex that does the scraping e.g.

This is the Google response to translating Hello to Chinese:
https://translate.google.pl/m?hl=EN&sl=EN&tl=zh-CN&ie=UTF-8&prev=_m&q=hello

From this page you need to adjust the Regex in the TextTranslate sub to scrape this DIV:
<div dir="ltr" class="t0">你好</div>
Instead of this one:
<div dir="ltr" class="o1">Nǐ hǎo</div>

I will add this to my backlog to add another translate option that would address this but can’t promise any dates at this time.

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match