CODEWITHSUNDEEP
pythonexceloffice-addinsexcel-addinsxlwings
J_Code
J_Code

Reputation: 65

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

Upvotes: 1

Views: 211

Answers (1)

BigBen
BigBen

Reputation: 50007

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"

Upvotes: 2

Related Questions