TRANSLATE(),将文本从一种语言翻译成另一种语言的函数。 DETECTLANGUAGE(),检测指定文本语言的函数。 TRANSLATE TRANSLATE 函数会将指定的文本使用 Microsoft 翻译服务从一种语言翻译成另一种语言,支持 100 多种语言。 用法如下。 具体参数,TRANSLATE(text, [source language], [target language])。 text:要翻译的文...
1.翻译函数:使用GOOGLETRANSLATE函数可以进行中文翻译。语法如下: =GOOGLETRANSLATE(文本,"源语言","目标语言") 其中,文本是要翻译的中文文本,源语言是文本的原始语言,目标语言是要翻译成的语言。 function chineseTranslate(text) //在函数中使用API或其他工具进行中文翻译 //返回翻译后的文本 } 然后可以在Excel中使...
Function Translate(SrcText)Dim arrSrc As VariantDim arrDst As VariantDim i As Integer arrSrc = Array("一", "二", "三")arrDst = Array("one", "two", "three") For i = LBound(arrSrc) To UBound(arrSrc) 'LBound获取数组下限,UBoun...
End Function Private Function getURL(txt, lang) ' tlang = "zh-CHS,en,fr,de,ko,ja,zh-CHT" URL = "http://api.microsofttranslator.com/V2/Ajax.svc/Translate?oncomplete=&AppId=" _ & "DF9E54CA96F73F2E289AEC059F407DE8295A6515&from=&to=" & Split(tlang, ",")(lang) & "&text="...
Thank You so much !!! Your program work great. Itranslate thousends of product item descriptions every day.Your tool saves hours of work every day.Again thank you,Karl (Karl Behrens, Cologne, GER) Excel-Text-Translatoris a professional Excel AddIn that allows you to translate text in Excel...
Enables users toeasily translate full formulasto their native language. Supports all of Excel's localized languages and functions, with 80 languages, and 800 functions. Provides anefficient way to search for any part of a function's namein both languages selected. ...
I know the wait is no fun when there are cool new features coming out, but you'll get them soon enough. Thanks for your comment. The goal in this case is to specifically evaluate the Translate function that is supposedly released in Excel. I am trying to understand why it is not avail...
I know the wait is no fun when there are cool new features coming out, but you'll get them soon enough. Thanks for your comment. The goal in this case is to specifically evaluate the Translate function that is supposedly released in Excel. I am trying to understand why it is not avail...
excel是一款很经典的数据分析的工具，里面包含了很多内置函数，但实际情况有时却复杂得多，而excel的宏...
translatedText = ParseResponse(responseText) ' 解析API响应获取翻译后的文本 ' 将翻译后的文本写入相邻单元格 cell.Offset(0, 1).Value = translatedText Next cell End Sub Function HttpGet(url As String) As String ' 实现HTTP GET请求的代码(可使用XMLHttpRequest或其他库) End Function Function ParseResp...