I am new to this tool and I find this very useful for my work.
I am creating a plug-in for excel to be able to call python functions from within excel just like any inbuilt excel function.
For this, I am creating Python objects and calling the python function in C++ using PyImport.Import after converting the file name (in string) to a PyObject and so on.
The code compiles successfully and returns the desired output when compiled and run as a C++ program.
I tried to create an excel add-in by following the example in the video and got the code to build without any errors. However, when I call the function from Excel, excel crashes each time. I am not sure what is causing this error.
I will share the code if required. I would be glad if someone can help. Thanks.