excel.link icon indicating copy to clipboard operation
excel.link copied to clipboard

没有"createCOMReference"这个函数

Open jiangxincode opened this issue 1 year ago • 2 comments

R version 4.4.1 (2024-06-14 ucrt) -- "Race for Your Life"
Copyright (C) 2024 The R Foundation for Statistical Computing
Platform: x86_64-w64-mingw32/x64
> origin_df <- excel.link::xl.read.file(
+   "E:/Code/doc/data/abc.xlsx",
+   xl.sheet = "salary_stats",
+   password = "abc"
+ )
错误于createCOMReference(<pointer: 0x0000018733c88d48>, "COMIDispatch"): 
  没有"createCOMReference"这个函数

jiangxincode avatar Jul 07 '24 01:07 jiangxincode

Sorry, I can't reporduce this bug. Try the newest version of excel.link (0.9.13). It will be available on CRAN in a couple of days. If it won't work, please, attach your xlsx file for reproducibility.

gdemin avatar Jul 08 '24 20:07 gdemin

Thanks for your reply. I find it is OK if i use

library(excel.link)
origin_df <- xl.read.file(
  "E:/Code/doc/data/abc.xlsx",
  xl.sheet = "salary_stats",
)

But it is not OK, if i use

origin_df <- excel.link::xl.read.file(
  "E:/Code/doc/data/abc.xlsx",
  xl.sheet = "salary_stats",
)

so it maybe the rules of R language

jiangxincode avatar Jul 20 '24 04:07 jiangxincode