Computational Statistics

, Volume 22, Issue 1, pp 91–108 | Cite as

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

  • Thomas Baier
  • Erich NeuwirthEmail author
Original Paper


\(\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.


Client Application Object Management Group Digital Equipment Corporation Menu Item Common Object Request Broker Architecture 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. ActiveState Tool Corporation (2000) Active Perl, edn, ActiveState Tool Corporation. Scholar
  2. Baier T (2005) rcom: R COM Client Interface and internal COM Server. R package version 1.2.1.Google Scholar
  3. Baier T, Neuwirth E (2005) R (D)COM Server V2.00. Scholar
  4. Chambers JM (1998) Programming with Data, Springer, New York. ISBN 0-387-98503-4 Scholar
  5. Cluts N (2001) Microsoft activex controls overview, in ‘MSDN Library’, Vol. Backgrounders, Microsoft Corporation. Scholar
  6. DuBois P (2000) MySQL. New RidersGoogle Scholar
  7. Eaton JW (2005) Octave: interactive language for numerical computations. University of Wisconsin, Department of Chemical Engineering. Scholar
  8. Flanagan D (2001) JavaScript: the definitive guide, 4th edn. O’Reilly Media, Inc. ISBN 0596000480Google Scholar
  9. 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. Scholar
  10. Free Software Foundation (1991) GNU GENERAL PUBLIC LICENSE. Version 2Google Scholar
  11. Free Software Foundation (1999) GNU LESSER GENERAL PUBLIC LICENSE. Version 2.1Google Scholar
  12. Hornik K (2005) The R FAQ. ISBN 3-900051-08-9. Scholar
  13. Insightful Corporation (2005) S-PLUS 7’. Scholar
  14. James D, DebRoy S (2005) RMySQLGoogle Scholar
  15. Lang DT (2005a) RDCOMClient: R-DCOM client. R package version 0.91-0.,, Scholar
  16. Lang DT (2005b) RDCOMServer: R-DCOM object server. R package version 0.6-0.,, Scholar
  17. Lang DT (2005c) XML: Tools for parsing and generating XML within R and S-Plus. R package version 0.99-1. Scholar
  18. Lapsley M, Ripley BD (2005) RODBC: ODBC database access. R package version 1.1-4Google Scholar
  19. Martelli A (2003) Python in a Nutshell. O’Reilly Media, Inc. ISBN 0596001886Google Scholar
  20. McCullough BD, Wilson B (2002). On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP. Comput Stat Data Anal 40:713–721zbMATHCrossRefMathSciNetGoogle Scholar
  21. 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 1874416672Google Scholar
  22. Microsoft Corporation (2001a) Common language runtime. In: ‘MSDN Library’, vol. .NET Framework SDK, Microsoft Corporation. Scholar
  23. Microsoft Corporation (2001b) Microsoft office 2000/visual basic programmer’s guide. In: ‘MSDN Library’, vol. Office 2000 Documentation, Microsoft Corporation. http://www.msdn. Scholar
  24. Microsoft Corporation (2001c) Visual basic. In: ‘MSDN Library’, vol. Visual Studio 6.0 Documentation, Microsoft Corporation. Scholar
  25. Microsoft Corporation & Digital Equipment Corporation (1995) The component object model specification, Technical Report 0.9, Microsoft Corporation (Draft)Google Scholar
  26. Mono Project (2006) The Mono Project. Scholar
  27. Nardi BA (1993) A Small Matter of Programming. MIT Press, Boston. ISBN 0-262-14053-5 Scholar
  28. 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=1Google Scholar
  29. Object Management Group I (2002) Common object request broker architecture: Core specification, Technical report, Object Management Group, Inc. 3.0Google Scholar
  30. (2006) OpenOffice. Scholar
  31. 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-10Google Scholar
  32. R Development Core Team (2005a) An introduction to R, R Foundation for statistical computing, Vienna ISBN 3-900051-12-7Google Scholar
  33. R Development Core Team (2005b) R: a language and environment for statistical computing, R Foundation for Statistical Computing. Vienna. ISBN 3-900051-07-0 http://www.R-project.orgGoogle Scholar
  34. R Development Core Team (2005c) R Data Import/Export, R foundation for statistical computing, Vienna, ISBN 3-900051-10-0Google Scholar
  35. R Development Core Team (2005d) R installation and administration, R foundation for statistical computing. Vienna, ISBN 3-900051-09-7Google Scholar
  36. R Development Core Team (2005e) R language definition, R foundation for statistical computing. Vienna, ISBN 3-900051-13-5Google Scholar
  37. R Development Core Team (2005f) Writing R extensions, R foundation for statistical computing. Vienna, ISBN 3-900051-11-9Google Scholar
  38. Stallman RM (2005) Using and porting GCC, 2.95 edn. Free Software Foundation. Scholar
  39. Wall L, Christiansen T, Schwartz R (1996) Programming perl. O’Reilly & Associates. ISBN 1-56592-149-6Google Scholar

Copyright information

© Springer-Verlag 2007

Authors and Affiliations

  1. 1.Department of StatisticsVienna University of TechnologyViennaAustria
  2. 2.Department of Scientific ComputingUniversity of ViennaViennaAustria

Personalised recommendations