[R] RDCOMClient: how to close Excel process?

[Lauri Nikkinen]

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
>