search

dgorissen / pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph
GNU General Public License v3.0
573 stars 152 forks source link

Error when launching pycel from pyxll add-in #1

Closed maxmanfren closed 12 years ago

maxmanfren commented 12 years ago

Hi, when I launch the cell compilation (Compile selection) from excel 2007 using the pyxll add-in I get the following error (it pop-up one menu):

————————— PyXLL Error ————————— Error calling function for menu item Compile selection

[global name 'excellib' is not defined] ————————— OK —————————

I don't know how to solve this problem, which is related with the global/local role of the file excellib. Thanks a lor for the help

maxmanfren commented 12 years ago

The problem was simply related to the presence in the file "excelcompiler.py" of both "import excellib" and "from excellib import *" commands, I simply deleted "import excellib" and now everything seems to work fine

dgorissen commented 12 years ago

Great that you fixed it and sorry for not coming back to you sooner. I have been ill for a while and been away on a conference as well. Thanks for reporting back.

maxmanfren commented 12 years ago

Hi Dirk, I have to apologize but the code was correct I run on another pc with Python(xy) and it works correctly (maybe the problem was only related with running it directly from Excel.