TRANSLATE(),将文本从一种语言翻译成另一种语言的函数。 DETECTLANGUAGE(),检测指定文本语言的函数。 TRANSLATE TRANSLATE 函数会将指定的文本使用Microsoft 翻译服务从一种语言翻译成另一种语言,支持 100 多种语言。 用法如下。 具体参数,TRANSLATE(text, [source language], [target language])。 text:要翻译的文本。
excel翻译函数 在Excel中，可以使用以下函数来进行中文翻译：1.翻译函数：使用GOOGLETRANSLATE函数可以进行中文翻译。语法如下：=GOOGLETRANSLATE(文本,"源语言","目标语言")其中，文本是要翻译的中文文本，源语言是文本的原始语言，目标语言是要翻译成的语言。function chineseTranslate(text)//在函数中使用API或其他工具...
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=" & ...
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="...
Text: Converts a number to text, using the ß (baht) currency format BASE Math and trigonometry: Converts a number into a text representation with the given radix (base) BESSELI Engineering: Returns the modified Bessel function In(x) BESSELJ Engineering: Returns the Bessel function Jn...
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=...
Use below VBA code as a substitute for translate function Function MyTranslate(TextToTranslate As String, Optional FromLanguage As String = "en", Optional ToLanguage As String = "fr") As String Dim dict As Object Dim translatedText As String ' Replace with your own translation dictionaries...
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. ...
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...
Moreover, recognizing ALL date formats is difficult: if you have a text value 02/11/2022, you have no way of knowing it is the 2nd of November (standard Australian date format) or the 11th of February (USA date format). If I can get the behaviour from the TEXT function that it has...