0

Here is to create a new Workbook, I create 2 blank sheets:

library(openxlsx)
wb <- createWorkbook()
headercol <- createStyle(halign = "left", textDecoration = "bold")
addWorksheet(wb, sheetName = "Report1")
addWorksheet(wb, sheetName = "Report2")

And now I loaded another workbook which have its own content:

lb <- loadWorkbook(file.choose())

I wanted to copy the content of lb sheet to my "Report2" sheets.. is this possible to do? Thank You

Jovan
  • 763
  • 7
  • 26
  • 1
    Does [this answer](https://stackoverflow.com/a/69015023/3460670) help you? – Ben Jan 17 '22 at 14:16
  • 1
    yes.. so copying workbooks can be done with RDCOMClient packages.. thank you for the reference @Ben – Jovan Jan 17 '22 at 14:23

0 Answers0