Home  >  Article  >  Software Tutorial  >  How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel

How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel

王林
王林forward
2024-04-24 13:01:101089browse

Encountered the need to translate a large amount of text content in Excel tables from Chinese to English? PHP editor Banana has specially compiled a detailed tutorial on this task to help you easily implement batch Chinese-English translation in Excel and say goodbye to tedious manual operations. Come and find out, let you deal with translation work efficiently from now on!

1. Open the Excel document that needs to be translated, and add a column to place the corresponding translated English content.

How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel

2. Enter the formula in the first column: =FILTERXML(WEBSERVICE("http://fanyi.youdao.com/translate?&i="&A2&"&doctype=xml&version "),"//translation")

(You can copy it directly, but please note that the cells must correspond).

How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel

3. After entering the formula, click [Enter] to confirm. You can see that after the translation is performed directly through Youdao, the translation result is entered into the specified cell.

How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel

4. After the above is successful, the contents of the corresponding column can be translated in batches just like ordinary drop-down cells.

How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel

The above is the detailed content of How to batch Chinese-English translation in Excel tables_Tutorial sharing on batch Chinese-English translation in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact [email protected] delete