Computational Statistics

, Volume 22, Issue 1, pp 91–108

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

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.


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–721MATHCrossRefMathSciNetGoogle 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