How to manipulate excel file from R studio

[sefhamada]

Hi,

I would like to run Bert from R studio to control and manipulate an excel file. Unfortunately when I try to do so the EXCEL object is not defined in my R environment.

Thank you,

Sef

[jazccc]

I believe you cannot. BERT is installed in Excel, not in RStudio. BERT is not an R package, it is like a extension to Excel.

[sefhamada]

Thank you for your reply jazccc, yes indeed the way it is presented from BERT website, it does not look straightforward, it is more like an add-in to excel, which is a bit disappointing. I am writing an R application that reads data from spreadsheets (xlsm) and generate reports in R after doing further calcs, and I was hoping to be able to have full control of the excel files because I need to pass values to cells and recalculate. Other packages do only read form Excel. The only piece missing in the puzzle is connecting BERT dev env to my R session/dev env. Do you think there a walk-around ? Cheers, Sef