xlcDump(XLConnect)
xlcDump()所属R语言包:XLConnect
Dumping data sets to Excel files
倾倒到Excel文件中的数据集
译者:生物统计家园网 机器人LoveR
描述----------Description----------
Dumps data sets to Excel files by writing each object to a separate worksheet.
转储数据集的Excel文件写入到一个单独的工作表中的每个对象。
用法----------Usage----------
xlcDump(list, ..., file = "dump.xlsx", pos = -1, overwrite = FALSE)
参数----------Arguments----------
参数:list
character vector of names of objects inside environment pos to dump into an Excel file. Objects will be written using writeWorksheet - as such any object will be coerced to a data.frame. If missing, the list of objects will be determined via the function ls which takes any arguments specified via ....
character矢量内部环境的对象的名称pos转储到一个Excel文件。对象将被写入使用writeWorksheet“ - 因为任何物体都会被强制转换为一个data.frame。如果missing“列表中的对象将确定通过功能ls指定任何参数,通过......
参数:...
Arguments that will be passed to the ls function for getting a list of object names in case the list argument is missing.
,将被传递给一个对象名称列表的情况下,ls的说法是listmissing函数的参数。
参数:file
Excel file to which objects will be dumped. Can be an existing or a new file. Defaults to "dump.xlsx".
Excel文件的对象将被倾倒。可以是现有的或新的文件。默认为"dump.xlsx"的。
参数:pos
Environment in which to look for objects. Can be specified either as an integer specifying the position in the search list, as a character naming an element in the search list or as an environment. Defaults to -1 which refers to the current environment.
环境中寻找对象。可以指定的integersearch列表中指定的位置,作为一个character命名的search列表中的一个元素或作为environment。默认为-1是指目前的环境。
参数:overwrite
logical specifying if data should be overwritten if objects with the same name have already been dumped to the Excel file.
logical指定如果数据被覆盖,如果具有相同名称的对象已经被倾倒的Excel file。
Details
详细信息----------Details----------
Each object is written to a separate worksheet named by the name of the object. Objects are written using the writeWorksheet method - as such any object will be coerced to data.frame.
每个对象被写入到一个单独的工作表中的对象的名称命名。对象是用writeWorksheet方法 - 任何这样的对象将被强制转换为data.frame。
值----------Value----------
Named logical vector specifying if objects have been dumped or not. An object may not be dumped because there was an issue with the coercion to a data.frame or the object already existed (and overwrite = FALSE) in the workbook.
名为logical如果对象已被倾倒或不向量确定。一个对象可能不会被弃置,因为有一个问题与胁迫data.frame或对象已存在(和overwrite = FALSE)在工作簿中。
(作者)----------Author(s)----------
Martin Studer<br>
Mirai Solutions GmbH <a href="http://www.mirai-solutions.com">http://www.mirai-solutions.com</a>
参见----------See Also----------
xlcRestore, writeNamedRegion, writeWorksheet, writeNamedRegionToFile, writeWorksheetToFile, xlcEdit
xlcRestore,writeNamedRegion,writeWorksheet,writeNamedRegionToFile,writeWorksheetToFile,xlcEdit
实例----------Examples----------
require(datasets)
xlcDump(c("airquality", "CO2", "iris", "PlantGrowth", "swiss"),
file = "myDump.xlsx", pos = "package:datasets")
xlcRestore(file = "myDump.xlsx", overwrite = TRUE)
转载请注明:出自 生物统计家园网(http://www.biostatistic.net)。
注:
注1:为了方便大家学习,本文档为生物统计家园网机器人LoveR翻译而成,仅供个人R语言学习参考使用,生物统计家园保留版权。
注2:由于是机器人自动翻译,难免有不准确之处,使用时仔细对照中、英文内容进行反复理解,可以帮助R语言的学习。
注3:如遇到不准确之处,请在本贴的后面进行回帖,我们会逐渐进行修订。
|