Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

I am using python to write a function and then using xlwings I am trying to import it into Excel but I faced the following error:

My xlwings version is 0.28.5 , and python's is 3.10 , and I am using Excel 2013. also both xlwings32-0.28.5.dll and xlwings64-0.28.5 are in the same folder as the python3.10.exe

the name of the python file and Excel file are the same as instructed by the documentation

I have also tried specifying the python interpreter path in the interpreter box located in the xlwings ribbon in Excel but with no results. I have read the following issues but also with no result:

  • issue766
  • issue764
  • my python function :

    finally I have obviously added the xlwings add-in in Excel, and I trust access to the VBA project object model

    NOTE: Run Python works just fine with no error.

    so, can anyone point to what I am doing wrong or missing?

    thanks in advance.

    Thanks for contributing an answer to Stack Overflow!

    • Please be sure to answer the question . Provide details and share your research!

    But avoid

    • Asking for help, clarification, or responding to other answers.
    • Making statements based on opinion; back them up with references or personal experience.

    To learn more, see our tips on writing great answers .