{"id":3102,"date":"2019-03-25T17:42:42","date_gmt":"2019-03-25T20:42:42","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/"},"modified":"2020-04-08T13:54:04","modified_gmt":"2020-04-08T16:54:04","slug":"automation-in-code-generation-lesson-2-reading-information-from-an-excel-file","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/","title":{"rendered":"Automation in code generation: Lesson 2 &#8211; Reading information from an Excel file."},"content":{"rendered":"<div align=\"justify\">\n<p>Auxiliary Excel spreadsheets are commonly used in code generation because of their functionalities, such as sequential copies of cells and sorting out of information, among others. The spreadsheets can be set up according to the user&#8217;s needs.<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%201.png\" alt=\"\" width=\"420\" height=\"267\" align=\"Baseline\" border=\"0\" \/><br \/>\n<span style=\"font-size: xx-small;\"><b>Fig. 2.1<\/b>: Auxiliary spreadsheet <\/span><\/div>\n<p>After the spreadsheet has been generated, the information can be read in several different ways. In this article, we recommend you use one of the following two suggestions:<\/p>\n<p><b>1.<\/b> Save the spreadsheet in <b>.csv<\/b> format. Then, use FileSystemObject&#8217;s methods to read the file via scripts. To do so, follow the procedures from <a href=\"http:\/\/kb.elipse.com.br\/pt-br\/questions\/1781\/KB-12658%3A+Reading%7B47%7DWriting+TXT+files+with+E3.\" target=\"_blank\" rel=\"noopener noreferrer\">KB-12658: Reading\/Writing TXT files with E3<\/a>. The procedures from that article also apply to <b>.csv<\/b> files.<\/p>\n<p>or<\/p>\n<p><b>2.<\/b> Use Microsoft Access to import the spreadsheet from Excel and generate a new table in the database. The following wizard can be used to help in this procedure:<\/p>\n<div align=\"center\">\n<p><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%202.png\" alt=\"\" width=\"380\" height=\"252\" align=\"Baseline\" border=\"0\" \/><\/p>\n<p><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%203.png\" alt=\"\" width=\"500\" height=\"370\" align=\"Baseline\" border=\"0\" \/><\/p>\n<p><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%204.png\" alt=\"\" width=\"496\" height=\"352\" align=\"Baseline\" border=\"0\" \/><\/p>\n<p><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%205.png\" alt=\"\" width=\"495\" height=\"351\" align=\"Baseline\" border=\"0\" \/><\/p>\n<p><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%206.png\" alt=\"\" width=\"499\" height=\"354\" align=\"Baseline\" border=\"0\" \/><\/p>\n<p><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%207.png\" alt=\"\" width=\"499\" height=\"354\" align=\"Baseline\" border=\"0\" \/><\/p>\n<p><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%208.png\" alt=\"\" width=\"499\" height=\"354\" align=\"Baseline\" border=\"0\" \/><\/p>\n<p><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%209.png\" alt=\"\" width=\"495\" height=\"366\" align=\"Baseline\" border=\"0\" \/><\/p>\n<\/div>\n<p>After this, set up a Database and create a query in the application, pointing to the imported table.<\/p>\n<p>Now, you will only need to use ADORecordSet&#8217;s properties and methods to manipulate the records in the table. To do so, we recommend reading the article <a href=\"http:\/\/kb.elipse.com.br\/pt-br\/questions\/2114\/Basic+VBScript+for+Elipse+E3%3A+Lesson+7+-+GetADORecordSet\" target=\"_blank\" rel=\"noopener noreferrer\">Basic VBScript for Elipse E3: Lesson 7 &#8211; GetADORecordSet<\/a>.<\/p>\n<\/div>\n<h3>Related articles<\/h3>\n<hr \/>\n<ul>\n<li><a href=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-introduction\/\">Automation in code generation: Introduction.<\/a><\/li>\n<li><a href=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-1-working-with-vectors\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automation in code generation: Lesson 1 \u2013 Working with vectors.<\/a><\/li>\n<li><a href=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automation in code generation: Lesson 2 \u2013 Reading information from an Excel file.<\/a><\/li>\n<li><a href=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-3-changing-a-string-into-a-vector\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automation in code generation: Lesson 3 \u2013 Changing a string into a vector.<\/a><\/li>\n<li><a href=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-4-scanning-specific-objects-in-a-location\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automation in code generation: Lesson 4 \u2013 Scanning specific objects in a location.<\/a><\/li>\n<li><a href=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-5-adding-objects-via-scripts\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automation in code generation: Lesson 5 \u2013 Adding objects via scripts.<\/a><\/li>\n<li><a href=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-6-checking-for-preexisting-objects\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automation in code generation: Lesson 6 \u2013 Checking for pre-existing objects.<\/a><\/li>\n<li><a href=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-7-events-for-script-execution\/\" target=\"_blank\" rel=\"noopener noreferrer\">Automation in code generation: Lesson 7 \u2013 Events for script execution.<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Auxiliary Excel spreadsheets are commonly used in code generation because of their functionalities, such as sequential copies of cells and sorting out of information, among others. The spreadsheets can be&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[763,825],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Automation in code generation: Lesson 2 - Automation in code generation: Lesson 2 - Reading information from an Excel file.[:] - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automation in code generation: Lesson 2 - Reading information from an Excel file.\" \/>\n<meta property=\"og:description\" content=\"Auxiliary Excel spreadsheets are commonly used in code generation because of their functionalities, such as sequential copies of cells and sorting out of information, among others. The spreadsheets can be&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:42:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-08T16:54:04+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%201.png\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"Automation in code generation: Lesson 2 &#8211; Reading information from an Excel file.\",\"datePublished\":\"2019-03-25T20:42:42+00:00\",\"dateModified\":\"2020-04-08T16:54:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/\"},\"wordCount\":481,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Scripts\",\"Elipse Power\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/\",\"name\":\"[:pt]Automation in code generation: Lesson 2 - Reading information from an Excel file.[:en]Automation in code generation: Lesson 2 - Reading information from an Excel file.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:42:42+00:00\",\"dateModified\":\"2020-04-08T16:54:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automation in code generation: Lesson 2 &#8211; Reading information from an Excel file.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automation in code generation: Lesson 2 - Automation in code generation: Lesson 2 - Reading information from an Excel file.[:] - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Automation in code generation: Lesson 2 - Reading information from an Excel file.[:en]Automation in code generation: Lesson 2 - Reading information from an Excel file.[:] - Elipse Knowledgebase","og_description":"Auxiliary Excel spreadsheets are commonly used in code generation because of their functionalities, such as sequential copies of cells and sorting out of information, among others. The spreadsheets can be&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:42:42+00:00","article_modified_time":"2020-04-08T16:54:04+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4783\/Figura%201.png"}],"author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"Automation in code generation: Lesson 2 &#8211; Reading information from an Excel file.","datePublished":"2019-03-25T20:42:42+00:00","dateModified":"2020-04-08T16:54:04+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/"},"wordCount":481,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Scripts","Elipse Power"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/","url":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/","name":"[:pt]Automation in code generation: Lesson 2 - Reading information from an Excel file.[:en]Automation in code generation: Lesson 2 - Reading information from an Excel file.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:42:42+00:00","dateModified":"2020-04-08T16:54:04+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/automation-in-code-generation-lesson-2-reading-information-from-an-excel-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Automation in code generation: Lesson 2 &#8211; Reading information from an Excel file."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3102"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3102"}],"version-history":[{"count":3,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3102\/revisions"}],"predecessor-version":[{"id":10521,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3102\/revisions\/10521"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}