Overwrite An Excel File through RDCOMClient Package in R

Question

I am trying to manipulate an Excel file (.xls) in R through RDCOMClient Package.

I created an Excel object in R, opened a workbook saved as .xls file format, and tried to convert the file format into .xlsx without pop-up dialog box when there is an Excel file with the same file name. Codes as below.

excel <- COMCreate("Excel.Application")
wb    <- excel$Workbooks()$Open(Filename = "filepath.xls",Password = "xxxxx")

excel$DisplayAlerts(FALSE)

wb$SaveAs(Filename = "filepath.xlsx" ,FileFormat = 51,Password = "")

I got an error message when I executed the code:

excel$DisplayAlerts(FALSE)

<'checkErrorInfo'> 8002000E Error: invalid number of parameter.

Check this out https://stat.ethz.ch/pipermail/r-help/2010-January/225841.html ... excel[["DisplayAlerts"]] <- FALSE — chinsoon12, Apr 15 '16 at 11:50
Hey, @chinsoon12, thank you for the resolution, it worked !! Thanks again. — Nelson Chang, Apr 18 '16 at 05:46

score 0 · Answer 1 · edited Apr 12 '19 at 11:46

0

You should replace it with the following:

excel[["DisplayAlerts"]]=FALSE

edited Apr 12 '19 at 11:46

Stephen King

581
5
18
31

answered Apr 12 '19 at 09:36

Slimm el benna

1

Overwrite An Excel File through RDCOMClient Package in R

1 Answers1