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 Tag
- R 4
- r-project 4
- Excel 4
- Office365 3
- Word 1
- cpp 1
- cppwinrt 1
- winrt 1
- midl 1
- csharp 1
- winui3 1
- xaml 1
- SUM 1
- CHOOSECOLS 1
- FILTER 1
- LAMBDA 1
- Pivot Table 1
- PowerQuery 1
- VBA 1
- Python 1
R
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...
r-project
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...
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...
Excel
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...
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 ...
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...
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...
Office365
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...
Word
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.
cpp
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...
cppwinrt
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...
winrt
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...
midl
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...
csharp
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...
winui3
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...
xaml
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...
SUM
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...
CHOOSECOLS
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...
FILTER
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...
LAMBDA
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...
Pivot Table
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...
PowerQuery
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...
VBA
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...
Python
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...