search

vallettea / koala

Transpose your Excel calculations into python for better performances and scaling.
GNU General Public License v3.0
147 stars 59 forks source link

User Defined Function (UDF) support #169

Closed Brad-eki closed 5 years ago

Brad-eki commented 5 years ago

Has anyone put thought or effort into having Koala support user defined functions (UDF)?

vallettea commented 5 years ago

No

Envoyé de mon iPhone

Le 26 mars 2019 à 12:41, Brad-eki notifications@github.com a écrit :

Has anyone put thought or effort into having Koala support user defined functions (UDF)?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

Brad-eki commented 5 years ago

I think I can see a pathway for this.

Recently I have been using Koala in conjunction with a product called xlwings. The combination is extraordinarily powerful in sci/eng data analysis and modelling work.

If you don't know, xlwings is an Excel plugin that manages the COM layer between Excel and Python and has bridged the gap between Pandas+NumPy objects and Excel. There are many other features, like a REST server, Python User Defined Functions (UDF) and the ability to call Visual Basic from Python.

I am thinking that it may well be possible to import xlwings into Koala and utilize its ability to run Visual Basic (I expect VB UDFs) as well as the Python defined UDFs. It would then just be a case of having the Excel function recognition in Koala to be flexible enough to recognize UDFs and choose how to run them "on-the-fly".