翻译 Google 文档、表格和幻灯片中的文字

使用集合让一切井井有条 根据您的偏好保存内容并对其进行分类。

const DEFAULT_INPUT_TEXT = ''; const DEFAULT_OUTPUT_TEXT = ''; const DEFAULT_ORIGIN_LAN = ''; // Empty string means detect langauge const DEFAULT_DESTINATION_LAN = 'en' // English  const LANGUAGE_MAP =   [     { text: 'Detect Language', val: '' },     { text: 'Afrikaans', val: 'af' },     { text: 'Albanian', val: 'sq' },     { text: 'Amharic', val: 'am' },     { text: 'Arabic', val: 'ar' },     { text: 'Armenian', val: 'hy' },     { text: 'Azerbaijani', val: 'az' },     { text: 'Basque', val: 'eu' },     { text: 'Belarusian', val: 'be' },     { text: 'Bengali', val: 'bn' },     { text: 'Bosnian', val: 'bs' },     { text: 'Bulgarian', val: 'bg' },     { text: 'Catalan', val: 'ca' },     { text: 'Cebuano', val: 'ceb' },     { text: 'Chinese (Simplified)', val: 'zh-CN' },     { text: 'Chinese (Traditional)', val: 'zh-TW' },     { text: 'Corsican', val: 'co' },     { text: 'Croatian', val: 'hr' },     { text: 'Czech', val: 'cs' },     { text: 'Danish', val: 'da' },     { text: 'Dutch', val: 'nl' },     { text: 'English', val: 'en' },     { text: 'Esperanto', val: 'eo' },     { text: 'Estonian', val: 'et' },     { text: 'Finnish', val: 'fi' },     { text: 'French', val: 'fr' },     { text: 'Frisian', val: 'fy' },     { text: 'Galician', val: 'gl' },     { text: 'Georgian', val: 'ka' },     { text: 'German', val: 'de' },     { text: 'Greek', val: 'el' },     { text: 'Gujarati', val: 'gu' },     { text: 'Haitian Creole', val: 'ht' },     { text: 'Hausa', val: 'ha' },     { text: 'Hawaiian', val: 'haw' },     { text: 'Hebrew', val: 'he' },     { text: 'Hindi', val: 'hi' },     { text: 'Hmong', val: 'hmn' },     { text: 'Hungarian', val: 'hu' },     { text: 'Icelandic', val: 'is' },     { text: 'Igbo', val: 'ig' },     { text: 'Indonesian', val: 'id' },     { text: 'Irish', val: 'ga' },     { text: 'Italian', val: 'it' },     { text: 'Japanese', val: 'ja' },     { text: 'Javanese', val: 'jv' },     { text: 'Kannada', val: 'kn' },     { text: 'Kazakh', val: 'kk' },     { text: 'Khmer', val: 'km' },     { text: 'Korean', val: 'ko' },     { text: 'Kurdish', val: 'ku' },     { text: 'Kyrgyz', val: 'ky' },     { text: 'Lao', val: 'lo' },     { text: 'Latin', val: 'la' },     { text: 'Latvian', val: 'lv' },     { text: 'Lithuanian', val: 'lt' },     { text: 'Luxembourgish', val: 'lb' },     { text: 'Macedonian', val: 'mk' },     { text: 'Malagasy', val: 'mg' },     { text: 'Malay', val: 'ms' },     { text: 'Malayalam', val: 'ml' },     { text: 'Maltese', val: 'mt' },     { text: 'Maori', val: 'mi' },     { text: 'Marathi', val: 'mr' },     { text: 'Mongolian', val: 'mn' },     { text: 'Myanmar (Burmese)', val: 'my' },     { text: 'Nepali', val: 'ne' },     { text: 'Norwegian', val: 'no' },     { text: 'Nyanja (Chichewa)', val: 'ny' },     { text: 'Pashto', val: 'ps' },     { text: 'Persian', val: 'fa' },     { text: 'Polish', val: 'pl' },     { text: 'Portuguese (Portugal, Brazil)', val: 'pt' },     { text: 'Punjabi', val: 'pa' },     { text: 'Romanian', val: 'ro' },     { text: 'Russian', val: 'ru' },     { text: 'Samoan', val: 'sm' },     { text: 'Scots Gaelic', val: 'gd' },     { text: 'Serbian', val: 'sr' },     { text: 'Sesotho', val: 'st' },     { text: 'Shona', val: 'sn' },     { text: 'Sindhi', val: 'sd' },     { text: 'Sinhala (Sinhalese)', val: 'si' },     { text: 'Slovak', val: 'sk' },     { text: 'Slovenian', val: 'sl' },     { text: 'Somali', val: 'so' },     { text: 'Spanish', val: 'es' },     { text: 'Sundanese', val: 'su' },     { text: 'Swahili', val: 'sw' },     { text: 'Swedish', val: 'sv' },     { text: 'Tagalog (Filipino)', val: 'tl' },     { text: 'Tajik', val: 'tg' },     { text: 'Tamil', val: 'ta' },     { text: 'Telugu', val: 'te' },     { text: 'Thai', val: 'th' },     { text: 'Turkish', val: 'tr' },     { text: 'Ukrainian', val: 'uk' },     { text: 'Urdu', val: 'ur' },     { text: 'Uzbek', val: 'uz' },     { text: 'Vietnamese', val: 'vi' },     { text: 'Welsh', val: 'cy' },     { text: 'Xhosa', val: 'xh' },     { text: 'Yiddish', val: 'yi' },     { text: 'Yoruba', val: 'yo' },     { text: 'Zulu', val: 'zu' }   ];   /**  * Callback for rendering the main card.  * @return {CardService.Card} The card to show the user.  */ function onHomepage(e) {   return createSelectionCard(e, DEFAULT_ORIGIN_LAN, DEFAULT_DESTINATION_LAN, DEFAULT_INPUT_TEXT, DEFAULT_OUTPUT_TEXT); }  /**  * Main function to generate the main card.  * @param {String} originLanguage Language of the original text.  * @param {String} destinationLanguage Language of the translation.  * @param {String} inputText The text to be translated.  * @param {String} outputText The text translated.  * @return {CardService.Card} The card to show to the user.  */ function createSelectionCard(e, originLanguage, destinationLanguage, inputText, outputText) {   var hostApp = e['hostApp'];   var builder = CardService.newCardBuilder();    // "From" language selection & text input section   var fromSection = CardService.newCardSection()     .addWidget(generateLanguagesDropdown('origin', 'From: ', originLanguage))     .addWidget(CardService.newTextInput()       .setFieldName('input')       .setValue(inputText)       .setTitle('Enter text...')       .setMultiline(true));    if (hostApp === 'docs') {     fromSection.addWidget(CardService.newButtonSet()       .addButton(CardService.newTextButton()         .setText('Get Selection')         .setOnClickAction(CardService.newAction().setFunctionName('getDocsSelection'))         .setDisabled(false)))   } else if (hostApp === 'sheets') {     fromSection.addWidget(CardService.newButtonSet()       .addButton(CardService.newTextButton()         .setText('Get Selection')         .setOnClickAction(CardService.newAction().setFunctionName('getSheetsSelection'))         .setDisabled(false)))   } else if (hostApp === 'slides') {     fromSection.addWidget(CardService.newButtonSet()       .addButton(CardService.newTextButton()         .setText('Get Selection')         .setOnClickAction(CardService.newAction().setFunctionName('getSlidesSelection'))         .setDisabled(false)))   }     builder.addSection(fromSection);    // "Translation" language selection & text input section   builder.addSection(CardService.newCardSection()     .addWidget(generateLanguagesDropdown('destination', 'To: ', destinationLanguage))     .addWidget(CardService.newTextInput()       .setFieldName('output')       .setValue(outputText)       .setTitle('Translation...')       .setMultiline(true)));    //Buttons section   builder.addSection(CardService.newCardSection()     .addWidget(CardService.newButtonSet()       .addButton(CardService.newTextButton()         .setText('Translate')         .setTextButtonStyle(CardService.TextButtonStyle.FILLED)         .setOnClickAction(CardService.newAction().setFunctionName('translateText'))         .setDisabled(false))       .addButton(CardService.newTextButton()         .setText('Clear')         .setOnClickAction(CardService.newAction().setFunctionName('clearText'))         .setDisabled(false))));    return builder.build();  }  /**  * Helper function to generate the drop down language menu. It checks what language the user had selected.  * @param {String} fieldName  * @param {String} fieldTitle  * @param {String} previousSelected The language the user previously had selected.  * @return {CardService.SelectionInput} The card to show to the user.  */ function generateLanguagesDropdown(fieldName, fieldTitle, previousSelected) {   var selectionInput = CardService.newSelectionInput().setTitle(fieldTitle)     .setFieldName(fieldName)     .setType(CardService.SelectionInputType.DROPDOWN);    LANGUAGE_MAP.forEach((language, index, array) => {     selectionInput.addItem(language.text, language.val, language.val == previousSelected);   })    return selectionInput; }  /**  * Helper function to translate the text. If the originLanguage is an empty string, the API detects the language  * @return {CardService.Card} The card to show to the user.  */ function translateText(e) {   var originLanguage = e.formInput.origin;   var destinationLanguage = e.formInput.destination;   var inputText = e.formInput.input;    if (originLanguage !== destinationLanguage && inputText !== undefined) {     var translation = LanguageApp.translate(e.formInput.input, e.formInput.origin, e.formInput.destination);     return createSelectionCard(e, originLanguage, destinationLanguage, inputText, translation);   } }  /**  * Helper function to clean the text.  * @return {CardService.Card} The card to show to the user.  */ function clearText(e) {   var originLanguage = e.formInput.origin;   var destinationLanguage = e.formInput.destination;   return createSelectionCard(e, originLanguage, destinationLanguage, DEFAULT_INPUT_TEXT, DEFAULT_OUTPUT_TEXT); }  /**  * Helper function to get the text selected.  * @return {CardService.Card} The selected text.  */ function getDocsSelection(e) {   var text = '';   var selection = DocumentApp.getActiveDocument().getSelection();   Logger.log(selection)   if (selection) {     var elements = selection.getRangeElements();     for (var i = 0; i < elements.length; i++) {       Logger.log(elements[i]);       var element = elements[i];       // Only modify elements that can be edited as text; skip images and other non-text elements.       if (element.getElement().asText() && element.getElement().asText().getText() !== '') {         text += element.getElement().asText().getText() + '\n';       }     }   }    if (text !== '') {     var originLanguage = e.formInput.origin;     var destinationLanguage = e.formInput.destination;     var translation = LanguageApp.translate(text, e.formInput.origin, e.formInput.destination);     return createSelectionCard(e, originLanguage, destinationLanguage, text, translation);   } }  /**  * Helper function to get the text of the selected cells.  * @return {CardService.Card} The selected text.  */ function getSheetsSelection(e) {   var text = '';   var ranges = SpreadsheetApp.getActive().getSelection().getActiveRangeList().getRanges();   for (var i = 0; i < ranges.length; i++) {     const range = ranges[i];     const numRows = range.getNumRows();     const numCols = range.getNumColumns();     for (let i = 1; i <= numCols; i++) {       for (let j = 1; j <= numRows; j++) {         const cell = range.getCell(j, i);         if (cell.getValue()) {           text += cell.getValue() + '\n';         }       }     }   }   if (text !== '') {     var originLanguage = e.formInput.origin;     var destinationLanguage = e.formInput.destination;     var translation = LanguageApp.translate(text, e.formInput.origin, e.formInput.destination);     return createSelectionCard(e, originLanguage, destinationLanguage, text, translation);   } }  /**  * Helper function to get the selected text of the active slide.  * @return {CardService.Card} The selected text.  */ function getSlidesSelection(e) {   var text = '';   var selection = SlidesApp.getActivePresentation().getSelection();   var selectionType = selection.getSelectionType();   if (selectionType === SlidesApp.SelectionType.TEXT) {     var textRange = selection.getTextRange();     if (textRange.asString() !== '') {       text += textRange.asString() + '\n';     }   }   if (text !== '') {     var originLanguage = e.formInput.origin;     var destinationLanguage = e.formInput.destination;     var translation = LanguageApp.translate(text, e.formInput.origin, e.formInput.destination);     return createSelectionCard(e, originLanguage, destinationLanguage, text, translation);   } }

{   "timeZone": "America/New_York",   "dependencies": {},   "exceptionLogging": "STACKDRIVER",   "oauthScopes": [     "https://www.googleapis.com/auth/documents.currentonly",     "https://www.googleapis.com/auth/spreadsheets.currentonly",     "https://www.googleapis.com/auth/presentations.currentonly"   ],   "runtimeVersion": "V8",   "addOns": {     "common": {       "name": "Translate",       "logoUrl": "https://www.gstatic.com/images/branding/product/1x/translate_24dp.png",       "layoutProperties": {         "primaryColor": "#2772ed"       },       "homepageTrigger": {         "runFunction": "onHomepage"       }     },     "docs" : {},     "slides" : {},     "sheets" : {}   } }