Hi,
first of all, thank you for BERT. I found the idea of using R directly from Excel very useful, and it was one of the inspirations for a small add-in I built for my own workflow.
I created a new Excel add-in called T-REx because I had compatibility issues using BERT with newer R versions. T-REx follows a similar general idea: it connects Excel to a live R session so that Excel and R can communicate in both directions.
The main design goal was to make the add-in feel familiar to R users, especially users who are used to RStudio. T-REx provides an RStudio-like layout inside Excel, with a console, environment pane, helper pane, command history, plot support, and a worksheet-based code workflow. Instead of an editor pane, the Excel worksheet itself acts as the place where users can write and execute R code.
Some core features are:
- bidirectional communication between Excel and R;
- a shared global R environment accessible from Excel and from R;
- execution of R code written in worksheet cells;
- R formulas such as R_RUN(), R_GET(), and R_CALL();
- R helper functions such as EXCEL_GET(), EXCEL_PUT(), and EXCEL_PLOT();
- insertion of R plots into Excel worksheets;
- R macro buttons for running R workflows from Excel;
- support for script-based projects.
I originally built T-REx mainly for my own use, but I thought it might be useful to share it with users who like the BERT concept and are looking for something that works with newer R versions.
The project is available here:
https://github.com/TobiasKogelheide/TREx
I hope it is okay to mention this here. If this issue is not appropriate for the BERT issue tracker, please feel free to close or delete it.
Thanks again for the work on BERT.
Hi,
first of all, thank you for BERT. I found the idea of using R directly from Excel very useful, and it was one of the inspirations for a small add-in I built for my own workflow.
I created a new Excel add-in called T-REx because I had compatibility issues using BERT with newer R versions. T-REx follows a similar general idea: it connects Excel to a live R session so that Excel and R can communicate in both directions.
The main design goal was to make the add-in feel familiar to R users, especially users who are used to RStudio. T-REx provides an RStudio-like layout inside Excel, with a console, environment pane, helper pane, command history, plot support, and a worksheet-based code workflow. Instead of an editor pane, the Excel worksheet itself acts as the place where users can write and execute R code.
Some core features are:
I originally built T-REx mainly for my own use, but I thought it might be useful to share it with users who like the BERT concept and are looking for something that works with newer R versions.
The project is available here:
https://github.com/TobiasKogelheide/TREx
I hope it is okay to mention this here. If this issue is not appropriate for the BERT issue tracker, please feel free to close or delete it.
Thanks again for the work on BERT.