{"id":10772,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/chamar\/"},"modified":"2021-02-25T17:14:53","modified_gmt":"2021-02-25T17:14:53","slug":"call","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/call\/","title":{"rendered":"CHAMAR"},"content":{"rendered":"

A fun\u00e7\u00e3o CALL (CHAMAR em Portugu\u00eas) no Microsoft Excel \u00e9 uma ferramenta extremamente \u00fatil, que permite ao usu\u00e1rio invocar fun\u00e7\u00f5es personalizadas ou realizar c\u00e1lculos complexos atrav\u00e9s de uma interface program\u00e1vel, adequada para lidar com v\u00e1rias situa\u00e7\u00f5es complexas. Este guia explica seu uso, apresentando exemplos pr\u00e1ticos e explorando suas diversas aplica\u00e7\u00f5es.<\/p>\n

Sintaxe e Utiliza\u00e7\u00e3o<\/h2>\n

Embora a fun\u00e7\u00e3o CALL n\u00e3o esteja dispon\u00edvel nas Planilhas Google, os usu\u00e1rios podem criar scripts personalizados em Google Apps Script para atingir funcionalidades similares. No Microsoft Excel, particularmente em vers\u00f5es mais antigas e para chamadas de bibliotecas de v\u00ednculo din\u00e2mico (DLLs), a fun\u00e7\u00e3o CALL \u00e9 utilizada conforme o seguinte formato:<\/p>\n

 =CALL(\"biblioteca\", \"procedimento\", \"tipo de retorno\", argumento1, ..., argumentoN)<\/code> <\/pre>\n
    \n
  • biblioteca:<\/strong> O caminho para a DLL que cont\u00e9m a fun\u00e7\u00e3o desejada.<\/li>\n
  • procedimento:<\/strong> O nome da fun\u00e7\u00e3o espec\u00edfica dentro da DLL a ser executada.<\/li>\n
  • tipo de retorno:<\/strong> O tipo de dado que ser\u00e1 retornado pela fun\u00e7\u00e3o, como n\u00famero, texto, booleano, entre outros.<\/li>\n
  • argumento1, …, argumentoN:<\/strong> Os argumentos que ser\u00e3o passados para a fun\u00e7\u00e3o, cujo n\u00famero e tipo dependem da fun\u00e7\u00e3o espec\u00edfica que est\u00e1 sendo chamada.<\/li>\n<\/ul>\n
    Exemplos Pr\u00e1ticos de Uso<\/h2>\n
    Resolvendo Equa\u00e7\u00f5es Complexas<\/h2>\n
    Suponha que voc\u00ea frequentemente precise resolver uma equa\u00e7\u00e3o complexa e tenha \u00e0 disposi\u00e7\u00e3o uma DLL personalizada com uma fun\u00e7\u00e3o matem\u00e1tica chamada “comp_eq_solver”. Esta fun\u00e7\u00e3o calcula a solu\u00e7\u00e3o para a equa\u00e7\u00e3o com base nos par\u00e2metros fornecidos. A configura\u00e7\u00e3o seria da seguinte forma:<\/p>\n
     =CALL(\"C:\\\\Calc\\\\comp_eq_solver.dll\", \"solve\", \"double\", A2, B2, C2)<\/code> <\/pre>\n
    Onde A2, B2 e C2 s\u00e3o as c\u00e9lulas no Excel que cont\u00eam os coeficientes da equa\u00e7\u00e3o.<\/p>\n
    Integra\u00e7\u00e3o com C\u00f3digo Externo<\/h2>\n
    Em outra situa\u00e7\u00e3o, imagine que voc\u00ea esteja trabalhando com an\u00e1lise de dados e necessite executar uma fun\u00e7\u00e3o de normaliza\u00e7\u00e3o escrita em C++. Esta fun\u00e7\u00e3o est\u00e1 compilada em uma DLL. Voc\u00ea pode integrar esta fun\u00e7\u00e3o diretamente na sua planilha Excel da seguinte maneira:<\/p>\n
     =CALL(\"C:\\\\DataTools\\\\data_processing.dll\", \"normalize\", \"double\", D2:D100)<\/code> <\/pre>\n
    Neste exemplo, D2:D100 cont\u00e9m os dados a serem normalizados. A fun\u00e7\u00e3o “normalize” ajusta esses dados ao intervalo [0,1], e o resultado \u00e9 diretamente retornado e exibido na c\u00e9lula onde a fun\u00e7\u00e3o CALL est\u00e1 inserida.<\/p>\n
    Esses exemplos ilustram o qu\u00e3o ben\u00e9fica pode ser a fun\u00e7\u00e3o CALL para ampliar as funcionalidades do Excel com opera\u00e7\u00f5es personalizadas. Contudo, \u00e9 importante destacar que um conhecimento b\u00e1sico em programa\u00e7\u00e3o e familiaridade com as fun\u00e7\u00f5es dispon\u00edveis na DLL s\u00e3o essenciais para utilizar efetivamente a fun\u00e7\u00e3o CALL.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Chama um procedimento de uma biblioteca de liga\u00e7\u00e3o din\u00e2mica ou de um recurso de c\u00f3digo<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[445],"tags":[],"class_list":["post-10772","post","type-post","status-publish","format-standard","hentry","category-suplemento-e-automatizacao"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o CALL (CHAMAR) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CALL (CHAMAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/pt-pt\/call\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o CALL (CHAMAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CALL (CHAMAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/call\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:14:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o CALL (CHAMAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/call\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/call\/\",\"name\":\"Fun\u00e7\u00e3o CALL (CHAMAR) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:14:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CALL (CHAMAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/call\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/call\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/call\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Suplemento e Automatiza\u00e7\u00e3o\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/suplemento-e-automatizacao\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CHAMAR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o CALL (CHAMAR) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CALL (CHAMAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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:\/\/functiontranslator.com\/pt-pt\/call\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o CALL (CHAMAR) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CALL (CHAMAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/call\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:14:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o CALL (CHAMAR) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/call\/","url":"https:\/\/functiontranslator.com\/pt-pt\/call\/","name":"Fun\u00e7\u00e3o CALL (CHAMAR) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:14:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CALL (CHAMAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/call\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/call\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/call\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Suplemento e Automatiza\u00e7\u00e3o","item":"https:\/\/functiontranslator.com\/pt-pt\/suplemento-e-automatizacao\/"},{"@type":"ListItem","position":3,"name":"CHAMAR"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10772"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10772\/revisions"}],"predecessor-version":[{"id":25601,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10772\/revisions\/25601"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}