R/XLL: Interface to call XLL method in R

Posted by Neerav on Stack Overflow See other posts from Stack Overflow or by Neerav
Published on 2012-03-21T15:15:35Z Indexed on 2012/03/21 17:29 UTC
Read the original article Hit count: 500

Filed under:
|
|
|
|

I am trying to call the methods defined in the XLL addin(for Excel) from R.

Something similar to this Python code:

import os
from win32com.client import Dispatch
Path  = 'myxll.xll'
xlApp = Dispatch("Excel.Application")
xlApp.RegisterXLL(Path)

# function call from excel
# =xllfunction("param1","param2",...)

result = xlApp.run('xllfunction', "param1","param2",...)

Is there any library in R that does the XLL interface? Thanks for your help.

© Stack Overflow or respective owner

Related posts about python

Related posts about excel