{"id":762,"date":"2020-05-07T17:56:38","date_gmt":"2020-05-07T09:56:38","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=762"},"modified":"2020-05-07T20:52:22","modified_gmt":"2020-05-07T12:52:22","slug":"importing-multiple-worksheets-and-or-excel-files-in-easy-excel-analysis","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/importing-multiple-worksheets-and-or-excel-files-in-easy-excel-analysis\/","title":{"rendered":"Importing multiple worksheets and\/or Excel files in Easy Excel Analysis"},"content":{"rendered":"<p>To import data from multiple worksheets and\/or Excel files in <a href=\"http:\/\/www.yohz.com\/ya_eea_overview.htm\">Easy Excel Analysis<\/a>, first set up the import settings for a single worksheet as described <a href=\"http:\/\/www.yohz.com\/blogs\/2020\/05\/07\/getting-started-with-easy-excel-analysis\/\">here<\/a>.<\/p>\n<p><strong>NOTE: The layout and format of the data in all the additional files and worksheets must be identical to that of the source worksheet.\u00a0<\/strong><\/p>\n<p>When you reach this page of the import wizard, you can then set up the additional import sources.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-754\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/eea_steps06.png\" alt=\"\" width=\"666\" height=\"588\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/eea_steps06.png 666w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/eea_steps06-300x265.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/eea_steps06-624x551.png 624w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><\/p>\n<p>To add a file, click on the <strong>Add<\/strong> button below the file list window.\u00a0 For each additional file that you want to import, select the option that best fits your needs.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-765\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01.png\" alt=\"\" width=\"650\" height=\"240\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01.png 650w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01-300x111.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01-624x230.png 624w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p>If you want to import data from all the worksheets in a single file, first set up the import settings for any one of the worksheets in that file.\u00a0 Then on this page, add that file again and select the <strong>Import from all worksheets<\/strong> option.\u00a0 <a href=\"http:\/\/www.yohz.com\/ya_eea_overview.htm\">Easy Excel Analysis<\/a> will not import from the same worksheet twice.<\/p>\n<p>If you need to be able to identify each data source and your worksheets do not contain any columns that identifies the source data, you can add additional columns on this page to help identify the data source.\u00a0 Click on the <strong>Add<\/strong> button below the additional columns list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-767\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01a.png\" alt=\"\" width=\"651\" height=\"189\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01a.png 651w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01a-300x87.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_01a-624x181.png 624w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/p>\n<p>On this page, enter the column name, type, length, and source of the column.\u00a0 There are several options available to use the filename or worksheet details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-766\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_02.png\" alt=\"\" width=\"567\" height=\"441\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_02.png 567w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/05\/multifiles_02-300x233.png 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/p>\n<p>Using an example file name of <strong>G:\\data\\Sales_Osaka_July2020.xlsx<\/strong>,<\/p>\n<ul>\n<li><strong>filename<\/strong> = <strong>Sales_Osaka_July2020<\/strong><\/li>\n<li><span style=\"font-size: 1rem;\"><strong>filename 1st value<\/strong> = <strong>Sales<\/strong><\/span><\/li>\n<li><span style=\"font-size: 1rem;\"><strong>filename 2nd value<\/strong> = <strong>Osaka<\/strong><\/span><\/li>\n<li><strong>filename 3rd value<\/strong> = <strong>July2020<\/strong><\/li>\n<\/ul>\n<p>The same extraction rules apply to worksheet names.\u00a0 Note that the separators can be a dash symbol (e.g. <strong>Sales-Osaka-July2020.xlsx<\/strong>), a comma (e.g. <strong>Sales,Osaka,July2020.xlsx<\/strong>), or a dot (e.g. <strong>Sales.Osaka.July2020.xlsx<\/strong>).\u00a0 You cannot mix separator symbols e.g. <strong>Sales-Osaka.July2020.xlsx<\/strong>.<\/p>\n<p>For further details, please refer to this topic in the <a href=\"https:\/\/www.yohz.com\/help\/easyexcelanalysis\/index.htm?importing_from_multiple_files_.htm\">help file<\/a>.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/importing-multiple-worksheets-and-or-excel-files-in-easy-excel-analysis\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/importing-multiple-worksheets-and-or-excel-files-in-easy-excel-analysis\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>To import data from multiple worksheets and\/or Excel files in Easy Excel Analysis, first set up the import settings for a single worksheet as described here. NOTE: The layout and format of the data in all the additional files and worksheets must be identical to that of the source worksheet.\u00a0 When you reach this page [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82],"tags":[83,106,105],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/762"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=762"}],"version-history":[{"count":4,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/762\/revisions"}],"predecessor-version":[{"id":776,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/762\/revisions\/776"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}