Skip to main content

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

Abstract

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

References

  • ActiveState Tool Corporation (2000) Active Perl, 5.6.0.618 edn, ActiveState Tool Corporation. http://www.ActiveState.com/ActivePerl/

  • 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. http://www.cran.r-project.org/other/DCOM

  • Chambers JM (1998) Programming with Data, Springer, New York. ISBN 0-387-98503-4 http://www.cm.bell-labs.com/cm/ms/departments/sia/Sbook/

  • Cluts N (2001) Microsoft activex controls overview, in ‘MSDN Library’, Vol. Backgrounders, Microsoft Corporation. http://www.msdn.microsoft.com/

  • DuBois P (2000) MySQL. New Riders

  • Eaton JW (2005) Octave: interactive language for numerical computations. University of Wisconsin, Department of Chemical Engineering. http://www.octave.org/doc/index.html

  • 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.r-project.org, http://www.socserv.socsci. mcmaster.ca/jfox/Misc/Rcmdr/

  • 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. http://www.CRAN.R-project.org/doc/FAQ/

  • Insightful Corporation (2005) S-PLUS 7’. http://www.insightful.com/products/splus/

  • James D, DebRoy S (2005) RMySQL

  • Lang DT (2005a) RDCOMClient: R-DCOM client. R package version 0.91-0. http://www.omegahat.org/RDCOMClient, http://www.omegahat.org, http://www.omegahat.org/bugs

  • Lang DT (2005b) RDCOMServer: R-DCOM object server. R package version 0.6-0. http://www.omegahat.org/RDCOMServer, http://www.omegahat.org, http://www.omegahat.org/bugs

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

  • 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. http://www.msdn.microsoft.com/

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

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

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

  • Mono Project (2006) The Mono Project. http://www.mono-project.com/

  • Nardi BA (1993) A Small Matter of Programming. MIT Press, Boston. ISBN 0-262-14053-5 http://mitpress.mit.edu/catalog/item/default.asp?ttype=2&tid=6799

  • Neuwirth E, Arganbright D (2003) Mathematical Modeling with Microsoft Excel, Thomson-Brooks/Cole. ISBN 0-534-42085-0. http://www.brookscole.com/cgi-wadsworth/ course_products_wp.pl ?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

  • OpenOffice.org (2006) OpenOffice. http://www.openoffice.org/

  • 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 http://www.R-project.org

  • 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. http://gcc.gnu.org/

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

Download references

Author information

Authors and Affiliations

Authors

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). https://doi.org/10.1007/s00180-007-0023-6

Download citation

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s00180-007-0023-6

Keywords

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