{"id":192835,"date":"2023-07-03T10:32:06","date_gmt":"2023-07-03T14:32:06","guid":{"rendered":"https:\/\/ibkrcampus.com\/?p=192835"},"modified":"2023-07-03T10:32:47","modified_gmt":"2023-07-03T14:32:47","slug":"how-to-use-obba-for-a-link-between-java-and-excel","status":"publish","type":"post","link":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/","title":{"rendered":"How to Use Obba for a Link between Java and Excel"},"content":{"rendered":"\n<p>This post shows the step by step guide on how to use Obba. Obba is a Java object handler for excel spreadsheet applications. Obba documentations are very good for the intermediate or advanced level. For the beginner or novice, we provide some useful examples for more clear understanding.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-introduction\"><br>Introduction<\/h3>\n\n\n\n<p>We try to create objects for Java classes and call its member functions in Excel using Obba.<\/p>\n\n\n\n<p>For this purpose, 1) we make a sample Java code and export it as a jar file and 2) use this jar file in Excel through Obba.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Installing Obba<\/h3>\n\n\n\n<p>If Obba was not installed previously, download and install it with default setting.<\/p>\n\n\n\n<p><a href=\"https:\/\/obba.info\/\">obba.info (https:\/\/obba.info\/)<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Sample Java Class<\/h3>\n\n\n\n<p>At first, we make a Java file which has a class definition with its members and member functions. The object generated from this class is used in Excel through Obba.<\/p>\n\n\n\n<p>For this end, open Eclipse, create new Java Project, and add new Class. Names for our project and class are&nbsp;aObba&nbsp;and&nbsp;CObba&nbsp;respectively. Of course, you can change these names to your favorite names.<\/p>\n\n\n\n<p>For the clear understanding, it doesn&#8217;t suffice to treat with only simple calculations. So we consider not only simple scalar examples but also vector or array related examples.<\/p>\n\n\n\n<p>We write the following sample code to CObba.java file.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CObba.java<\/strong><\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/=========================================================================#\n\/\/ Financial Econometrics &amp; Derivatives, ML\/DL using R, Python, Tensorflow  \n\/\/ by Sang-Heon Lee \n\/\/\n\/\/ https:\/\/shleeai.blogspot.com\n\/\/-------------------------------------------------------------------------#\n\/\/ How to use Obba (connection between Java and Excel)\n\/\/=========================================================================#\npackage aObba;\n \npublic class CObba {\n \n    public static double func1(double a) {return (a*a);}\n    public static double func2(double a, double b) {return (a*b);}\n    public static double[] func3(double[] a, double[] b) {\n            \n        double[] c = new double[a.length];\n        for(int i=0;i&lt;a.length;i++) {c[i] = a[i]*b[i];}\n        return (c);\n    }\n    \n    public static void main(String[] args) {\n        \n        \/\/ scalar input &amp; scalar output\n        double a = func1(7);\n        \n        \/\/ scalar input &amp; scalar output\n        double b = func2(7,8);\n        \n        \/\/ array input &amp; array output\n        double[] c = {1,2,3,4,5,6,7,8,9,10};\n        double[] d = {2,3,4,5,6,7,8,9,10,11};\n        double[] e = func3(c,d);\n        \n        \/\/ print results\n        System.out.println(\"func1 = \" + a);\n        System.out.println(\"func2 = \" + b);\n        System.out.println(\"func3 = \");\n        for(int i=0;i&lt;e.length;i++) {\n            System.out.println(e[i]);\n        }\n    }\n}<\/pre>\n\n\n\n<p>Running CObba.java file results in the following correct outputs.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"759\" height=\"728\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/03_CObba_java_code-shfintech.png\" alt=\"\" class=\"wp-image-192842 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/03_CObba_java_code-shfintech.png 759w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/03_CObba_java_code-shfintech-700x671.png 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/03_CObba_java_code-shfintech-300x288.png 300w\" data-sizes=\"(max-width: 759px) 100vw, 759px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 759px; aspect-ratio: 759\/728;\" \/><\/figure>\n\n\n\n<p>Eventually, our purpose is to call Java functions such as func1(), func2(), func3() and to see the above same results in Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Export as a JAR file<\/h3>\n\n\n\n<p>Obba extracts information regarding classes from JAR file. Therefore, we should make a JAR file for our class.<\/p>\n\n\n\n<p>Using Export menu in Eclipse, we can make the JAR file (aObba.jar) as the following figure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"809\" height=\"876\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/04_export_jar_file-shfintech.png\" alt=\"\" class=\"wp-image-192844 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/04_export_jar_file-shfintech.png 809w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/04_export_jar_file-shfintech-700x758.png 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/04_export_jar_file-shfintech-300x325.png 300w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/04_export_jar_file-shfintech-768x832.png 768w\" data-sizes=\"(max-width: 809px) 100vw, 809px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 809px; aspect-ratio: 809\/876;\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Obba Commands in Excel<\/h3>\n\n\n\n<p>Now it is time to use Excel. In Excel file, write the following Obba commands to each cell as formula and save it to the same folder in which JAR file is located.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">C2  = OBADDJAR(\"aObba.jar\",TRUE)\nC5  = OBMAKE(\"Obba1\",\"aObba.CObba\")\nF10 = OBGET(OBCALL(\"\",$C$5,\"func1\",\n                  OBMAKE(\"\",\"double\",C10)))\nF15 = OBGET(OBCALL(\"\",$C$5,\"func2\",\n                  OBMAKE(\"\",\"double\",C15),\n                  OBMAKE(\"\",\"double\",D15)))\nF20 ={TRANSPOSE(\n         OBGET(OBCALL(\"\",$C$5,\"func3\",\n         OBMAKE(\"\",\"double[]\",C20:C29),\n         OBMAKE(\"\",\"double[]\",D20:D29))))}<\/pre>\n\n\n\n<p>Using the above Obba commands, we can see the following Excel file with same results.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"730\" height=\"678\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/05_excel_obba_code-shfintech.png\" alt=\"\" class=\"wp-image-192846 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/05_excel_obba_code-shfintech.png 730w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/05_excel_obba_code-shfintech-700x650.png 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/06\/05_excel_obba_code-shfintech-300x279.png 300w\" data-sizes=\"(max-width: 730px) 100vw, 730px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 730px; aspect-ratio: 730\/678;\" \/><\/figure>\n\n\n\n<p>Seeing the above figure and its formula in each cell, we can easily figure out the meaning of Obba commands.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In C2, find and ready to use&nbsp;<strong>aObba.jar<\/strong><\/li>\n\n\n\n<li>In C5, make an&nbsp;<strong>Obba1<\/strong>&nbsp;object as an instance of class&nbsp;<strong>aObba.CObba<\/strong>.<\/li>\n\n\n\n<li>In F10, call a func1 (OBCALL) with single scalar input (OBMAKE) and get a result (OBGET).<\/li>\n\n\n\n<li>In F15, call a func2 (OBCALL) with two scalar inputs (OBMAKE) and get a result (OBGET).<\/li>\n\n\n\n<li>In F20, call a func3 (OBCALL) with two array inputs (OBMAKE) and get a result (OBGET) and the transpose for the vertical representation.<\/li>\n<\/ol>\n\n\n\n<p>In particular, formula in cell&nbsp;<strong>F20<\/strong>&nbsp;should be executed by using&nbsp;<strong>Ctrl+Shift+Enter<\/strong>&nbsp;since func3 function returns a vector or array,<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Final Thought<\/h3>\n\n\n\n<p>The bottom line is that after finding a JAR file and making an instance of its class, use&nbsp;<strong>OBCALL<\/strong>&nbsp;for calling a function, use&nbsp;<strong>OBMAKE<\/strong>&nbsp;for passing input arguments, and use&nbsp;<strong>OBGET<\/strong>&nbsp;for getting a result.<\/p>\n\n\n\n<p>From this post, we can learn how to use Obba with some examples of variety ,which are intended for some general usage.<\/p>\n\n\n\n<p><em>Originally posted on <a href=\"https:\/\/shleeai.blogspot.com\/\">SHLee AI Financial Model<\/a> blog.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Obba is a Java object handler for Excel spreadsheet applications.<\/p>\n","protected":false},"author":662,"featured_media":38256,"comment_status":"open","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[339,347,343,338,341],"tags":[7376,5878,596,15527],"contributors-categories":[13728],"class_list":{"0":"post-192835","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-data-science","8":"category-java-development","9":"category-programing-languages","10":"category-ibkr-quant-news","11":"category-quant-development","12":"tag-eclipse","13":"tag-excel","14":"tag-java","15":"tag-obba","16":"contributors-categories-sh-fintech-modeling"},"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Use Obba for a Link between Java and Excel<\/title>\n<meta name=\"description\" content=\"Obba is a Java object handler for Excel spreadsheet applications.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/192835\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use Obba for a Link between Java and Excel | IBKR Campus US\" \/>\n<meta property=\"og:description\" content=\"Obba is a Java object handler for Excel spreadsheet applications.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"IBKR Campus US\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T14:32:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-03T14:32:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/03\/digital-code-abstract.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sang-Heon Lee\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sang-Heon Lee\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\\\/\\\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"NewsArticle\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/#article\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/\"\n\t            },\n\t            \"author\": {\n\t                \"name\": \"Sang-Heon Lee\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/0a959ff9de7f0465a07baa1fe1ae0200\"\n\t            },\n\t            \"headline\": \"How to Use Obba for a Link between Java and Excel\",\n\t            \"datePublished\": \"2023-07-03T14:32:06+00:00\",\n\t            \"dateModified\": \"2023-07-03T14:32:47+00:00\",\n\t            \"mainEntityOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/\"\n\t            },\n\t            \"wordCount\": 560,\n\t            \"commentCount\": 0,\n\t            \"publisher\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/03\\\/digital-code-abstract.jpg\",\n\t            \"keywords\": [\n\t                \"Eclipse\",\n\t                \"Excel\",\n\t                \"Java\",\n\t                \"Obba\"\n\t            ],\n\t            \"articleSection\": [\n\t                \"Data Science\",\n\t                \"Java Development\",\n\t                \"Programming Languages\",\n\t                \"Quant\",\n\t                \"Quant Development\"\n\t            ],\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"CommentAction\",\n\t                    \"name\": \"Comment\",\n\t                    \"target\": [\n\t                        \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/#respond\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/\",\n\t            \"name\": \"How to Use Obba for a Link between Java and Excel | IBKR Campus US\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\"\n\t            },\n\t            \"primaryImageOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/03\\\/digital-code-abstract.jpg\",\n\t            \"datePublished\": \"2023-07-03T14:32:06+00:00\",\n\t            \"dateModified\": \"2023-07-03T14:32:47+00:00\",\n\t            \"description\": \"Obba is a Java object handler for Excel spreadsheet applications.\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"ImageObject\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/how-to-use-obba-for-a-link-between-java-and-excel\\\/#primaryimage\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/03\\\/digital-code-abstract.jpg\",\n\t            \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2020\\\/03\\\/digital-code-abstract.jpg\",\n\t            \"width\": 900,\n\t            \"height\": 538,\n\t            \"caption\": \"Quant\"\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t            \"name\": \"IBKR Campus US\",\n\t            \"description\": \"Financial Education from Interactive Brokers\",\n\t            \"publisher\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t            },\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Organization\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\",\n\t            \"name\": \"Interactive Brokers\",\n\t            \"alternateName\": \"IBKR\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t            \"logo\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\",\n\t                \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t                \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t                \"width\": 669,\n\t                \"height\": 669,\n\t                \"caption\": \"Interactive Brokers\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\"\n\t            },\n\t            \"publishingPrinciples\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/about-ibkr-campus\\\/\",\n\t            \"ethicsPolicy\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/cyber-security-notice\\\/\"\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/0a959ff9de7f0465a07baa1fe1ae0200\",\n\t            \"name\": \"Sang-Heon Lee\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/author\\\/sang-heonlee\\\/\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Use Obba for a Link between Java and Excel","description":"Obba is a Java object handler for Excel spreadsheet applications.","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:\/\/www.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/192835\/","og_locale":"en_US","og_type":"article","og_title":"How to Use Obba for a Link between Java and Excel | IBKR Campus US","og_description":"Obba is a Java object handler for Excel spreadsheet applications.","og_url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/","og_site_name":"IBKR Campus US","article_published_time":"2023-07-03T14:32:06+00:00","article_modified_time":"2023-07-03T14:32:47+00:00","og_image":[{"width":900,"height":538,"url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/03\/digital-code-abstract.jpg","type":"image\/jpeg"}],"author":"Sang-Heon Lee","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sang-Heon Lee","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/#article","isPartOf":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/"},"author":{"name":"Sang-Heon Lee","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/0a959ff9de7f0465a07baa1fe1ae0200"},"headline":"How to Use Obba for a Link between Java and Excel","datePublished":"2023-07-03T14:32:06+00:00","dateModified":"2023-07-03T14:32:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/"},"wordCount":560,"commentCount":0,"publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/03\/digital-code-abstract.jpg","keywords":["Eclipse","Excel","Java","Obba"],"articleSection":["Data Science","Java Development","Programming Languages","Quant","Quant Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/","url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/","name":"How to Use Obba for a Link between Java and Excel | IBKR Campus US","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/03\/digital-code-abstract.jpg","datePublished":"2023-07-03T14:32:06+00:00","dateModified":"2023-07-03T14:32:47+00:00","description":"Obba is a Java object handler for Excel spreadsheet applications.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/how-to-use-obba-for-a-link-between-java-and-excel\/#primaryimage","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/03\/digital-code-abstract.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/03\/digital-code-abstract.jpg","width":900,"height":538,"caption":"Quant"},{"@type":"WebSite","@id":"https:\/\/ibkrcampus.com\/campus\/#website","url":"https:\/\/ibkrcampus.com\/campus\/","name":"IBKR Campus US","description":"Financial Education from Interactive Brokers","publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ibkrcampus.com\/campus\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ibkrcampus.com\/campus\/#organization","name":"Interactive Brokers","alternateName":"IBKR","url":"https:\/\/ibkrcampus.com\/campus\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","width":669,"height":669,"caption":"Interactive Brokers"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/"},"publishingPrinciples":"https:\/\/www.interactivebrokers.com\/campus\/about-ibkr-campus\/","ethicsPolicy":"https:\/\/www.interactivebrokers.com\/campus\/cyber-security-notice\/"},{"@type":"Person","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/0a959ff9de7f0465a07baa1fe1ae0200","name":"Sang-Heon Lee","url":"https:\/\/www.interactivebrokers.com\/campus\/author\/sang-heonlee\/"}]}},"jetpack_featured_media_url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2020\/03\/digital-code-abstract.jpg","_links":{"self":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/192835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/users\/662"}],"replies":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/comments?post=192835"}],"version-history":[{"count":0,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/192835\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media\/38256"}],"wp:attachment":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media?parent=192835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/categories?post=192835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/tags?post=192835"},{"taxonomy":"contributors-categories","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/contributors-categories?post=192835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}