Problem with excel.link package

General
1

I am not able to use excel.link package with R version 4.0.2 (2020-06-22) -- "Taking Off Again". The code below used to work on previous versions. Now it either creates an error or causes R/RStudio to abort.

What I am trying to do is open an excel workbook and insert a data.table in it.

ExcelPrint = function(rObject) {
  library(excel.link)
  myExcelProcess = COMCreate("Excel.Application")
  xl.workbook.add()
  excelRange = myExcelProcess[["ActiveSheet"]]$Range("A1:A1")
  xl.write(rObject, excelRange, row.names = FALSE)
} 

ExcelPrint(iris)
2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.