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

2008-02-04 Thread Tim Golden
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 ?

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

2008-02-04 Thread Tim Johnson
My machine doesn't seem to recognize Python.Interpreter. Is there some prerequisite that I could be missing? On Feb 4, 2008 1:21 AM, Tim Golden [EMAIL PROTECTED] wrote: Pallavi Apotikar wrote: I am sorry, instead of file, I should have said a python function. Is it possible to access/use

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

2008-02-04 Thread Mark Hammond
2008 10:23 AM To: Tim Golden Cc: python-win32@python.org Subject: Re: [python-win32] Reading .py or .pyc from an excel sheet My machine doesn't seem to recognize Python.Interpreter. Is there some prerequisite that I could be missing? On Feb 4, 2008 1:21 AM, Tim Golden [EMAIL PROTECTED] wrote

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

2008-02-04 Thread Tim Roberts
Tim Johnson wrote: I started out just trying it via vbscript, but when I use the code you provided I get Run-time error '429': ActiveX component can't create object. I'm guessing there's a .dll or something not registered somewhere. I'll do some more digging. If you will forgive

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

2008-02-04 Thread Tim Roberts
Tim Johnson wrote: My machine doesn't seem to recognize Python.Interpreter. Is there some prerequisite that I could be missing? What did you try? I just went into the Excel VBA editor and created a function with this: Dim x As Object Set x = CreateObject(Python.Interpreter) It

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

2008-02-04 Thread Tim Johnson
I started out just trying it via vbscript, but when I use the code you provided I get Run-time error '429': ActiveX component can't create object. I'm guessing there's a .dll or something not registered somewhere. I'll do some more digging. On Feb 4, 2008 4:01 PM, Tim Roberts [EMAIL

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

2008-02-04 Thread Tim Johnson
:* python-win32@python.org *Subject:* Re: [python-win32] Reading .py or .pyc from an excel sheet My machine doesn't seem to recognize Python.Interpreter. Is there some prerequisite that I could be missing? On Feb 4, 2008 1:21 AM, Tim Golden [EMAIL PROTECTED] wrote: Pallavi Apotikar wrote

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

2008-02-04 Thread Tim Johnson
*To:* Tim Golden *Cc:* python-win32@python.org *Subject:* Re: [python-win32] Reading .py or .pyc from an excel sheet My machine doesn't seem to recognize Python.Interpreter. Is there some prerequisite that I could be missing? On Feb 4, 2008 1:21 AM, Tim Golden [EMAIL PROTECTED] wrote

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

2008-02-04 Thread Mark Hammond
Of Tim Johnson Sent: Tuesday, 5 February 2008 11:23 AM To: Mark Hammond Cc: python-win32@python.org Subject: Re: [python-win32] Reading .py or .pyc from an excel sheet That was it. I'm using ActivePython 32-bit, but I just remembered that this is a 64-bit machine, so maybe that's why it wasn't set

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

2008-02-04 Thread Tim Johnson
*From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *Tim Johnson *Sent:* Tuesday, 5 February 2008 11:23 AM *To:* Mark Hammond *Cc:* python-win32@python.org *Subject:* Re: [python-win32] Reading .py or .pyc from an excel sheet That was it. I'm using ActivePython

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

2008-02-03 Thread Pallavi Apotikar
Larry Bates [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/02/2008 01:50 AM To python-win32@python.org cc Subject Re: [python-win32] Reading .py or .pyc from an excel sheet Pallavi Apotikar wrote: Actually, I have an excel sheet, where I am entering the data. I

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

2008-02-01 Thread Suraj Barkale
Hi, Pallavi Apotikar pallavi.apotikar at tcs.com writes: I know how to write the macro using VB, but I don't know how to do the same thing using python -- where is the option available etc. You can not run Python inside excel but you can use COM to get data from an excel sheet using same

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

2008-02-01 Thread Larry Bates
:31 PM To Pallavi Apotikar [EMAIL PROTECTED] cc python-win32@python.org Subject Re: [python-win32] Reading .py or .pyc from an excel sheet On Jan 31, 2008 11:43 AM, Pallavi Apotikar [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hello

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

2008-01-31 Thread Pallavi Apotikar
-win32@python.org Subject Re: [python-win32] Reading .py or .pyc from an excel sheet On Jan 31, 2008 11:43 AM, Pallavi Apotikar [EMAIL PROTECTED] wrote: Hello Sir/Madam, I would like to know, is it possible to read a python file from an excel sheet ? Thanks and Regards Pallavi Ajabrao

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

2008-01-31 Thread Graeme Glass
On Jan 31, 2008 12:36 PM, Pallavi Apotikar [EMAIL PROTECTED] wrote: Actually, I have an excel sheet, where I am entering the data. I am reading the entered data in python. excel takes data as a string. before passing it to python, i wanted to check whether the entered data(value) is a

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

2008-01-31 Thread Tony Cappellini
Why not just format the entire column as string data, before calling Python? That's just requires a few menu clicks, then pass that column to Python. Another option is to use a Python library called xlrd, which reads Excel (.XLS) files from Python. This way you can avoid using COM and the need to