在Excel中翻译多个单元格 [英] Translating multiple cells in Excel
问题描述
我目前正在翻译一个包含两列包含多个单元格的Excel文档。 A列包含源语言,而B列是翻译的位置。 Microsoft Translator是我正在使用的工具之一,但我似乎无法弄清楚
如何同时翻译多个单元格?
当我突出显示多个单元格时,单击翻译并插入B列中的相邻单元格,会发生的事情是只翻译了第一个单元格 - 类似于这个:
车 - Bil(正确)
Plane - Bil
Cat - Bil
Cheese - Bil
尸体 - Bil
是否可以在一个操作中翻译整个列?提前致谢!
$
您好
我使用Visual Studio和VSTO代码(即C#)完成了这项工作。 基本上它是一个exe打开电子表格并在A列中发送每个单独的单元格,并转换为第1行中指定的语言。
如果您熟悉C#编码,我很高兴分享我的代码。 您仍然需要自己的翻译密钥,因此翻译服务会提取您的帐户。
Andrew
Hi,
I'm currently translating an excel document consisting of two columns with many cells. Column A contains the source langauge, while column B is where the translations are made. Microsoft Translator is one of the tools I'm using, but I can't seem to figure out
how to translate multiple cells simultaneously?
When I'm highlighting multiple cells, click translate and insert into the adjacent cells in column B, what happens is that only the very first cell is translated - something like this:
Car - Bil (correct)
Plane - Bil
Cat - Bil
Cheese - Bil
Corpse - Bil
Is it possible to translate entire columns in a single action? Thanks in advance!
Hi
I've done this using Visual Studio and VSTO code (that is C#). Basically it is an exe that opens up a spreadsheet and sends each individual cell in column A, and converts to the languages specified in Row 1.
If you comfortable with C# coding, I'm happy to share my code. You'll still need your own translation key, so the translation service draws down on your account.
Andrew
这篇关于在Excel中翻译多个单元格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!