autstat Support

icon
Avatar
Thomas Baier
Moderator
Posts: 217
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
2013-11-10 16:26
Avatar
Keshav Upadhyay
Posts: 1
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
2017-07-06 19:14
Avatar
Thomas Baier
Moderator
Posts: 217
Keshav,

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

Thomas
2017-07-07 07:04
Avatar
msemenoff
Posts: 4
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
2017-07-17 22:38
Avatar
benmarjot
Posts: 7
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
2017-07-21 13:44
Avatar
Thomas Baier
Moderator
Posts: 217
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
2017-07-21 14:08
Avatar
benmarjot
Posts: 7
Apologies.

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

Cheers,
Ben
2017-07-21 14:12
Avatar
Thomas Baier
Moderator
Posts: 217
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!
2017-07-21 14:17
icon