isSheetVeryHidden-methods(XLConnect)
isSheetVeryHidden-methods()所属R语言包:XLConnect
Checking if worksheets are very hidden in a workbook
检查,如果工作表在工作簿中隐藏
译者:生物统计家园网 机器人LoveR
描述----------Description----------
Checks if the specified worksheets are very hidden (but not just hidden) in a workbook.
如果指定的工作表的检查非常隐蔽(但不只是被隐藏了)在一个workbook。
用法----------Usage----------
## S4 method for signature 'workbook,character'
isSheetVeryHidden(object,sheet)
## S4 method for signature 'workbook,numeric'
isSheetVeryHidden(object,sheet)
参数----------Arguments----------
参数:object
The workbook to use
workbook使用
参数:sheet
The name or index of the sheet to check
的名称或索引表检查
Details
详细信息----------Details----------
Returns TRUE if the specified named sheet is very hidden (not visible but also not just hidden), otherwise FALSE. sheet is vectorized such that multiple worksheets can be queried with one method call. An exception is thrown if the specified sheet does not exist.
返回TRUE,如果在指定的命名sheet很隐藏(不可见,但也只是被隐藏了),否则FALSE。 sheet量化的多个工作表,可以查询一个方法调用。如果指定的sheet不存在,则抛出异常。
(作者)----------Author(s)----------
Martin Studer<br>
Mirai Solutions GmbH <a href="http://www.mirai-solutions.com">http://www.mirai-solutions.com</a>
参见----------See Also----------
workbook, hideSheet, unhideSheet, isSheetHidden, isSheetVisible
workbook,hideSheet,unhideSheet,isSheetHidden,isSheetVisible
实例----------Examples----------
# Load workbook (create if not existing)[负载工作簿(如果不存在创建)]
wb <- loadWorkbook("isSheetVeryHidden.xlsx", create = TRUE)
# Write a couple of built-in data.frame's into sheets[写一对夫妇的内置数据框的成片]
# with corresponding name[与相应的名称]
for(obj in c("CO2", "airquality", "swiss")) {
createSheet(wb, name = obj)
writeWorksheet(wb, get(obj), sheet = obj)
}
# Very hide sheet 'airquality'[非常隐藏表“airquality”]
hideSheet(wb, sheet = "airquality", veryHidden = TRUE)
# Hide sheet 'CO2'[隐藏表“CO2”]
hideSheet(wb, sheet = "CO2", veryHidden = FALSE)
# Check if sheet 'airquality' is very hidden;[如果表“airquality”是很隐蔽的;]
# this should obviously return TRUE[这显然应该返回TRUE]
isSheetVeryHidden(wb, "airquality")
# Check if sheet 'swiss' is very hidden;[检查表“瑞士”是非常隐蔽的;]
# this should obviously return FALSE[这显然应该返回FALSE]
isSheetVeryHidden(wb, "swiss")
# Check if sheet 'CO2' is very hidden;[检查,如果CO2表“是很隐蔽的;]
# this should also return FALSE - the sheet[这也应该返回FALSE - 表]
# is just hidden but not very hidden[只是被隐藏了,但不是很隐蔽]
isSheetVeryHidden(wb, "CO2")
转载请注明:出自 生物统计家园网(http://www.biostatistic.net)。
注:
注1:为了方便大家学习,本文档为生物统计家园网机器人LoveR翻译而成,仅供个人R语言学习参考使用,生物统计家园保留版权。
注2:由于是机器人自动翻译,难免有不准确之处,使用时仔细对照中、英文内容进行反复理解,可以帮助R语言的学习。
注3:如遇到不准确之处,请在本贴的后面进行回帖,我们会逐渐进行修订。
|