[R] RDCOMClient: how to close Excel process?

[Lauri Nikkinen]

This solution worked:

nBooks <- xl[["Workbooks"]]$Count();
        for (i in seq_len(nBooks))
                xl[["Workbooks"]]$item(i)$Close(SaveChanges=FALSE);

from

http://www.mail-archive.com/r-help@r-project.org/msg61498.html

Thanks!

-L

2009/7/9 Lauri Nikkinen <lauri.nikkinen at iki.fi>:
> 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
>
> 2009/7/8 Henrique Dallazuanna <wwwhsd at gmail.com>:
>> Then, you can try this:
>>
>> xl <- COMCreate("Excel.Application")
>> wk  <- xl$Workbooks()
>> sh <- wk$Open(normalizePath("sample_file.xls"))$Sheets()$Count()
>>
>> wk$Close()
>> xl$Quit()
>>
>>
>>
>> On Wed, Jul 8, 2009 at 10:19 AM, Lauri Nikkinen <lauri.nikkinen at iki.fi>
>> wrote:
>>>
>>> Thanks but that did not work. xl$Quit() does not kill the Excel
>>> process and sample_file.xls will not open.
>>>
>>> I'm using Windows XP SP2 and R 2.8.1
>>>
>>> -L
>>>
>>> 2009/7/8 Henrique Dallazuanna <wwwhsd at gmail.com>:
>>> > Try this:
>>> >
>>> > xl$Quit()
>>> >
>>> > On Wed, Jul 8, 2009 at 10:06 AM, Lauri Nikkinen <lauri.nikkinen at iki.fi>
>>> > wrote:
>>> >>
>>> >> Hi,
>>> >>
>>> >> I’m using R package RDCOMClient (http://www.omegahat.org/RDCOMClient/)
>>> >> to retrieve data from MS Excel workbook. I’m using the code below to
>>> >> count the number of sheets in the workbook and then loop the data from
>>> >> sheets in to a list.
>>> >>
>>> >> ############# R code ###################
>>> >> library(gdata)
>>> >> library(RDCOMClient)
>>> >>
>>> >> xl <- COMCreate("Excel.Application")
>>> >> sh <-
>>> >> xl$Workbooks()$Open(normalizePath("sample_file.xls"))$Sheets()$Count()
>>> >>
>>> >> DF.list <- list()
>>> >> for (i in 1:sh) {
>>> >>   DF.list[[i]] <- read.xls("sample_file.xls", sheet=i,
>>> >> stringsAsFactors = FALSE)
>>> >>   }
>>> >> ######################################
>>> >>
>>> >> COMCreate opens Excel process and it can be seen from Windows Task
>>> >> Manager. When I try to open sample_file.xls in Excel, it just flashes
>>> >> in the screen and shuts down. When I kill (via task manager) the Excel
>>> >> process COMCreate started, sample_file.xls will open normally.
>>> >>
>>> >> The question is, how can I close the Excel process COMCreate started.
>>> >> xl$Close() doesn’t seem to work. The same problem have been presented
>>> >> in this post to R-help:
>>> >> http://tolstoy.newcastle.edu.au/R/help/06/04/25990.html
>>> >>
>>> >> -L
>>> >>
>>> >> ______________________________________________
>>> >> R-help at r-project.org mailing list
>>> >> https://stat.ethz.ch/mailman/listinfo/r-help
>>> >> PLEASE do read the posting guide
>>> >> http://www.R-project.org/posting-guide.html
>>> >> and provide commented, minimal, self-contained, reproducible code.
>>> >
>>> >
>>> >
>>> > --
>>> > Henrique Dallazuanna
>>> > Curitiba-Paraná-Brasil
>>> > 25° 25' 40" S 49° 16' 22" O
>>> >
>>
>>
>>
>> --
>> Henrique Dallazuanna
>> Curitiba-Paraná-Brasil
>> 25° 25' 40" S 49° 16' 22" O
>>
>