imported>SchlurcherBot：Bot: http → https

2025-12-14T00:32:54Z

Bot: http → https

新页面

{{Multiple issues|
{{No footnotes|time=2022-11-06T23:02:28+00:00}}
{{Advert|time=2022-11-07T01:26:33+00:00}}
}}
{{NoteTA|G1=IT}}
{{Infobox software|
name = RExcel |
logo = |
screenshot = |
caption = |
developer = [[Erich Neuwirth]] |
latest_release_version = 3.2.9 |
latest_release_date = {{release date and age|2013|01|06|df=y}} |
platform = [[R语言]]、[[Microsoft Excel]]、[[Microsoft Windows]] |
genre = 统计软件、[[電子試算表]] |
license = RExcel Noncommercial license or RExcel Commercial license |
website = [http://www.statconn.com/ www.statconn.com]
}}
'''RExcel'''是[[Microsoft Excel]]的插件。它允許從Excel中訪問[[R语言]]。

主要特點是：

* R和Excel之間雙向數據傳輸（矩陣和數據框）
* 直接從Excel範圍運行R代碼
* 編寫調用R的宏來執行計算而不將R暴露給用戶
* 直接從單元格公式調用R函數，使用Excel的自動更新機制觸發R重新計算
* 使用Excel作為R的[[GUI]]，使R功能可通過菜單和對話框訪問，而不是面向命令行的編程風格。使用此範例，廣泛使用的GUI包RCommander可用作Excel菜單欄。
* RExcel適用於[[Microsoft Windows]]（[[Microsoft Windows XP|XP]]、[[Microsoft Windows Vista|Vista]]或[[Microsoft Windows 7|7]]）以及[[Excel 2003]]、[[Excel 2007|2007]]、2010和2013。它使用statconnDCOM服務器，對於某些配置，還使用rcom包從Excel中訪問R。<ref>{{Cite web |url=http://www.wpssfs.com/ |title=wps office下载 |access-date=2024-10-27 |archive-date=2025-01-28 |archive-url=https://web.archive.org/web/20250128015556/https://www.wpssfs.com/ |dead-url=no }}</ref>

== 参考资料 ==

* Baier T., Neuwirth E., De Meo M: [http://journal.r-project.org/archive/2011-2/RJournal_2011-2_Baier~et~al.pdf Creating and Deploying an Application with (R)Excel and R] {{Wayback|url=http://journal.r-project.org/archive/2011-2/RJournal_2011-2_Baier~et~al.pdf |date=20221106204318 }} R Journal 3/2, December 2011
* Baier T. and Neuwirth. E. Excel :: COM :: R. Computational Statistics 22 (2007)
* Heiberger R. and Neuwirth E. [https://www.springer.com/statistics/computational/book/978-1-4419-0051-7 R Through Excel] {{Wayback|url=https://www.springer.com/statistics/computational/book/978-1-4419-0051-7 |date=20090419163650 }}, Springer Verlag 2009.
* Neuwirth, E. [http://www.statistik.uni-dortmund.de/useR-2008/abstracts/Neuwirth.pdf R meets the Workplace] {{Wayback|url=http://www.statistik.uni-dortmund.de/useR-2008/abstracts/Neuwirth.pdf |date=20221006053742 }} - Embedding R into Excel and making it more accessible. Paper presented at the UseR 2008, Dortmund
* Narasimhan, B. [https://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf Disseminating Statistical Methodology and Results via R and Excel: Two Examples.] {{Wayback|url=https://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf |date=20120213003722 }} Paper presented at the Interface 2007, Philadelphia
* Baier, T., Heiberger, R., Neuwirth, E., Schinagl, K., & Grossmann, W. [https://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf Using R for teaching statistics to nonmajors: Comparing experiences of two different approaches.] {{Wayback|url=https://www.r-project.org/useR-2006/Slides/BaierEtAl.pdf |date=20120213003722 }} Paper presented at the UseR 2006, Vienna.
* Konnert, A. [https://www.r-project.org/useR-2006/Abstracts/Konnert.pdf LabNetAnalysis - An instrument for the analysis of data from laboratory networks based on RExcel] {{Wayback|url=https://www.r-project.org/useR-2006/Abstracts/Konnert.pdf |date=20140103044640 }} Paper presented at the UseR 2006, Vienna.

[[Category:R語言]]

RExcel - 版本历史

imported>SchlurcherBot：​Bot: http → https

imported>SchlurcherBot：Bot: http → https