search

iliaal / php_excel

PHP Extension interface to the Excel writing/reading library
http://ilia.ws
533 stars 131 forks source link

#REF! when reading formula from cell #263

Closed rvdsarr closed 3 years ago

rvdsarr commented 3 years ago

I am trying to read the formula from a cell which contains a reference to another workbook. Like so:

='c:[test2.xls]A1'

The extension will give me a #REF! back on the filename. Is there anything I can do about this?

do-io commented 3 years ago

unless you have the other file, there is not much you can do. I don't believe you can access that directly from within libxl.