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 <www...@gmail.com>: > Try this: > > xl$Quit() > > On Wed, Jul 8, 2009 at 10:06 AM, Lauri Nikkinen <lauri.nikki...@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@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 > ______________________________________________ R-help@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.