RE: [Rcom-l] Read Excel data

2008-01-25 Thread Uma Sitaraman
NT IN ANY SECURITY.' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Thursday, January 24, 2008 3:49 PM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Read Excel data Sub runtest() Call RInterface.StartRS

Re: [Rcom-l] Read Excel data

2008-01-24 Thread Erich Neuwirth
> Uma > > -Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Erich > Neuwirth > Sent: Wednesday, January 23, 2008 5:12 PM > To: R (D)COM and RExcel server related issues > Subject: Re: [Rcom-l] Read Excel data > > I chec

RE: [Rcom-l] Read Excel data

2008-01-23 Thread Uma Sitaraman
MAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Wednesday, January 23, 2008 5:12 PM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Read Excel data I checked with your code with some modifications, beause I do not have your directories. I got the same error because The th

Re: [Rcom-l] Read Excel data

2008-01-23 Thread Richard M. Heiberger
> It gives me an error "Run-time error 13- Type mismatch" and when I try > to debug, it stops at line below in the RInterface Module. > this looks similar to what I am seeing on Burt's machine. ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at

Re: [Rcom-l] Read Excel data

2008-01-23 Thread Erich Neuwirth
same error. > > > > I am using R (2.5.1) and RSrv200.exe. > > Regards, > > Uma > > > > > > > > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Uma > S

Re: [Rcom-l] Read Excel data

2008-01-23 Thread Erich Neuwirth
both give the same error. > > > > I am using R (2.5.1) and RSrv200.exe. > > Regards, > > Uma > > > > > > > > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [Rcom-l] Read Excel data

2008-01-22 Thread Uma Sitaraman
e same error. I am using R (2.5.1) and RSrv200.exe. Regards, Uma -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Uma Sitaraman Sent: Wednesday, January 23, 2008 9:52 AM To: R (D)COM and RExcel server related issues Subject:

RE: [Rcom-l] Read Excel data

2008-01-22 Thread Uma Sitaraman
Hi, I tried that too. It still gives me the same error. Regards, Uma -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Tuesday, January 22, 2008 7:05 AM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l

Re: [Rcom-l] Read Excel data

2008-01-21 Thread Erich Neuwirth
Uma Sitaraman wrote: > Hi, > > > > I am new to both R and RDcom, and am stuck trying to read excel data > using R (through VBA code). I tried out the test code posted in the web > (given below) > > > > Sub ReadTest() > >> rinterface.StartRServer > >> rinterface.RRun "setwd(""c:

Re: [Rcom-l] Read Excel data

2008-01-21 Thread Felipe Carrillo
Hope this helps: Sub MyMACRO() Call rinterface.StartRServer 'Put the dataframe into R Call rinterface.PutDataframe("dataframeName", Range("Sheet1!A1:D" & Range("D1").End(xlDown).Row)) Call rinterface.RRun("attach(dataframeName)") Call rinterface.StopRServer > I am new to both R and RDcom, and am