UDF RExec in R_connection_examples.xlsm Error in R script due to "," decimal point (?)

Question

UDF RExec in R_connection_examples.xlsm Error in R script due to "," decimal point (?)

jacekkotowski opened this issue 7 years ago · 6 comments

In Poland I am using US version of Excel with Polish locales. All excel formula parameters are separated with ";" and all decimal points are ","
It is probably why UDF RExec fails to execute throwing "Error in R script."
If it is an issue, is it possible to add parameter for decimal point?

I am afraid separator can also be an issue, since I often read csv's with csv2 function or specify ";" as separator. Is it possible also to specify separator?

Maybe it is possible to set both decimal point and separator globally for a session with one command like in data.pasta package?

It is also possible, that some other issue related to local settings may interfere like a symbol separating rows in matrix (?)

I would like to thank you for sharing this wonderful, very promising project! It ma be great in environments where Excel rules and it is a struggle to promote R as a better tool.

Answer 1 · 2017-10-27T12:30:42.000Z

Could you provide example of your code/spreadsheet?

In most cases decimal separator is converted internally. I didn't encounter any problem with it nevertheless is it comma or point.

Answer 2 · 2017-10-27T13:37:44.000Z

Dear Gregory, I am using your spreadsheet (R_connection_examples.xlsm) from github of excel.link Anything I try to use results in Run-time error '-2147220482(900403fe)' Error in R script. Debugger shows line in function: Public Function ExecInR The line is: Err.Raise vbObjectError + 1022, Source:="RCaller module.ExecInR", Description:="Error in R script." I needed to change path to my R installation, because there was no path in SET PATH and I have no access to it. there is a space in the path, but the VBA seems to work ok, talk to R, but the result is wrong. I do not know what happened. I enclose the file. I wish you all the best. Jacek Kotowski http://wypadek-uminskiego.blogspot.com/ Postawmy sygnalizację na przejściu Umińskiego przy SP312! ====================== http://jakprzetlumaczyc.blogspot.com (prywatny blog zawodowy, data mining, R, excel) ====================== http://www.linkedin.com/in/jacekkotowski tel +48 605961341 jacek.kotowski@gmail.com skype:beckett71

…

On Fri, Oct 27, 2017 at 2:30 PM, Gregory Demin ***@***.***> wrote: Could you provide example of your code/spreadsheet? In most cases decimal separator is converted internally. I didn't encounter any problem with it nevertheless is it comma or point. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#13 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AKjzUqbNoGBy7L8Rz7DUOVXHKZAG__8Xks5swczygaJpZM4QI6T_> .

Answer 3 · 2017-10-27T16:56:00.000Z

Sorry, I don't see the file. Could you attach it one more time?
Also it may be useful if you give me sessionInfo() ouput in your R console.

Answer 4 · 2017-10-27T21:10:46.000Z

Please, try new R_connection_examples.xlsm. I made some fixes and I hope it will work.

Answer 5 · 2017-10-30T10:18:24.000Z

It works now. I will play with it extensively to see if anything shows up. Thanks very much.
I wish you all the best.

Answer 6 · 2018-03-17T21:42:33.000Z

Fixed in version 0.9.8