[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