pythonexceloffice-addinsexcel-addinsxlwings

Using Excel Add-in xlwings gives end of file error

I have installed xlwings in anaconda's base environment and installed the excel add-in as well. I have been able to import User-Defined Functions. However, recently, it has started to bug out. Whenever I click on the xlwings ribbon in excel, it gives the following error:

Input past end of file (Error 62)

enter image description here

Any button I press in the xlwings ribbon gives the same result. I have xlwings exclusively for UDF use, so this has paralyzed my ability to get any use out of it. Any help in getting this add-in rehabilitated is greatly appreciated.

Thanks!

EDIT: Here's some more info as per @BigBen's request)

I clicked the 'Import Functions' button in the xlwings ribbon and it gave me the screenshotted error. I clicked debug and it brought me here:

enter image description here

Solution

  • This appears to be the same issue as this GitHub issue.

    And this is what xlwings.conf looks like on my desktop: enter image description here

    To fix, as commented here:

    Not quite sure how it ended up like this but fix your config file so it reads:

    "INTERPRETER","C:\ProgramData\Anaconda3\python.exe"