openxlsx 的问题 [英] Trouble with openxlsx

问题描述

当我尝试使用 loadWorkbook 函数加载 xlsx 文件时，我收到一条错误消息.我正在从本地工作目录加载工作簿文件并收到以下错误消息:

When I attempt to load an xlsx file with the loadWorkbook function I receive an error message. I am loading the workbook file from my local working directory and receive the following error message:

grepl(target, commentsXML) 中的错误:模式"参数无效

Error in grepl(target, commentsXML) : invalid 'pattern' argument

当我执行基本功能时:loadWorkbook("template.xlsx") -> wb

when I execute the basic function: loadWorkbook("template.xlsx") -> wb

推荐答案

对我来说，这似乎是一个错误.如果您查看 github 上的源代码，它有以下行:

To me it looks as if it's a bug. If you look at the source on github it has the following line:

hasComment <- sapply(drawXMLrelationship, length) > 0 ## which sheets have a drawing

但是，应该是:

hasComment <- sapply(commentXMLrelationship, length) > 0

这篇关于openxlsx 的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！