Lauri Nikkinen wrote:
> Thanks again. That did not work either. I get
>
>> library(RDCOMClient)
>> xl <- COMCreate("Excel.Application")
>> wk <- xl$Workbooks()
>> sh <- wk$Open(normalizePath("sample_file.xls"))$Sheets()$Count()
>>
>> wk$Close()
> [1] TRUE
>> xl$Quit()
> NULL
>
> and there is still Excel process open in the Task manager (and
> sample_file.xls won't open).
>
> -L
In my experience, the Excel process will not go away if any
Excel-related object has been created but not destroyed. I suggest that
you explictly remove all Excel objects with rm() and run gc() at the end
to clean up:
library(RDCOMClient)
xl <- COMCreate("Excel.Application")
wk <- xl$Workbooks()
sh<-wk$Open(normalizePath("sample_file.xls"))$Sheets()$Count()
wk$Close()
xl$Quit()
rm(sh)
rm(wk)
rm(xl)
gc()
J. R. M. Hosking
______________________________________________
R-help@... mailing list
https://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide
http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code.
