{"id":20,"date":"2017-06-01T06:03:05","date_gmt":"2017-06-01T06:03:05","guid":{"rendered":"http:\/\/namauro.knight.domains\/samarnauzs\/?p=20"},"modified":"2017-06-01T06:05:24","modified_gmt":"2017-06-01T06:05:24","slug":"20","status":"publish","type":"post","link":"https:\/\/namauro.knight.domains\/samarnauzs\/2017\/06\/01\/20\/","title":{"rendered":"Reading Data from Excel to Produce a Graph in labVIEW"},"content":{"rendered":"<p>Shown below is the block diagram<\/p>\n<p><img loading=\"lazy\" class=\" wp-image-22 alignleft\" src=\"http:\/\/namauro.knight.domains\/samarnauzs\/wp-content\/uploads\/sites\/22\/2017\/06\/BlockDiagram_XYgraph-300x212.png\" alt=\"\" width=\"389\" height=\"275\" srcset=\"https:\/\/namauro.knight.domains\/samarnauzs\/wp-content\/uploads\/sites\/22\/2017\/06\/BlockDiagram_XYgraph-300x212.png 300w, https:\/\/namauro.knight.domains\/samarnauzs\/wp-content\/uploads\/sites\/22\/2017\/06\/BlockDiagram_XYgraph.png 441w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>The Path block is just a constant file path defined by the user in the front end. In this case, the file is in comma-delimited format produced by excel.<\/p>\n<p>Following the &#8220;wire&#8221;, we come upon the &#8220;Read Delimited Spreadsheet&#8221; VI, which can read delimited spreadsheets and create a 2D array out of them.<\/p>\n<p>Next, the 2D array gets converted into a &#8220;columns are channels, rows are rows&#8221; format. This is needed so the &#8220;Build XY Graph&#8221; VI can read each array.<\/p>\n<p>The converted array is put into either the x input or y input.<\/p>\n<p>The output of this process is show below.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-medium wp-image-25\" src=\"http:\/\/namauro.knight.domains\/samarnauzs\/wp-content\/uploads\/sites\/22\/2017\/06\/XYsinGraph-300x270.png\" alt=\"\" width=\"300\" height=\"270\" srcset=\"https:\/\/namauro.knight.domains\/samarnauzs\/wp-content\/uploads\/sites\/22\/2017\/06\/XYsinGraph-300x270.png 300w, https:\/\/namauro.knight.domains\/samarnauzs\/wp-content\/uploads\/sites\/22\/2017\/06\/XYsinGraph.png 379w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Shown below is the block diagram &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; The Path block is just a constant file path defined by the user in the front end. In this case, the file is in comma-delimited format produced by excel. Following the &#8220;wire&#8221;, we come upon the &#8220;Read Delimited Spreadsheet&#8221; VI,<\/p>\n<div class=\"read-more\"><a href=\"https:\/\/namauro.knight.domains\/samarnauzs\/2017\/06\/01\/20\/\">Read More<\/a><\/div>\n","protected":false},"author":60,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,5],"tags":[],"_links":{"self":[{"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/posts\/20"}],"collection":[{"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/users\/60"}],"replies":[{"embeddable":true,"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/comments?post=20"}],"version-history":[{"count":4,"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/posts\/20\/revisions"}],"predecessor-version":[{"id":29,"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/posts\/20\/revisions\/29"}],"wp:attachment":[{"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/media?parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/categories?post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namauro.knight.domains\/samarnauzs\/wp-json\/wp\/v2\/tags?post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}