Re: [R] RCOM Save

Sorry. Of course you are right. I am using library(RDCOMClient). I tried the new suggestion which is the solution. Thank you. -- View this message in context: http://n4.nabble.com/RCOM-Save-tp1746602p1749968.html Sent from the R help mailing list archive at Nabble.com. _

Re: [R] RCOM Save

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$ActiveShee

[R] RCOM Save

Dear all, I use the package RCOM to manipulate Excel-Files (Windows). After opening the Excel-File and formatting the cells I want to save the file automatically without request. If I use y[["Save"]] <- TRUE it opens the saving dialog and I have to select the destination for saving. But I simpl

Re: [R] barplot (stacked)

Hi Kimmo, thank you for your answer, but this is not the thing I am searching for. Unfortunately, I have not described the problem very good. But just in this moment I have a good idea: I use add=TRUE and paint two plots. And so I am sure that I can solve the problem. -- View this message in con

[R] barplot (stacked)

Dear all, I want to draw a barplot with the following data: [,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [1,] 110.0675 118.4167 117.16 109.735416 101.6312 104.0312 101.8263 99.38541670 114.2613 [2,] 0. 0. 0.00 1.658333 0. 0.625

[R] Barplot colours

Hi all, my plotbase (height) is a 2x2 matrix and I want to draw a plot with different colours. I used beside = FALSE and so the elements (1,1) and (2,1) are in one bar and the elements (1,2) and (2,2) are in the other bar (stacked). This is no problem, if the first row has one colour and the seco

Re: [R] sqlUpdate RODBC

Update - The first problem is solved: sqlQuery(channel, "create table TEST3 (NR NUMBER, NAME VARCHAR2(55),TAG DATE)") -- View this message in context: http://n4.nabble.com/sqlUpdate-RODBC-tp1460867p1460899.html Sent from the R help mailing list archive at Nabble.com. _

[R] sqlUpdate RODBC

Dear all, I using R version 2.9.0 on Windows XP and want to insert data from a data frame in R into a oracle database via sqlUpdate with the package RODBC. My example is the following: TEST0<-data.frame(NR=c(1,2,600),NAME=c("JK","TR","AR"), DATUM=c("2009-01-01","2010-01-02","2010-06-09")) If I

[R] R Batch Mode Customized Input

Dear all, I use R in Batch Mode with the following syntax: X:\...\Rcmd BATCH --slave X\...\test.R X:\...\Log.txt It works very fine. Now I want to write a function and customize the input for my R-File, e.g I want to define the start and the end date. Let's assume that test.R includes only

[R] Excel-Export

Dear all, i use the following package/syntax to export data to excel: library(xlsReadWrite) write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) Everything is fine, but the format of the export is not the best. For example, I every time have to adjust the column widt

[R] Text in barplot.

Dear all, i want to display a text in a barplot. Actual I simply work with the following lines: text(0.3,0.2,substring(teammembers.paint,1,140),cex=0.45,pos=4,srt=90) text(0.48,0.2,substring(teammembers.paint,141,1000),cex=0.45,pos=4,srt=90) The problem is, that "teammembers.paint" could be ver

Re: [R] Delta in time series

koj wrote: > > Hi all, > > I have time data in the following format: > > 2009-03-09 12:00:00 > 2009-03-09 13:30:00 > > Now I want to compute the delta between the two time points, which results > in this example in 1,5 h. I tried this via "ts" and th

[R] Delta in time series

Hi all, I have time data in the following format: 2009-03-09 12:00:00 2009-03-09 13:30:00 Now I want to compute the delta between the two time points, which results in this example in 1,5 h. I tried this via "ts" and the related functions but so far without sucess. Can anybody help me? Thank y

[R] Excel Export in a beauty way

Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there

[R] Surface for R outside of R

Hi all, i am new here and this is my first posting. My coding experience in R ist okay, but I have a problem which is related to another aspect of R. I am searching for a surface which execute my commands in R via a click on a button OUTSIDE of R. Concrete: I will write some programs in R and wa