Menu

Linking Python docstrings to Excel Function Wizard

2014-05-10
2014-05-10
  • Doug Jenkins

    Doug Jenkins - 2014-05-10

    One of the nice features of Pyxll is that the text in the Python docstrings is automatically linked to the Excel Function Wizard. Also you can allocate the function to a help topic, through the function @XLfunc decorator. This makes documenting UDF usage easier with Python than it is with VBA!

    Is there any way to do this with ExcelPython?

     
    • Eric Reynolds

      Eric Reynolds - 2014-05-10

      Not that I know of, besides ExcelPython does not dynamically define UDFs as
      it is not an Excel add-in but a COM typelib.

      The idea of ExcelPython is to provide a limited set of primitive functions
      for manipulating Python objects which can then be built upon to do what you
      need, rather than ready made solutions for everything.

      When I have a moment I'll see if I can come up with a few recipes for doing
      the kind of thing you want to do.

       
      • Doug Jenkins

        Doug Jenkins - 2014-05-10

        Thanks Eric. If you do find the time to have a look at that I'd really appreciate it. Also I'll post here if I find a solution myself.

         

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.