Hi folks,
Is it possible to have Excel call a R function. If not, how about making Excel
send off a command to call a R script and then read the result back into Excel.
I know, I know, this should belong to some Excel forum, but i just try my luck
here.
Thanks in advance.
Horace W. Tso
You might consider having R do everything: R can read the Excel sheet, do
what needs to be done, and write the results to an Excel sheet.
Charles Annis, P.E.
[EMAIL PROTECTED]
phone: 561-352-9699
eFax: 614-455-3265
http://www.StatisticalEngineering.com
-Original Message-
From
PROTECTED] 6/1/2007 9:03:20 AM
You might consider having R do everything: R can read the Excel sheet, do
what needs to be done, and write the results to an Excel sheet.
Charles Annis, P.E.
[EMAIL PROTECTED]
phone: 561-352-9699
eFax: 614-455-3265
http://www.StatisticalEngineering.com
On Fri, 2007-06-01 at 08:50 -0700, Horace Tso wrote:
Hi folks,
Is it possible to have Excel call a R function. If not, how about
making Excel send off a command to call a R script and then read the
result back into Excel.
I know, I know, this should belong to some Excel forum, but i just
Horace Tso wrote:
Is it possible to have Excel call a R function. If not, how about
making Excel send off a command to call a R script and then read the
result back into Excel.
I know, I know, this should belong to some Excel forum, but i just
try my luck here.
You can always put R
Marc Schwartz wrote:
On Fri, 2007-06-01 at 08:50 -0700, Horace Tso wrote:
Hi folks,
Is it possible to have Excel call a R function. If not, how about
making Excel send off a command to call a R script and then read the
result back into Excel.
I know, I know, this should belong to some
for things like Excel actions to be written as R functions
Tobias Verbeke wrote:
Marc Schwartz wrote:
On Fri, 2007-06-01 at 08:50 -0700, Horace Tso wrote:
Hi folks,
Is it possible to have Excel call a R function. If not, how about
making Excel send off a command to call a R script and then read
the language independent spirit of
DCOM. And it also allows event handlers
for things like Excel actions to be written as R functions
Tobias Verbeke wrote:
Marc Schwartz wrote:
On Fri, 2007-06-01 at 08:50 -0700, Horace Tso wrote:
Hi folks,
Is it possible to have Excel call a R function
at 11:50, Bernardo Rangel tura wrote:
Date sent: Sat, 15 Jul 2006 11:50:14 -0300
To: R-help@stat.math.ethz.ch
From: Bernardo Rangel tura [EMAIL PROTECTED]
Subject:[R] Excel to R
Hi peolple!
I have a many excel tables
Bernardo == Bernardo Rangel tura [EMAIL PROTECTED] writes:
Well I use this scripts to import the database
require(RODBC)
channel - odbcConnectExcel(f:/teste.xls)
data - sqlFetch(channel, Sheet1)
Just convert qw to a factor:
require(RODBC)
channel -
Hi peolple!
I have a many excel tables with mode than 100 variables. And I want
use R to analize that.
But I have a problem, a group of this variables (more than 50) in any
table is a factor and other part is a number.
Tha factors variables have tha values enconde this form (1=Yes,2=No and
)
z - odbcConnectExcel(C:/myspread.xls)
z.df - sqlFetch(z,Sheet1)
close(z)
but the comments interfere with this.
I don't want to manually delete the rows but want the entire
process from Excel file to R to be automatic.
I can accomplish this with a free utility, Baird's dataload
without comments I have had
success with:
require(RODBC)
z - odbcConnectExcel(C:/myspread.xls)
z.df - sqlFetch(z,Sheet1)
close(z)
but the comments interfere with this.
I don't want to manually delete the rows but want the entire
process from Excel file to R to be automatic.
I can accomplish
but want the entire
process from Excel file to R to be automatic.
I can accomplish this with a free utility, Baird's dataload that
I found on the net. This will convert the Excel files to text
and then the text can be processed using R to locate the start of
the header and only process
14 matches
Mail list logo