[R] RCOM Save

koj jens.koch at gmx.li
Thu Apr 1 12:00:50 CEST 2010


Thank you. Unfortunately this recommendation does not solve my problem and I
don't know why. Here is my test-code:


pfad<-paste("C:/...","xls",sep=".")
xl <- COMCreate("Excel.Application")  
xl[["Visible"]] <- FALSE                     
wkbk <- xl$Workbooks()$Open(pfad)       
sh <- xl$ActiveSheet()
A3R <- sh$Range("A28")
A3R[["Formula"]] <- "=Summe(A1:A27)"
A3RF <- A3R$Font()
A3RF[["Bold"]] <- TRUE
wkbk$Close(pfad)
system("taskkill /f /im Excel.exe")

I tried a lot of possibilities (e. g. in the close statement) but without
success. Excel always asks about the saving.
-- 
View this message in context: http://n4.nabble.com/RCOM-Save-tp1746602p1747885.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list