xlsx-package(xlsx)
xlsx-package()所属R语言包：xlsx
Read, write, format Excel 2007 and Excel 97/2000/XP/2003 files
读，写，格式为Excel 2007和Excel 97/2000/XP/2003文件
译者：生物统计家园网 机器人LoveR
描述----------Description----------
The xlsx package gives programatic control of Excel files using R. A high level API allows the user to read a sheet of an xlsx document into a data.frame and write a data.frame to a file. Lower level functionality permits the direct manipulation of sheets, rows and cells. For example, the user has control to set colors, fonts, data formats, add borders, hide/unhide sheets, add/remove rows, add/remove sheets, etc.
xlsx包提供了程序化控制的Excel文件使用R.一个高层次的API，使用户能够读取一个表的xlsx文件到一个data.frame写的data.frame到一个文件中。较低级别的功能，允许直接操作的表，行和单元格。例如，用户可以控制设置颜色，字体，数据格式，添加边框，隐藏/取消隐藏表，添加/删除行，添加/删除表等。
Behind the scenes, the xlsx package uses a java library from the Apache project, http://poi.apache.org/index.html. This Apache project provides a Java API to Microsoft Documents (Excel, Word, PowerPoint, Outlook, Visio, etc.) By using the rJava package that links R and Java, we can piggyback on the excellent work already done by the folks at the Apache project and provide this functionality in R. The xlsx package uses only a subset of the Apache POI project, namely the one dealing with Excel files. All the necessary jar files are kept in package xlsxjars that is imported by package xlsx.
在幕后，xlsx包来自Apache项目中使用Java库，http://poi.apache.org/index.html。此Apache项目提供了一个Java API文档微软的Excel，Word，PowerPoint中时，Outlook，Visio中，等rJava使用的软件包，链接R和Java中，我们可以捎带上已经完成了出色的工作人在Apache项目，并提供此功能R.xlsx的包仅使用Apache POI项目的一个子集，即一个处理Excel文件。所有需要的jar文件都保存在包xlsxjars入口即化的包xlsx。
A collection of tests that can be used as examples are located in folder /tests/. They are a good source of examples of how to use the package.
作为例子，可用于测试集合位于在目录/tests/。他们是一个很好的来源，如何使用包的例子。
Please see http://code.google.com/p/rexcel/ for Wiki and the development version. Issues and questions should be reported using the dedicated mailing list http://groups.google.com/group/R-package-xlsx.
请参阅http://code.google.com/p/rexcel/ Wiki和开发版本。问题和问题使用专用的邮件列表http://groups.google.com/group/R-package-xlsx的，应当报。
Details
详细信息----------Details----------
（作者）----------Author(s)----------
Adrian A. Dragulescu
Maintainer: Adrian A. Dragulescu <adrian.dragulescu@gmail.com>
参考文献----------References----------
http://poi.apache.org/spreadsheet/index.html.
http://poi.apache.org/apidocs/index.html. This can be useful if you are looking for something that is not exposed in R as it may be available on the Java side. Inspecting the source code for some the the R functions in this package can show you how to do it (even if you are Java shy).
参见----------See Also----------
Workbook for ways to work with Workbook
Workbook的方法与Workbook
实例----------Examples----------
## Not run: [＃不运行：]
require(xlsx)
# example of reading xlsx sheets[例如阅读XLSX表中]
file <- system.file("tests", "test_import.xlsx", package = "xlsx")
res <- read.xlsx(file, 2) # read the second sheet[第二片的读]
# example of writing xlsx sheets[例如写的xlsx表中]
file <- tempfile()
write.xlsx(USArrests, file=file)
## End(Not run)[＃（不执行）]
转载请注明:出自 生物统计家园网(http://www.biostatistic.net)。
注：
注1：为了方便大家学习，本文档为生物统计家园网机器人LoveR翻译而成，仅供个人R语言学习参考使用，生物统计家园保留版权。
注2：由于是机器人自动翻译，难免有不准确之处，使用时仔细对照中、英文内容进行反复理解，可以帮助R语言的学习。
注3：如遇到不准确之处，请在本贴的后面进行回帖，我们会逐渐进行修订。
|
发表于 2012-10-1 23:36:22
