Setting up an environment

Since setting up an environment for BERT and xlwings is non-trivial, we will walk you through the process in detail in the coming subsections.

Steps to set up BERT for R

In this section, we will cover the installation of BERT for Windows so that we can utilize BERT to manipulate Excel from inside of R. The first thing that we will have to do is download the BERT installer, which can be obtained from here: https://bert-toolkit.com/download-bert.

Once this is downloaded, you can then install it as you would any other program. Once installed, you can then use the Add-ins ribbon from Excel to open the BERT Console, as shown here:

Figure 11.1 – BERT Console from the Add-ins ribbon in Excel

Once you see it, click the button, and the console will open, as shown here:

Figure 11.2 – The BERT Console

Now, let’s move to Python.

Steps to set up xlwings for Python

In this subsection...