Part IV - Using R in Excel - Calling Python
This post describes using R to call Python scripts inside Excel.
Posts by Category
R-project
Part III - Using R in Excel - Forecasting
This post describes how to use the R Forecast package in Excel.
Part II - Using R in Excel - Linear Regression
If you have ever wanted to use R’s workhorse lm(…) function in an Excel worksheet, then this post may be of interest to you.
Part I - Using R in Excel - Descriptive Statistics
If you are an R user, and you have ever wanted to access the functionality offered by your favourite R packages in Excel, then this series of posts may be of...
Calling C++ functions from R using Rcpp
If you are an R/RStudio user and you are learning C/C++ then this blog post may be interesting. Suppose that you’ve written a function in C/C++ (or even a wh...
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 along with the ExcelRAddIn.A while ...
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 ...
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...
python-project
Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Calling Python from C# using Python.NET
Recently, I’ve been using Python’s yfinance library to perform some simple portfolio analysis. Rather than using a Jupyter notebook to run the Python code an...
Software Interoperability
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...
Excel
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...