RDCOM supports calling R from Excel. AFAIK you need to use the non-free Statconn software [1] to get much done going the other way.
FWIW I have found my life to be much simpler only using packages that access the data in Excel rather than trying to control the software remotely. More OS-portable, too. In fact, if you can obtain your data without having it ever munged by Excel you may save yourself considerable headache with its "helpful" misinterpretations of data. E.g. [2] [1] http://sunsite.univie.ac.at/rcom [2] https://www.networkworld.com/article/2304425/lan-wan/excel-helpers-can-damage-data.html On May 29, 2018 6:52:37 AM PDT, Ayhan Yuksel <ayhan.yuk...@alphatecht.com> wrote: >Dear All, > >I am using excel.link package to open and modify Excel files. > >When I manually open Excel, all my add-ins are loaded without a >problem. >But when I open Excel using excel.link package, like: >xls<-xl.get.excel() >xl.workbook.open("MyFile.xlsx") >some Excel add-ins are (installed but) not loaded. > >Since the problem is related to local add-ins at my side, I cannot >reproduce the problem here. > >I am aware of how to solve this problem using VBA, but looking for a >solution within R, may be using RDCOM > >Thanks >Ayhan > > [[alternative HTML version deleted]] > >______________________________________________ >R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >https://stat.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide >http://www.R-project.org/posting-guide.html >and provide commented, minimal, self-contained, reproducible code. -- Sent from my phone. Please excuse my brevity. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
