使用Google翻译翻译整个Google表格 [英] Translate an entire Google Sheet using Google Translate

问题描述

我有一个用日语写的Google表格.我需要将其转换为英语.

I have a Google Sheet written in the Japanese Language. I need to convert it into English.

我知道我们可以使用 googletranslate(< sheet！:cell>，< input_language>，< output_language>)进行翻译.

I know we can use googletranslate(<sheet!:cell>, <input_language>, <output_language>) to translate.

但是没有脚本，这迫使我翻译每一行.我需要一个脚本，可以将我的整个Google表格转换为英语.

But without a script, this forces me to translate each and every row. I need a script that will convert my whole Google Sheet into English.

我希望将其转换为单独的图纸.请让我知道可能的解决方案.

I prefer if it's converted into a separate sheet. Please let me know of the possible solutions.

TIA

推荐答案

我遇到了同样的问题，但是我需要多语言支持，并且我不希望有任何重大延迟，也不必担心是否源单元已经使用了我想要的目标语言，所以我想出了这个解决方案.

I ran into the same problem, but I needed to have multiple language support and I didn't want any significant delay, nor did I want to worry whether the source cells were already in my desired destination language, so I came up with this solution.

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Translations')
    .addItem('Japanese > English', 'jpToEn')
    .addToUi();
}

function jpToEn() {
  translate('jp','en')
}

function translate(inputLang, outputLang) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var dest = sheet.copyTo(ss);
  dest.setName(`${inputLang}_${outputLang}_${sheet.getName()}`)
  var range = dest.getDataRange();
  var formula = "=iferror(googletranslate('" + sheet.getName() + "'!" + "R[0]C[0],\"" + inputLang +"\",\"" + outputLang + "\"),\"\")";
  range.setFormulaR1C1(formula);
}

如您所见，这会向您的Google表格文档中添加一个菜单.您可以根据需要随意翻译多种语言.只需扩展菜单或替换菜单中已有的项目即可.

As you can see, this adds a menu to to your Google Sheets document. You can make yours translate however you desire, as many different languages as you need. Just extend the menu or replace the items already there.

这篇关于使用Google翻译翻译整个Google表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！