setMissingValue-methods(XLConnect)
setMissingValue-methods()所属R语言包：XLConnect
Setting missing value identifiers
设置缺失值的标识符
译者：生物统计家园网 机器人LoveR
描述----------Description----------
Defines the set of missing value strings used when reading and writing data.
定义了一组字符串，用于读取和写入数据时，缺失值。
用法----------Usage----------
## S4 method for signature 'workbook,ANY'
setMissingValue(object,value)
参数----------Arguments----------
参数：object
The workbook to use
workbook使用
参数：value
character vector of missing value identifiers that are recognized as missing (NA) when reading data. The first element of this vector will be used as missing value identifier when writing data. If value = NULL (default), missing values are represented by blank cells and only blank cells are recognized as missing.
character向量被确认为失踪（NA）读取数据时的遗漏值的标识符。缺失值的标识符写入数据时，将被用作此向量的第一个元素。 value = NULL如果（默认），遗漏值的空白单元格表示，只有空白单元格被确认为失踪。
Details
详细信息----------Details----------
If there are no specific missing value identifiers defined the default behavior is to map missing values to blank (empty) cells. Otherwise, each string cell is checked if it matches one of the defined missing value identifiers. In addition, the first missing value identifier (i.e. the first element of the value argument) is used to represent missing values when writing data.<br> Note that the missing value mapping only works with string identifiers. If you want to use e.g. numeric missing value identifiers such as e.g. -9999 then you have to perform the mapping manually (i.e. replace items with NA before writing / replace items with NA after reading).
如果没有特定的遗漏值的标识符定义的默认行为是空白（空）单元缺失值映射。否则，每串电池检查它是否符合定义的缺失值的标识符。此外，缺失值的标识符（即第一个元素的value参数）用于写入数据时表示遗漏值，遗漏值映射<br>请注意，只适用于字符串标识符。如果你想使用例如数字标识符，如遗漏值-9999“，那么你必须手动执行的映射（即替换项目NA/写前更换NA后读数）。
（作者）----------Author(s)----------
Martin Studer<br>
Mirai Solutions GmbH <a href="http://www.mirai-solutions.com">http://www.mirai-solutions.com</a>
参见----------See Also----------
workbook, writeNamedRegion, writeWorksheet
workbook，writeNamedRegion，writeWorksheet
实例----------Examples----------
# Load workbook (create if not existing)[负载工作簿（如果不存在创建）]
wb <- loadWorkbook("missingValue.xlsx", create = TRUE)
# Create a worksheet named 'airquality'[创建一个工作表名为“airquality的”]
createSheet(wb, name = "airquality")
# Create a named region called 'airquality' on the sheet called[创建一个命名的区域称为“airquality在纸张上称为]
# 'airquality'[“airquality”]
createName(wb, name = "airquality", formula = "airquality!$A$1")
# Set the missing value string to 'missing'[缺失值的字符串“失踪”]
setMissingValue(wb, value = "missing")
# Write built-in data set 'airquality' to the above defined named region[内置的数据集airquality上述定义的命名区域写]
writeNamedRegion(wb, airquality, name = "airquality")
# Save workbook[保存工作簿]
saveWorkbook(wb)
转载请注明:出自 生物统计家园网(http://www.biostatistic.net)。
注：
注1：为了方便大家学习，本文档为生物统计家园网机器人LoveR翻译而成，仅供个人R语言学习参考使用，生物统计家园保留版权。
注2：由于是机器人自动翻译，难免有不准确之处，使用时仔细对照中、英文内容进行反复理解，可以帮助R语言的学习。
注3：如遇到不准确之处，请在本贴的后面进行回帖，我们会逐渐进行修订。
|
发表于 2012-10-1 23:29:18
