{"id":455,"date":"2023-10-27T22:57:31","date_gmt":"2023-10-27T22:57:31","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/"},"modified":"2023-12-25T10:31:41","modified_gmt":"2023-12-25T10:31:41","slug":"laboratorio-de-guiones","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/","title":{"rendered":"\u00bfc\u00f3mo utilizar script lab en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1678492270\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Con Script Lab puede utilizar la API de JavaScript de Office. Para obtener el \u201cScript Lab\u201d, debe instalar el complemento script lab desde la pesta\u00f1a Insertar \u21e2 Obtener complementos \u21e2 Script Lab. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88977\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"laboratorio-de-script-en-excel\" width=\"686\" height=\"393\"><\/figure>\n<\/div>\n<p> Lo siguiente que debe hacer es agregar la pesta\u00f1a Script Lab a la cinta. Y para eso, vaya a la pesta\u00f1a Archivo \u21e2 Opciones \u21e2 Personalizar cinta \u21e2 Marca de verificaci\u00f3n \u21e2 Script Lab. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88978\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-ajouter-un-laboratoire-de-script-sur-le-ruban.png\" sizes=\"auto, \" srcset=\"\" alt=\"agregar-script-lab-on-ribbon\" width=\"692\" height=\"334\"><\/figure>\n<\/div>\n<p> Regrese a su hoja de c\u00e1lculo y haga clic en el bot\u00f3n \u00abC\u00f3digo\u00bb en la pesta\u00f1a Script Lab. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88979\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-clics-sur-le-code-de-longlet-du-laboratoire-de-script.png\" sizes=\"auto, \" srcset=\"\" alt=\"haga clic en c\u00f3digo desde la pesta\u00f1a script-lab\" width=\"710\" height=\"161\"><\/figure>\n<\/div>\n<p> Cuando hace clic en el bot\u00f3n de c\u00f3digo, ver\u00e1 un panel en el lado derecho de la ventana de Excel. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88980\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-volet-sur-le-cote-droit.png\" sizes=\"auto, \" srcset=\"\" alt=\"persiana del lado derecho\" width=\"355\" height=\"433\"><\/figure>\n<\/div>\n<p> Con Script Lab, puede usar JavaScript para escribir c\u00f3digos y crear una funci\u00f3n personalizada en Excel. Ahora haga clic en el bot\u00f3n de men\u00fa y luego haga clic en el bot\u00f3n Nuevo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88981\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-avec-script-lab-utiliser-javascript-pour-ecrire-des-codes.png\" sizes=\"auto, \" srcset=\"\" alt=\"con-script-lab-use-javascript-para-escribir-c\u00f3digos\" width=\"369\" height=\"121\"><\/figure>\n<\/div>\n<p> A continuaci\u00f3n, elimine el c\u00f3digo que ya est\u00e1 presente en las tres pesta\u00f1as, Script, HTML y CSS. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88982\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-supprimer-les-codes-deja-presents.png\" sizes=\"auto, \" srcset=\"\" alt=\"borrar-los-c\u00f3digos-que-ya-hay\" width=\"644\" height=\"232\"><\/figure>\n<\/div>\n<p> Cuando pegas el c\u00f3digo, la pesta\u00f1a HTML y CSS desaparece porque este c\u00f3digo crea una funci\u00f3n. Y esta funci\u00f3n te ayuda a calcular el CUADRADO DE UN N\u00daMERO.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-typescript\" lang=\"typescript\">\/** * calculates the square root of the number. * @customfunction *\/ function getsquare(num) { return Math.pow(num, 2); }<\/code><\/pre>\n<p> Desde aqu\u00ed, debe guardar esta funci\u00f3n en su aplicaci\u00f3n Excel. Primero, haga clic en el bot\u00f3n \u00abRegistrarse\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88983\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-7-registres-avec-application-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-guardar-con-aplicaci\u00f3n-excel\" width=\"578\" height=\"379\"><\/figure>\n<\/div>\n<p> Cuando hace clic en el bot\u00f3n Guardar, muestra \u00abLas siguientes funciones se han guardado correctamente\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88984\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-montre-les-fonctions-enregistrees-avec-succes.png\" sizes=\"auto, \" srcset=\"\" alt=\"funciones-del-reloj-registradas-exitosamente\" width=\"646\" height=\"294\"><\/figure>\n<\/div>\n<p> Ahora regrese a la hoja de c\u00e1lculo e ingrese un n\u00famero en una celda. Por ejemplo, ingrese \u201c=ScriptLab\u201d en otra celda y seleccione la funci\u00f3n GETSQUARE. Consulte la celda con el n\u00famero. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88985\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-entrez-un-nombre-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"ingresa un n\u00famero en la celda\" width=\"540\" height=\"334\"><\/figure>\n<\/div>\n<p> Al final, presione Enter para obtener el resultado. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88986\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-appuyez-sur-Entree-pour-obtenir-le-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"presione enter para obtener el resultado\" width=\"569\" height=\"370\"><\/figure>\n<\/div>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/avance-de-excel\/\">Tutoriales avanzados de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/excel-por-defecto-en-mac\/\">Hacer que Excel sea el predeterminado en Mac<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/modo-seguro-de-excel\/\">Abra Excel en modo seguro<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/vaciar-el-cache\/\">Borrar cach\u00e9 en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/autocorreccion\/\">Utilice la autocorrecci\u00f3n en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Con Script Lab puede utilizar la API de JavaScript de Office. Para obtener el \u201cScript Lab\u201d, debe instalar el complemento script lab desde la pesta\u00f1a Insertar \u21e2 Obtener complementos \u21e2 Script Lab. Lo siguiente que debe hacer es agregar la pesta\u00f1a Script Lab a la cinta. Y para eso, vaya a la pesta\u00f1a Archivo \u21e2 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-455","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo utilizar script lab en excel?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar script lab en excel?\" \/>\n<meta property=\"og:description\" content=\"Con Script Lab puede utilizar la API de JavaScript de Office. Para obtener el \u201cScript Lab\u201d, debe instalar el complemento script lab desde la pesta\u00f1a Insertar \u21e2 Obtener complementos \u21e2 Script Lab. Lo siguiente que debe hacer es agregar la pesta\u00f1a Script Lab a la cinta. Y para eso, vaya a la pesta\u00f1a Archivo \u21e2 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/\",\"name\":\"\u00bfc\u00f3mo utilizar script lab en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\",\"datePublished\":\"2023-10-27T22:57:31+00:00\",\"dateModified\":\"2023-12-25T10:31:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar script lab en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar script lab en excel?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar script lab en excel?","og_description":"Con Script Lab puede utilizar la API de JavaScript de Office. Para obtener el \u201cScript Lab\u201d, debe instalar el complemento script lab desde la pesta\u00f1a Insertar \u21e2 Obtener complementos \u21e2 Script Lab. Lo siguiente que debe hacer es agregar la pesta\u00f1a Script Lab a la cinta. Y para eso, vaya a la pesta\u00f1a Archivo \u21e2 [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/","url":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/","name":"\u00bfc\u00f3mo utilizar script lab en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png","datePublished":"2023-10-27T22:57:31+00:00","dateModified":"2023-12-25T10:31:41+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-laboratoire-de-script-dans-Excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/laboratorio-de-guiones\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar script lab en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=455"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/455\/revisions"}],"predecessor-version":[{"id":1376,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/455\/revisions\/1376"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}