Python in Excel via Reticulate
This post describes a particular use-case for Python in Excel and how it was solved using the R package Reticulate 1.39.0 (https://cran.r-project.org/web/pac...
Posts by Year
2024
Office365 AddIns for R (Part III)
A while back, I introduced the ExcelRAddIn (Office365 AddIns for R (Part I)). This is an Office365 AddIn that allows you to evaluate an R-script from within ...
2023
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
Office365 AddIns for R (Part II)
In the previous post Office365 AddIns for R (Part I), I introduced the ExcelRAddIn. In this post I would like to describe the RScriptAddIn for Word.
Office365 AddIns for R (Part I)
I’d like to introduce a couple of Office365 add-ins for R that I have been working on recently. I read R-bloggers regularly and I thought these add-ins might...