autstat Support

This forum is dedicated for support for RExcel.

On topic:

1. Programming model
2. Accessing R via RExcel

Off topic:

1. Installation problems
2. Licensing, pricing
3. Accessing R via statconnDCOM
4. statconnDCOM, SWord
5. Homework

Dear Thomas, first of all i want to say thank you for giving me access to statconnDCOM 3.6-0B6 Home&Student. Today I downloaded and used it with (rcom and rscproxy downloaded from cran archive) with RExcel but unfortunately it failed...... kindly help me in installation of RExcel... I want to use it for "measuRing" package of R for my research work.

with thanks and regards,
Keshav

Keshav,

just had this topic yesterday. Please read http://autstat.com/index.php/Support/topic/67.html

Thomas

Hi Thomas,
I get this error when attempting to put a dataframe from Excel to R.

"Put R Variable
Unknown exception setting variable <data>
System Argument Exception: Value does not fall within expected range.
at statconn.NET.Connectors.IStatConnectorCOM.SetSymbol(String
bstrSymbolName, Object vData)
at
statconn.NET.Connectors.RCOMConnector.statconn.NET.IStatConnector.Set
Symbol(String pSymbol, Object pData)
at statconn.neT.StatConnector.SetSymbol(String pSymbol, Object pData)
at SExcelProto.SExcel.putRValue(String pSymbol, Excel Reference
pReference, Boolean plsDF, Boolean pWithColNames, Boolean
pWithRowNames)
at SExcelProto.SExcel.dialogPutRvalue(EcxcelReference preference)"

I installed the current beta version of SExcel4 with the installer. The SExcel ribbon works when I set the foreground connect to R version 3.4.0 32 bit. I'm using the Home/Student license.
Regards,
Michael

Hi Thomas,

I have recently downloaded SExcel and was trying to run a simple macro. I get the following error when using PutDataframe in VBA:

Run-time error '-2146233088 (80131500)':
Exception if type 'ExcelDna.Integration.XlCallException' was thrown.

Below is the macro I was trying to run.

Sub Regression()
Dim rintf As RInterface
Set rintf = New RInterface
rintf.PutDataframe "mydf", Range("Sheet2!A1:B20")
rintf.GetArray "lm(y ~ x, data = mydf)$coefficients", Range("Sheet2!F3:F4")
End Sub

Any help on this error would be much appreciated.

Many thanks,
Ben

Ben,

first of all: if possible, please open a new topic instead of replying to an existing one.

Next: which line does the error occur?

Best,
Thomas

Apologies.

The error occurs on
rintf.PutDataframe "mydf", Range("Sheet2!A1:B20")

Cheers,
Ben

sorry, will not answer in this thread any more. You can provide the data to reproduce the problem (minimum example preferred). But please use a new thread!