{"id":301,"date":"2015-02-02T19:43:16","date_gmt":"2015-02-02T18:43:16","guid":{"rendered":"http:\/\/spss.wp.xpkode.com\/?p=301"},"modified":"2015-02-02T20:49:35","modified_gmt":"2015-02-02T19:49:35","slug":"como-abrir-um-ficheiro-de-excel-no-spss","status":"publish","type":"post","link":"http:\/\/www.dicas-spss.com\/?p=301","title":{"rendered":"Como abrir um ficheiro de Excel no SPSS"},"content":{"rendered":"<p>O SPSS pode abrir ficheiros de dados provenienetes de outras aplica\u00e7\u00f5es. Por exemplo do Excel, ficheiros de texto ou bases de dados MsAccess ou outras.<\/p>\n<p>No menu, pedir para abrir um ficheiro e no tipo de arquivo, selecionar Excel.<\/p>\n<p><a href=\"http:\/\/spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-6.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-302\" src=\"http:\/\/spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-6-300x206.jpg\" alt=\"fig-2-6\" width=\"300\" height=\"206\" srcset=\"http:\/\/dicas-spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-6-300x206.jpg 300w, http:\/\/dicas-spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-6.jpg 581w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Premir o bot\u00e3o &#8220;Abrir&#8221; e na janela seguinte, premir OK, ou ent\u00e3o, no &#8220;Intervalo&#8221;, indicar o conjunto de c\u00e9lulas que pretende importar.<\/p>\n<p><a href=\"http:\/\/spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-7.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-303\" src=\"http:\/\/spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-7-300x137.jpg\" alt=\"fig-2-7\" width=\"300\" height=\"137\" srcset=\"http:\/\/dicas-spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-7-300x137.jpg 300w, http:\/\/dicas-spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-7.jpg 486w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>No caso da primeira linha do ficheiro Excel conter os nomes da vari\u00e1veis, marcar essa op\u00e7\u00e3o na caixa de di\u00e1logo. Depois premir OK.<\/p>\n<p><a href=\"http:\/\/spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-9.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-304\" src=\"http:\/\/spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-9-300x137.jpg\" alt=\"fig-2-9\" width=\"300\" height=\"137\" srcset=\"http:\/\/dicas-spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-9-300x137.jpg 300w, http:\/\/dicas-spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-9.jpg 486w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>E os dados do ficheiro Excel s\u00e3o importados para o SPSS.<\/p>\n<p><a href=\"http:\/\/spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-305\" src=\"http:\/\/spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-10-300x67.jpg\" alt=\"fig-2-10\" width=\"300\" height=\"67\" srcset=\"http:\/\/dicas-spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-10-300x67.jpg 300w, http:\/\/dicas-spss.wp.w3.pt\/wp-content\/uploads\/sites\/4\/2015\/02\/fig-2-10.jpg 589w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>O SPSS pode abrir ficheiros de dados provenienetes de outras aplica\u00e7\u00f5es. Por exemplo do Excel, ficheiros de texto ou bases de dados MsAccess ou outras. No menu, pedir para abrir um ficheiro e no tipo de arquivo, selecionar Excel. Premir o bot\u00e3o &#8220;Abrir&#8221; e na janela seguinte, premir OK, ou ent\u00e3o, no &#8220;Intervalo&#8221;, indicar o [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[],"_links":{"self":[{"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=\/wp\/v2\/posts\/301"}],"collection":[{"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=301"}],"version-history":[{"count":1,"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions"}],"predecessor-version":[{"id":306,"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions\/306"}],"wp:attachment":[{"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dicas-spss.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}