{"id":9777,"date":"2019-04-10T21:05:13","date_gmt":"2019-04-10T19:05:13","guid":{"rendered":"http:\/\/www.palentino.es\/blog\/?p=9777"},"modified":"2019-04-10T23:57:00","modified_gmt":"2019-04-10T21:57:00","slug":"complemento-traductor-de-idiomas-para-excel","status":"publish","type":"post","link":"https:\/\/www.palentino.es\/blog\/complemento-traductor-de-idiomas-para-excel\/","title":{"rendered":"Complemento traductor  de idiomas para Excel"},"content":{"rendered":"<div id=\"palen-1200960630\" class=\"palen-antes-del-contenido palen-entity-placement\"><div class=\"palen-adlabel\">Anuncios<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2815317153396146\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-2815317153396146\" \ndata-ad-slot=\"4593837716\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\r\n<p class=\"wp-block-paragraph\"><a href=\"http:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen.jpg\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"9784\" data-permalink=\"https:\/\/www.palentino.es\/blog\/complemento-traductor-de-idiomas-para-excel\/traduce-imagen\/\" data-orig-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen.jpg\" data-orig-size=\"644,174\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"traduce-imagen\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen.jpg\" class=\"aligncenter size-full wp-image-9784\" src=\"http:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen.jpg\" alt=\"\" width=\"644\" height=\"174\" srcset=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen.jpg 644w, https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen-300x81.jpg 300w\" sizes=\"auto, (max-width: 644px) 100vw, 644px\" \/><\/a><\/p>\r\n<p>&nbsp;<\/p>\r\n<p>En esta entrada os voy a dejar una herramienta bastante \u00fatil que he desarrollado a modo de complemento para Excel. En principio funciona desde la versi\u00f3n 2010 en adelante.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">La idea surgi\u00f3 viendo la caracter\u00edstica en la hoja de c\u00e1lculo de Google. Me result\u00f3 interesante y la he aplicado para Excel.<\/p>\r\n<p><!--more--><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Gracias al complemento podemos traducir cualquier fila a modo de funci\u00f3n de Excel al lenguaje que deseemos usando el traductor de google.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Esta funci\u00f3n de Excel se puede usar de la siguiente forma.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Sobre cualquier celda podremos usar la funci\u00f3n<\/p>\r\n<p><strong> = traduce (rango)<\/strong><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Permite traducir al ingl\u00e9s, la celda o rango seleccionado.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Sobre cualquier celda<\/p>\r\n<p><strong>= traduce (rango, idioma origen, idioma destino)<\/strong><\/p>\r\n<p>Ejemplo: = traduce (a1;&#8221;es&#8221;;&#8221;fr&#8221;)\u00a0<\/p>\r\n<p>El ejemplo superior traduce al franc\u00e9s la celda A1.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Traduce al idioma destino el rango seleccionado.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Espero que os sea de utilidad a todos los fan\u00e1ticos de Excel, ya que es una herramienta muy poderosa y utilizada en entornos empresariales.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><strong>Para poder instalar el complemento es necesario realizar los siguientes pasos:<\/strong><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">L\u00f3gicamente es necesario disponer de conexi\u00f3n a Internet para descargar las traducciones.<\/p>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"678\" data-attachment-id=\"9778\" data-permalink=\"https:\/\/www.palentino.es\/blog\/complemento-traductor-de-idiomas-para-excel\/complemento1\/\" data-orig-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento1.jpg\" data-orig-size=\"936,678\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"complemento1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento1.jpg\" class=\"wp-image-9778\" src=\"http:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento1.jpg\" alt=\"\" srcset=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento1.jpg 936w, https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento1-300x217.jpg 300w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/figure>\r\n\r\n\r\n\r\n<div class=\"wp-block-button is-style-squared\">Al pulsar el bot\u00f3n ir &#8230;<\/div>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"352\" height=\"393\" data-attachment-id=\"9781\" data-permalink=\"https:\/\/www.palentino.es\/blog\/complemento-traductor-de-idiomas-para-excel\/complemento2\/\" data-orig-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento2.jpg\" data-orig-size=\"352,393\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"complemento2\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento2.jpg\" class=\"wp-image-9781\" src=\"http:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento2.jpg\" alt=\"\" srcset=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento2.jpg 352w, https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento2-269x300.jpg 269w\" sizes=\"auto, (max-width: 352px) 100vw, 352px\" \/><\/figure>\r\n<p>Se pulsa en examinar y se coloca el complemento.<\/p>\r\n<p>Tambi\u00e9n se puede ubicar en la carpeta inferior.<\/p>\r\n<p>Esto permite que pueda ser usada la funci\u00f3n desde cualquier hoja de c\u00e1lculo Excel.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"946\" height=\"533\" data-attachment-id=\"9782\" data-permalink=\"https:\/\/www.palentino.es\/blog\/complemento-traductor-de-idiomas-para-excel\/complemento3\/\" data-orig-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento3.jpg\" data-orig-size=\"946,533\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"complemento3\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento3.jpg\" class=\"wp-image-9782\" src=\"http:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento3.jpg\" alt=\"\" srcset=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento3.jpg 946w, https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/complemento3-300x169.jpg 300w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/figure>\r\n<p>Esto es un ejemplo de uso:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"563\" height=\"604\" data-attachment-id=\"9783\" data-permalink=\"https:\/\/www.palentino.es\/blog\/complemento-traductor-de-idiomas-para-excel\/traduce1\/\" data-orig-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce1.jpg\" data-orig-size=\"563,604\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"traduce1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce1.jpg\" class=\"wp-image-9783\" src=\"http:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce1.jpg\" alt=\"\" srcset=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce1.jpg 563w, https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce1-280x300.jpg 280w\" sizes=\"auto, (max-width: 563px) 100vw, 563px\" \/><\/figure>\r\n\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"563\" height=\"604\" data-attachment-id=\"9785\" data-permalink=\"https:\/\/www.palentino.es\/blog\/complemento-traductor-de-idiomas-para-excel\/traduce-imagen-2\/\" data-orig-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen-2.jpg\" data-orig-size=\"563,604\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"traduce-imagen-2\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen-2.jpg\" class=\"wp-image-9785\" src=\"http:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen-2.jpg\" alt=\"\" srcset=\"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen-2.jpg 563w, https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen-2-280x300.jpg 280w\" sizes=\"auto, (max-width: 563px) 100vw, 563px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n<p>&nbsp;<\/p>\r\n<p style=\"text-align: center;\"><strong>Enlace descarga del complemento:<\/strong><\/p>\r\n<p style=\"text-align: center;\">\r\n\r\n<\/p>\r\n<h3 class=\"wp-block-button is-style-squared\" style=\"text-align: center;\"><strong><a class=\"wp-block-button__link\" href=\"http:\/\/www.palentino.es\/excel\/Traductor-Palentino.xlam\">Descarga del complemento<\/a><\/strong><\/h3>\r\n<div id=\"palen-3583043748\" class=\"palen-despues-del-contenido palen-entity-placement\"><div class=\"palen-adlabel\">Anuncios<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2815317153396146\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-2815317153396146\" \ndata-ad-slot=\"\" \ndata-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>&nbsp; En esta entrada os voy a dejar una herramienta bastante \u00fatil que he desarrollado a modo de complemento para Excel. En principio funciona desde la versi\u00f3n 2010 en adelante. La idea surgi\u00f3 viendo la caracter\u00edstica en la hoja de c\u00e1lculo de Google. Me result\u00f3 interesante y la he aplicado para Excel.<\/p>\n","protected":false},"author":1,"featured_media":9784,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1415],"tags":[],"class_list":["post-9777","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sin-categoria-es"],"views":6134,"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.palentino.es\/blog\/wp-content\/uploads\/2019\/04\/traduce-imagen.jpg","jetpack_shortlink":"https:\/\/wp.me\/p2ECph-2xH","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/9777","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/comments?post=9777"}],"version-history":[{"count":10,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/9777\/revisions"}],"predecessor-version":[{"id":9794,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/posts\/9777\/revisions\/9794"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/media\/9784"}],"wp:attachment":[{"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/media?parent=9777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/categories?post=9777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.palentino.es\/blog\/wp-json\/wp\/v2\/tags?post=9777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}