appendWorksheet-methods(XLConnect)
appendWorksheet-methods()所属R语言包:XLConnect
Appending data to worksheets
将数据追加到工作表
译者:生物统计家园网 机器人LoveR
描述----------Description----------
Appends data to worksheets of a workbook.
将数据追加到工作表的workbook。
用法----------Usage----------
## S4 method for signature 'workbook,ANY,character'
appendWorksheet(object,data,sheet,header,rownames)
## S4 method for signature 'workbook,ANY,numeric'
appendWorksheet(object,data,sheet,header,rownames)
参数----------Arguments----------
参数:object
The workbook to write to
workbook写
参数:data
Data to append
要追加的数据
参数:sheet
The name or index of the sheet to append the data to
表的名称或索引的附加data
参数:header
Specifies if the column names should be written. The default is TRUE.
指定的列名应写。默认的TRUE。
参数:rownames
Name (character) of column to use for the row names of the provided data object. If specified, the row names of the data object (data.frame) will be included as an additional column with the specified name. If rownames = NULL (default), no row names will be included.
名称(character)用于提供data对象的行的名称的列。如果指定的行名的数据对象(data.frame)将包含一个额外的列具有指定名称。如果rownames = NULL(默认),则没有行名称将被列入。
Details
详细信息----------Details----------
Appends data to the worksheet specified by sheet. Data will be appended at the bottom and left most column containing some data. If more complex "appending schemes" are required you may make direct use of writeWorksheet.
追加data到工作表指定的sheet。数据将被附加在底部,最左边一栏包含一些数据。如果需要更复杂的“追加计划”,您可以直接使用的writeWorksheet。
(作者)----------Author(s)----------
Martin Studer<br>
Mirai Solutions GmbH <a href="http://www.mirai-solutions.com">http://www.mirai-solutions.com</a>
参见----------See Also----------
workbook, writeWorksheet, readWorksheet, writeNamedRegion, appendNamedRegion, readNamedRegion
workbook,writeWorksheet,readWorksheet,writeNamedRegion,appendNamedRegion,readNamedRegion
实例----------Examples----------
# mtcars xlsx file from demoFiles subfolder of package XLConnect[mtcars xlsx文件demoFiles子文件夹中的包XLConnect]
demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")
# Load workbook[负载工作簿]
wb <- loadWorkbook(demoExcelFile)
# Append mtcars data set to worksheet named 'mtcars'[附加mtcars数据设置工作表名为“mtcars的”]
appendWorksheet(wb, mtcars, sheet = "mtcars")
转载请注明:出自 生物统计家园网(http://www.biostatistic.net)。
注:
注1:为了方便大家学习,本文档为生物统计家园网机器人LoveR翻译而成,仅供个人R语言学习参考使用,生物统计家园保留版权。
注2:由于是机器人自动翻译,难免有不准确之处,使用时仔细对照中、英文内容进行反复理解,可以帮助R语言的学习。
注3:如遇到不准确之处,请在本贴的后面进行回帖,我们会逐渐进行修订。
|