{"id":197010,"date":"2023-10-02T11:18:35","date_gmt":"2023-10-02T15:18:35","guid":{"rendered":"https:\/\/ibkrcampus.com\/?p=197010"},"modified":"2023-10-02T11:18:13","modified_gmt":"2023-10-02T15:18:13","slug":"rdcomclient-read-and-write-excel-and-call-vba-macro-in-r","status":"publish","type":"post","link":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/","title":{"rendered":"RDCOMClient: Read and Write Excel, and Call VBA Macro in R"},"content":{"rendered":"\n

This post gives a short introduction to the RDCOMClient<\/strong> R package, which provides a variety of functionalities. Our focus is on reading from and writing to Excel, and call VBA macro function in R.<\/p>\n\n\n\n

<\/a><\/p>\n\n\n\n

Introduction<\/h3>\n\n\n\n

Using RDCOMClient<\/strong> R package, we can read from and write to Excel spreadsheet, furthermore, call VBA macro function in R. Of course this VBA is running in Excel not R. We can get results which are returned from VBA macro which was developed earlier.<\/p>\n\n\n\n

This feature is very useful when this macro calls DLL, which is hard to be called in R for some reason. At last, we can get the same effect of calling DLL in R indirectly<\/strong> by using RDCOMClient package.<\/p>\n\n\n\n

Installing<\/h3>\n\n\n\n

Unlike other packages, RDCOMClient<\/strong> is installed using the following command. It seems that the second installation is working and the first is not.<\/strong><\/p>\n\n\n\n

install.packages(“RDCOMClient”,repos=”https:\/\/www.omegahat.net\/R”)
or
devtools::install_github(“omegahat\/RDCOMClient”)<\/strong><\/p>\n\n\n\n

Excel Example with VBA macro<\/h3>\n\n\n\n

The following figure shows the operation of macro1()<\/strong> function by clicking [run macro1<\/strong>] rectangular button. macro1() returns squares of input variables simply.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The VBA code of macro1() is as follows.<\/p>\n\n\n\n

Sub macro1()\n \n    For i = 1 To 10\n        Worksheets(\"Sheet1\").Range(\"D2\").Offset(i, 0).Value _\n        = WorksheetFunction.Power( _\n            Worksheets(\"Sheet1\").Range(\"C2\").Offset(i, 0).Value, 2)\n    Next\n    \nEnd Sub<\/pre>\n\n\n\n
R code<\/h3>\n\n\n\n
The following R code implements three operations:<\/p>\n\n\n\n
    \n
  1. Write input array to Excel<\/li>\n\n\n\n
  2. Run macro1()<\/li>\n\n\n\n
  3. Read output array from Excel<\/li>\n<\/ol>\n\n\n\n
    R code is simple and self-contained so that you can easily understand it. For convenience, we make two functions : f_read_vector() and f_write_vector().<\/p>\n\n\n\n
    #=========================================================================#\n# Financial Econometrics & Derivatives, ML\/DL using R, Python, Tensorflow  \n# by Sang-Heon Lee \n#\n# https:\/\/shleeai.blogspot.com\n#-------------------------------------------------------------------------#\n# Read and Write Excel in R, also call VBA macro in R using RDCOMClient\n#\n# Install package (Not available on CRAN at 12 June 2019)\n# install.packages(\"RDCOMClient\", repos = \"https:\/\/www.omegahat.net\/R\")\n#=========================================================================#\n \nlibrary(RDCOMClient)\n \ngraphics.off()  # clear all graphs\nrm(list = ls()) # remove all files from your workspace\n \n#===============================================================================\n# functions using RDCOMClient\n#===============================================================================\n \nf_read_vector <- function(xlWbk1, sheet1, range1){\n    \n    sheet <- xlWbk1$Worksheets(sheet1)\n    range <- sheet$Range(range1)\n    data  <- do.call(\"cbind\",range[[\"Value\"]])\n    data  <- matrix(unlist(data), dim(data)[1], dim(data)[2])\n    return(data)\n}\n \nf_write_vector <- function(xlWbk1, sheet1, range1, data1) {\n    \n    sheet <- xlWbk1$Worksheets(sheet1)\n    range <- sheet$Range(range1)\n    range[[\"Value\"]] <- asCOMArray(data1)\n}\n \n#===========================================================\n# MAIN\n#===========================================================\n    \n    # set working directory\n    setwd(\"D:\/SHLEE\/blog\/excel_com\")\n    \n    # Create Excel Application\n    xlApp <- COMCreate(\"Excel.Application\")\n    \n    # Open the Macro Excel book\n    fn <- \"sample_excel.xlsm\"\n    xlWbk <- xlApp$Workbooks()$Open(paste0(getwd(),\"\/\",fn))\n    \n    # use TRUE for Excel Spreadsheet to be visible\n    xlApp[['Visible']] <- FALSE \n \n#===========================================================\n# Communicate between R and Excel\n#===========================================================\n \n    # Arguments for Excel Spreadsheet and VBA macro\n    sheet      <- \"Sheet1\"\n    range_in   <- \"C3:C12\"\n    range_out  <- \"D3:D12\"\n    macro_name <- \"macro1\"\n    \n    #----------------\n    # Example 1\n    #----------------\n    \n    # 1) write input values from R to Excel\n    data_in <- 1:10\n    f_write_vector(xlWbk, sheet, range_in, data_in) \n    \n    # 2) run Excel macro\n    xlApp$Run(macro_name)\n    \n    # 3) read output values from R to Excel\n    data_out <- f_read_vector(xlWbk, sheet, range_out)\n \n    print(cbind(data_in, data_out))\n    \n    #----------------\n    # Example 2\n    #----------------\n    \n    data_in <- rnorm(10)\n    f_write_vector(xlWbk, sheet, range_in, data_in) \n    xlApp$Run(macro_name)\n    data_out <- f_read_vector(xlWbk, sheet, range_out)\n    print(cbind(data_in, data_out))\n    \n#===========================================================\n# save and quit\n#===========================================================\nxlWbk$close(TRUE); xlApp$Quit() <\/pre>\n\n\n\n
    Results<\/h3>\n\n\n\n
    The following console shows two outputs for each input array. This output is calculated in Excel by using VBA function not by using R.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    In fact, running the above R code results in the following calculation outputs of Excel spreadsheet. R is only to read these results.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Conclusion<\/h3>\n\n\n\n
    This post deals with a simple exercise (reading and writing) of RDCOMClient<\/strong> R package. In particular, when VBA macro function calls DLL, we can use this DLL indirectly by calling not DLL but its wrapper VBA macro. This is useful when you have difficulties in calling DLL directly in R for some reason. <\/p>\n\n\n\n
    Originally posted on SHLee AI Financial Model<\/a> blog.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
    This post gives a short introduction to the\u00a0RDCOMClient\u00a0R package, which provides a variety of functionalities<\/p>\n","protected":false},"author":662,"featured_media":194443,"comment_status":"open","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[339,343,338,341,342],"tags":[806,5878,487,16056,6591,16057],"contributors-categories":[13728],"class_list":["post-197010","post","type-post","status-publish","format-standard","has-post-thumbnail","category-data-science","category-programing-languages","category-ibkr-quant-news","category-quant-development","category-r-development","tag-data-science","tag-excel","tag-r","tag-rdcomclient","tag-rstats","tag-vba","contributors-categories-sh-fintech-modeling"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","acf":[],"yoast_head":"\nRDCOMClient: Read and Write Excel, and Call VBA Macro in R<\/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:\/\/www.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/197010\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RDCOMClient: Read and Write Excel, and Call VBA Macro in R | IBKR Campus US\" \/>\n<meta property=\"og:description\" content=\"This post gives a short introduction to the\u00a0RDCOMClient\u00a0R package, which provides a variety of functionalities\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/\" \/>\n<meta property=\"og:site_name\" content=\"IBKR Campus US\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-02T15:18:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/08\/r-programming-coffee-laptop-desk.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\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=\"3 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\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/#article\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/\"\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\": \"RDCOMClient: Read and Write Excel, and Call VBA Macro in R\",\n\t            \"datePublished\": \"2023-10-02T15:18:35+00:00\",\n\t            \"mainEntityOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/\"\n\t            },\n\t            \"wordCount\": 374,\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\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/r-programming-coffee-laptop-desk.jpg\",\n\t            \"keywords\": [\n\t                \"Data Science\",\n\t                \"Excel\",\n\t                \"R\",\n\t                \"RDCOMClient\",\n\t                \"rstats\",\n\t                \"VBA\"\n\t            ],\n\t            \"articleSection\": [\n\t                \"Data Science\",\n\t                \"Programming Languages\",\n\t                \"Quant\",\n\t                \"Quant Development\",\n\t                \"R 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\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/#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\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/\",\n\t            \"name\": \"RDCOMClient: Read and Write Excel, and Call VBA Macro in R | 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\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/r-programming-coffee-laptop-desk.jpg\",\n\t            \"datePublished\": \"2023-10-02T15:18:35+00:00\",\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\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/\"\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\\\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\\\/#primaryimage\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/r-programming-coffee-laptop-desk.jpg\",\n\t            \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2023\\\/08\\\/r-programming-coffee-laptop-desk.jpg\",\n\t            \"width\": 1000,\n\t            \"height\": 563,\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":"RDCOMClient: Read and Write Excel, and Call VBA Macro in R","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\/197010\/","og_locale":"en_US","og_type":"article","og_title":"RDCOMClient: Read and Write Excel, and Call VBA Macro in R | IBKR Campus US","og_description":"This post gives a short introduction to the\u00a0RDCOMClient\u00a0R package, which provides a variety of functionalities","og_url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/","og_site_name":"IBKR Campus US","article_published_time":"2023-10-02T15:18:35+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/08\/r-programming-coffee-laptop-desk.jpg","type":"image\/jpeg"}],"author":"Sang-Heon Lee","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sang-Heon Lee","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/#article","isPartOf":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/"},"author":{"name":"Sang-Heon Lee","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/0a959ff9de7f0465a07baa1fe1ae0200"},"headline":"RDCOMClient: Read and Write Excel, and Call VBA Macro in R","datePublished":"2023-10-02T15:18:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/"},"wordCount":374,"commentCount":0,"publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/08\/r-programming-coffee-laptop-desk.jpg","keywords":["Data Science","Excel","R","RDCOMClient","rstats","VBA"],"articleSection":["Data Science","Programming Languages","Quant","Quant Development","R Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/","url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/","name":"RDCOMClient: Read and Write Excel, and Call VBA Macro in R | IBKR Campus US","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/#primaryimage"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/08\/r-programming-coffee-laptop-desk.jpg","datePublished":"2023-10-02T15:18:35+00:00","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/rdcomclient-read-and-write-excel-and-call-vba-macro-in-r\/#primaryimage","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/08\/r-programming-coffee-laptop-desk.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2023\/08\/r-programming-coffee-laptop-desk.jpg","width":1000,"height":563,"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\/2023\/08\/r-programming-coffee-laptop-desk.jpg","_links":{"self":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/197010","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=197010"}],"version-history":[{"count":0,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/197010\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media\/194443"}],"wp:attachment":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media?parent=197010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/categories?post=197010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/tags?post=197010"},{"taxonomy":"contributors-categories","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/contributors-categories?post=197010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}