Skip to main content

Excel :: COM :: \(\mathsf{R}\)


\(\mathsf{R}\) is a powerful system for statistical computing. Its great flexibility makes it the perfect tool for a wide range of applications. Unfortunately this flexibility also leads to a level of complexity which is hard to handle for the casual user. On the other hand tools like Microsoft Excel are very easy to handle but are not well-suited for more complex applications. This article describes how to make use of the flexibility of \(\mathsf{R}\) while still providing a familiar and easy to use GUI in Microsoft Excel. We will provide a description of the design and show the various ways of installation and user interaction with \(\mathsf{R}\) using Excel.

This is a preview of subscription content, access via your institution.


  • ActiveState Tool Corporation (2000) Active Perl, edn, ActiveState Tool Corporation.

  • Baier T (2005) rcom: R COM Client Interface and internal COM Server. R package version 1.2.1.

  • Baier T, Neuwirth E (2005) R (D)COM Server V2.00.

  • Chambers JM (1998) Programming with Data, Springer, New York. ISBN 0-387-98503-4

  • Cluts N (2001) Microsoft activex controls overview, in ‘MSDN Library’, Vol. Backgrounders, Microsoft Corporation.

  • DuBois P (2000) MySQL. New Riders

  • Eaton JW (2005) Octave: interactive language for numerical computations. University of Wisconsin, Department of Chemical Engineering.

  • Flanagan D (2001) JavaScript: the definitive guide, 4th edn. O’Reilly Media, Inc. ISBN 0596000480

  • Fox J with contributions from Michael Ash, Grosjean P, Maechler M, Putler D, Wolf P (2005) Rcmdr: R Commander. R package version 1.1-1, http://www.socserv.socsci.

  • Free Software Foundation (1991) GNU GENERAL PUBLIC LICENSE. Version 2

  • Free Software Foundation (1999) GNU LESSER GENERAL PUBLIC LICENSE. Version 2.1

  • Hornik K (2005) The R FAQ. ISBN 3-900051-08-9.

  • Insightful Corporation (2005) S-PLUS 7’.

  • James D, DebRoy S (2005) RMySQL

  • Lang DT (2005a) RDCOMClient: R-DCOM client. R package version 0.91-0.,,

  • Lang DT (2005b) RDCOMServer: R-DCOM object server. R package version 0.6-0.,,

  • Lang DT (2005c) XML: Tools for parsing and generating XML within R and S-Plus. R package version 0.99-1.

  • Lapsley M, Ripley BD (2005) RODBC: ODBC database access. R package version 1.1-4

  • Martelli A (2003) Python in a Nutshell. O’Reilly Media, Inc. ISBN 0596001886

  • McCullough BD, Wilson B (2002). On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP. Comput Stat Data Anal 40:713–721

    MATH  Article  MathSciNet  Google Scholar 

  • McNab E, Swart RE, Hinks P, Horn D, Jansen A, Jewell D, Wako W, Winning C (1996) The Revolutionary Guide to Delphi 2. Peer Information Inc. ISBN 1874416672

  • Microsoft Corporation (2001a) Common language runtime. In: ‘MSDN Library’, vol. .NET Framework SDK, Microsoft Corporation.

  • Microsoft Corporation (2001b) Microsoft office 2000/visual basic programmer’s guide. In: ‘MSDN Library’, vol. Office 2000 Documentation, Microsoft Corporation. http://www.msdn.

  • Microsoft Corporation (2001c) Visual basic. In: ‘MSDN Library’, vol. Visual Studio 6.0 Documentation, Microsoft Corporation.

  • Microsoft Corporation & Digital Equipment Corporation (1995) The component object model specification, Technical Report 0.9, Microsoft Corporation (Draft)

  • Mono Project (2006) The Mono Project.

  • Nardi BA (1993) A Small Matter of Programming. MIT Press, Boston. ISBN 0-262-14053-5

  • Neuwirth E, Arganbright D (2003) Mathematical Modeling with Microsoft Excel, Thomson-Brooks/Cole. ISBN 0-534-42085-0. ?fid=M2b&product_isbn_issn=0534420850&discipline_number=1

  • Object Management Group I (2002) Common object request broker architecture: Core specification, Technical report, Object Management Group, Inc. 3.0

  • (2006) OpenOffice.

  • R-core members, DebRoy S, Bivand R, others: see COPYRIGHTS file in the sources (2005) foreign: Read Data Stored by Minitab, S, SAS, SPSS, Stata, Systat, dBase. R package version 0.8-10

  • R Development Core Team (2005a) An introduction to R, R Foundation for statistical computing, Vienna ISBN 3-900051-12-7

  • R Development Core Team (2005b) R: a language and environment for statistical computing, R Foundation for Statistical Computing. Vienna. ISBN 3-900051-07-0

  • R Development Core Team (2005c) R Data Import/Export, R foundation for statistical computing, Vienna, ISBN 3-900051-10-0

  • R Development Core Team (2005d) R installation and administration, R foundation for statistical computing. Vienna, ISBN 3-900051-09-7

  • R Development Core Team (2005e) R language definition, R foundation for statistical computing. Vienna, ISBN 3-900051-13-5

  • R Development Core Team (2005f) Writing R extensions, R foundation for statistical computing. Vienna, ISBN 3-900051-11-9

  • Stallman RM (2005) Using and porting GCC, 2.95 edn. Free Software Foundation.

  • Wall L, Christiansen T, Schwartz R (1996) Programming perl. O’Reilly & Associates. ISBN 1-56592-149-6

Download references

Author information

Authors and Affiliations


Corresponding author

Correspondence to Erich Neuwirth.

Rights and permissions

Reprints and Permissions

About this article

Cite this article

Baier, T., Neuwirth, E. Excel :: COM :: \(\mathsf{R}\) . Computational Statistics 22, 91–108 (2007).

Download citation

  • Accepted:

  • Published:

  • Issue Date:

  • DOI:


  • Client Application
  • Object Management Group
  • Digital Equipment Corporation
  • Menu Item
  • Common Object Request Broker Architecture