Forum

Notifications
Clear all

Error Code #Name when using Pyxll and Python

6 Posts
2 Users
0 Reactions
218 Views
(@henrikl)
Posts: 5
Active Member
Topic starter
 

Hi,

The errorcode #Name? occurs when I am trying to use the files in one of your newsletter.

I have istalled Pyxll and Phyton. I havent done any chnages in the code. 

 

Br

Henrik

 
Posted : 28/04/2020 1:13 am
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Henrik,

Have you added the Python module names to your pyxll.cfg file as described here:

https://www.pyxll.com/docs/userguide/udfs/introduction.html

Regards

Phil

 
Posted : 28/04/2020 6:32 am
(@henrikl)
Posts: 5
Active Member
Topic starter
 

Hi,

Yes I have.

It didn´t work, insted got I following error message: "moth_coin_rtd":No module name request

I still dont get how the function =coin_price_rtd(LOWER(A8)) is connected to the "moth_coin_rtd" Python module.

Thanks in advance

Br

Henrik

 
Posted : 28/04/2020 8:34 am
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Henrik,

Where did you get this error?  In Excel?  Pleas supply screenshots.

If you have the name(s) of the module(s) in the PyXLL config file, you also need to have the python module(s) 'moth_coin_rtd.py' in the PyXLL folder.  The same folder as the pyxll.cfg file.

If it's still not working please attach your pyxll.cfg file, the python module(s) e.g. moth_coin_rtd.py and the Excel workbook.

Regards

Phil

 
Posted : 28/04/2020 10:44 pm
(@henrikl)
Posts: 5
Active Member
Topic starter
 

Thank you Phil,

I really appricate your support.

After started over from the begining,  reinstalled Python and PyXLL, I managed it make to work properly.

 

Is the function 'coin_price_rtd' a premade class whitin the PyXLL? How does the function know, that I will send the argument to the Python module 'moth_coin_rtd' ? 

 

Br

Henrik

 
Posted : 29/04/2020 3:41 am
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Henrik,

coin_price_rtd is the Python function I wrote and this is stored in the file moth_coin_rtd.py.  Open moth_coin_rtd.py and you'll see the function code.

PyXLL makes the function coin_price_rtd available to Excel - it essentially acts like a bridge between Excel and Python.

Regards

Phil

 
Posted : 29/04/2020 5:24 am
Share: