Skip to content
Prev 43232 / 398521 Next

D(COM) with Excel

Hi,

as the one who wrote the RExcel package let me add something to the 
discussion.

Thomas Baier's R (D)COM package tries to use "native" Windows
data types to be as fast as possible.
My RExcel package has the following philosophy:
Offer R functions to people who "think spreadsheet".
One way of describing it is:
You can have an R process living in each cell of the spreadsheet,
and the output of R we want to deal with hast to be compatible with the
spreadsheet structure. That is the reason for the restriction to
arrays.
Spreadsheets (NOT the embedded programming language)
do not know about objects.

Somewhat oversimplifying one might say:
RExcel brings R computation to the spreadsheet,
and RDCOM brings R objects to VBA.

Erich Neuwirth
David James wrote: