search

gdemin / excel.link

Convenient Data Exchange between R and Microsoft Excel
56 stars 16 forks source link

没有"createCOMReference"这个函数 #32

Open jiangxincode opened 1 month ago

jiangxincode commented 1 month ago 
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"这个函数
gdemin commented 1 month ago

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.

jiangxincode commented 1 month ago

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