gdemin/excel.link

getting full path to open workbooks

randomee opened this issue · 3 comments

Is there a way for xl.workbooks() to return the full path to the open workbooks?

I will add it in the next version. By now you can use quick workaround:

# define function
xl.fullnames = function(){
    workbooks_ref =  xl()[["workbooks"]]
    sapply(seq_len(workbooks_ref[["count"]]), function(i) workbooks_ref[[i]][["fullname"]])
}

# get full names of the open workbooks
xl.fullnames()

Thanks!

Argument full.names was added to xl.workbooks in the version 0.9.7.