{"id":990,"date":"2018-08-11T13:20:54","date_gmt":"2018-08-11T13:20:54","guid":{"rendered":"https:\/\/labdeck.com\/?page_id=990"},"modified":"2019-03-17T17:27:24","modified_gmt":"2019-03-17T17:27:24","slug":"excel-interface","status":"publish","type":"page","link":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/","title":{"rendered":"Excel Interface"},"content":{"rendered":"<h2>Excel with MatDeck<\/h2>\n<p>MatDeck provides a wide range of useful functions and GUI objects that can help you to implement and use data from your Excel spreadsheets in MatDeck documents or help you export and save calculation data from MatDeck documents in Excel files. This way, Excel is incorporated in MatDeck to provide an easy to use, but powerful tool that can help you accomplish every task you can imagine. A traditional import and export data to and from Excel is available plus the option to in real time share data with Excel files. The same rules apply to open source LibreOffice \u2013 Calc spreadsheet software.<\/p>\n<p>There are two types of Excel interfacing:<\/p>\n<ul>\n<li>Excel read and excel write &#8211; IO functions with arguments<\/li>\n<li>Excel Import and Export &#8211; GUI objects with properties<\/li>\n<\/ul>\n<p><strong>Excel read function<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1483\" src=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-read.png\" alt=\"excel read function\" width=\"1078\" height=\"336\" srcset=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-read.png 1078w, https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-read-768x239.png 768w\" sizes=\"auto, (max-width: 1078px) 100vw, 1078px\" \/><\/p>\n<p><strong>Excel write function<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1482\" src=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-write.png\" alt=\"excel write function\" width=\"1142\" height=\"318\" srcset=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-write.png 1142w, https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-write-768x214.png 768w\" sizes=\"auto, (max-width: 1142px) 100vw, 1142px\" \/><\/p>\n<p><strong>Excel export graphical interface<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1484\" src=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-export.png\" alt=\"Excel export graphical interface\" width=\"1054\" height=\"239\" srcset=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-export.png 1054w, https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-export-768x174.png 768w\" sizes=\"auto, (max-width: 1054px) 100vw, 1054px\" \/><\/p>\n<p><strong>Excel import graphical interface<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1481\" src=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-import.png\" alt=\"Excel import graphical interface\" width=\"1139\" height=\"880\" srcset=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-import.png 1139w, https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-import-768x593.png 768w\" sizes=\"auto, (max-width: 1139px) 100vw, 1139px\" \/><\/p>\n<p>Functions from this group are described in detail in the following document: <a href=\"\/examples\/excel\/excel-in-matdeck.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Excel in MatDeck.<\/a><\/p>\n<h3>Excel examples:<\/h3>\n<ul>\n<li><a href=\"\/examples\/excel\/excel-export-import.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Excel export import<\/a><\/li>\n<li><a href=\"\/examples\/excel\/excel-export-import-io.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Excel export import &#8211; IO<\/a><\/li>\n<li><a href=\"\/examples\/excel\/excel-in-matdeck.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Excel in MatDeck<\/a><\/li>\n<li><a href=\"\/examples\/excel\/ppg-xls-database.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">PPG XLS database<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel with MatDeck MatDeck provides a wide range of useful functions and GUI objects that can help you to implement and use data from your Excel spreadsheets in MatDeck documents or help you export and save calculation data from MatDeck documents in Excel files. This way, Excel is incorporated in MatDeck to provide an easy &#8230; <a title=\"Excel Interface\" class=\"read-more\" href=\"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/\" aria-label=\"Read more about Excel Interface\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":960,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-990","page","type-page","status-publish"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Interface - LabDeck<\/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:\/\/labdeck.com\/data-acquisition\/excel-interface\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Interface - LabDeck\" \/>\n<meta property=\"og:description\" content=\"Excel with MatDeck MatDeck provides a wide range of useful functions and GUI objects that can help you to implement and use data from your Excel spreadsheets in MatDeck documents or help you export and save calculation data from MatDeck documents in Excel files. This way, Excel is incorporated in MatDeck to provide an easy ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/\" \/>\n<meta property=\"og:site_name\" content=\"LabDeck\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-17T17:27:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-read.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/excel-interface\\\/\",\"url\":\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/excel-interface\\\/\",\"name\":\"Excel Interface - LabDeck\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/labdeck.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/excel-interface\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/excel-interface\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/labdeck.com\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/excel-read.png\",\"datePublished\":\"2018-08-11T13:20:54+00:00\",\"dateModified\":\"2019-03-17T17:27:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/excel-interface\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/excel-interface\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/excel-interface\\\/#primaryimage\",\"url\":\"https:\\\/\\\/labdeck.com\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/excel-read.png\",\"contentUrl\":\"https:\\\/\\\/labdeck.com\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/excel-read.png\",\"width\":1078,\"height\":336,\"caption\":\"excel read function\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/excel-interface\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/labdeck.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Acquisition\",\"item\":\"https:\\\/\\\/labdeck.com\\\/data-acquisition\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Interface\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/labdeck.com\\\/#website\",\"url\":\"https:\\\/\\\/labdeck.com\\\/\",\"name\":\"LabDeck\",\"description\":\"Innovative computing environment for Science, Engineering and Mathematics\",\"publisher\":{\"@id\":\"https:\\\/\\\/labdeck.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/labdeck.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/labdeck.com\\\/#organization\",\"name\":\"Labdeck\",\"url\":\"https:\\\/\\\/labdeck.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/labdeck.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/labdeck.com\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/labdeck-logo.png\",\"contentUrl\":\"https:\\\/\\\/labdeck.com\\\/wp-content\\\/uploads\\\/2017\\\/01\\\/labdeck-logo.png\",\"width\":512,\"height\":512,\"caption\":\"Labdeck\"},\"image\":{\"@id\":\"https:\\\/\\\/labdeck.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCmp8LfvQvQ1556jqVwKTA7w\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Interface - LabDeck","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:\/\/labdeck.com\/data-acquisition\/excel-interface\/","og_locale":"en_GB","og_type":"article","og_title":"Excel Interface - LabDeck","og_description":"Excel with MatDeck MatDeck provides a wide range of useful functions and GUI objects that can help you to implement and use data from your Excel spreadsheets in MatDeck documents or help you export and save calculation data from MatDeck documents in Excel files. This way, Excel is incorporated in MatDeck to provide an easy ... Read more","og_url":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/","og_site_name":"LabDeck","article_modified_time":"2019-03-17T17:27:24+00:00","og_image":[{"url":"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-read.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/","url":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/","name":"Excel Interface - LabDeck","isPartOf":{"@id":"https:\/\/labdeck.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/#primaryimage"},"image":{"@id":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/#primaryimage"},"thumbnailUrl":"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-read.png","datePublished":"2018-08-11T13:20:54+00:00","dateModified":"2019-03-17T17:27:24+00:00","breadcrumb":{"@id":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/labdeck.com\/data-acquisition\/excel-interface\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/#primaryimage","url":"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-read.png","contentUrl":"https:\/\/labdeck.com\/wp-content\/uploads\/2019\/01\/excel-read.png","width":1078,"height":336,"caption":"excel read function"},{"@type":"BreadcrumbList","@id":"https:\/\/labdeck.com\/data-acquisition\/excel-interface\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/labdeck.com\/"},{"@type":"ListItem","position":2,"name":"Data Acquisition","item":"https:\/\/labdeck.com\/data-acquisition\/"},{"@type":"ListItem","position":3,"name":"Excel Interface"}]},{"@type":"WebSite","@id":"https:\/\/labdeck.com\/#website","url":"https:\/\/labdeck.com\/","name":"LabDeck","description":"Innovative computing environment for Science, Engineering and Mathematics","publisher":{"@id":"https:\/\/labdeck.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/labdeck.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/labdeck.com\/#organization","name":"Labdeck","url":"https:\/\/labdeck.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/labdeck.com\/#\/schema\/logo\/image\/","url":"https:\/\/labdeck.com\/wp-content\/uploads\/2017\/01\/labdeck-logo.png","contentUrl":"https:\/\/labdeck.com\/wp-content\/uploads\/2017\/01\/labdeck-logo.png","width":512,"height":512,"caption":"Labdeck"},"image":{"@id":"https:\/\/labdeck.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.youtube.com\/channel\/UCmp8LfvQvQ1556jqVwKTA7w"]}]}},"_links":{"self":[{"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/pages\/990","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/comments?post=990"}],"version-history":[{"count":9,"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/pages\/990\/revisions"}],"predecessor-version":[{"id":1739,"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/pages\/990\/revisions\/1739"}],"up":[{"embeddable":true,"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/pages\/960"}],"wp:attachment":[{"href":"https:\/\/labdeck.com\/wp-json\/wp\/v2\/media?parent=990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}