![]() ![]() This is done at the session level, meaning that restarting Excel will clear the cache. This makes the result of the translation a good candidate for caching.Ĭaching the result can save bandwidth, time, and costs, which is why the Windy.GoogleTranslate function caches results automatically. The translation of a word or phrase from one language into another is not something that’s going to change over time (at least not very often). In older versions of Excel, you can still make use of the function, but you’ll have to manually select the area that will hold the results and enter the formula using the Ctrl+Shift+Enter command. The function uses the dynamic arrays functionality of Excel 365 to return a table of results that spills to take up the required amount of space. Translating multiple cells from Spanish to various target languages The function will send all of them in bulk to the server and return an equally sized array containing translated texts. To avoid the performance penalty of sending many HTTP requests to google servers, you can pass in an array of values to translate. Windy.GoogleTranslate performs translation by invoking the Google Translate API. In spreadsheets, we tend to work with data in bulk, so it might often be the case that we need to translate many cells instead of just one. Some short phrases are valid in multiple languages, so it’s usually a good idea to specify the source language if you know it. This is because passing in the target language parameter is mandatory but passing in the source language parameter is optional – if you omit it, it will be auto-detected by the Google Translate API.įor example: =Windy.GoogleTranslate(B4, "de")Īuto detecting the source language works well for longer texts but it can be a guessing game for shorter texts (e.g., two short words). Note that the second parameter is the target language, and the third parameter is the source language ( not the other way around as you might have expected). ![]()
0 Comments
Leave a Reply. |