[python-win32] Reading .py or .pyc from an excel sheet

Tim Golden mail at timgolden.me.uk
Mon Feb 4 10:21:28 CET 2008


Pallavi Apotikar wrote:
> I am sorry, instead of "file", I should have said "a python function". 
> 
> Is it possible to access/use a python function from Excel VB Editor e.g. a 
> library function called "eval()" is used to detect whether the 
> expression/datatype is a valid python expression/datatype ?  Can we do 
> that?

Well as far as I can see, there's nothing to stop you instantiating
a Python interpreter via COM from Excel (class name is
"Python.Interpreter") and then use .Eval or .Exec to do things.
I'm not sure just how much this will buy you, but it should at
least be possible.

TJG


More information about the python-win32 mailing list