How to edit First Page Number in excel via R RDCOMClient?

Question

I am trying to edit the First Page Number in Page Setup in Excel Via R

library(RDCOMClient)
xlApp <- COMCreate("Excel.Application")
xlApp[["Visible"]] <- TRUE
xlBook <- xlApp[["Workbooks"]]$Add()
xlSheet <- xlBook[["Worksheets"]]$Item(1)
xlSheet$PageSetup()$FirstPageNumber() <- 1

Error in xlSheet$PageSetup()$FirstPageNumber() <- 1 : invalid (NULL) left side of assignment

score 0 · Answer 1 · answered Jun 05 '19 at 19:58

0

x <- xlSheet[["PageSetup"]]
x[["FirstPageNumber"]] <- 1

answered Jun 05 '19 at 19:58

Mohamed

95
7

How to edit First Page Number in excel via R RDCOMClient?

1 Answers1