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

2008-02-04 Thread Tim Johnson
ister > > the object (which inturn might not work if you installed Python without > > admin privs or selected "just for me") > > > > > > > > Mark > > > > > > > > *From:* [EMAIL PROTECTED] [mailto: > > [EMAIL PROTECTED] *

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

2008-02-04 Thread Tim Johnson
dmin privs or selected "just for me") > > > > Mark > > > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Tim Johnson > *Sent:* Tuesday, 5 February 2008 10:23 AM > *To:* Tim Golden > *Cc:* python-win32@python.org > > > *Subject:

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

2008-02-04 Thread Mark Hammond
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 32-bit, but I just remembered that this is a 64-bit machine, so maybe that'

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

2008-02-04 Thread Tim Johnson
f Of *Tim Johnson > *Sent:* Tuesday, 5 February 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

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

2008-02-04 Thread Mark Hammond
5 February 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 &l

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

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 PROTECTED

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 s

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 t

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/dat

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

2008-02-03 Thread Pallavi Apotikar
Outsourcing 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 ha

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

2008-02-01 Thread Larry Bates
ng > > > > *"Graeme Glass" <[EMAIL PROTECTED]>* > > 01/31/2008 03:31 PM > > > To > "Pallavi Apotikar" <[EMAIL PROTECTED]> > cc > python-win32@python.org > Subject &

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

2008-02-01 Thread Suraj Barkale
Hi, Pallavi Apotikar 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 API as VBA. I h

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

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

2008-01-31 Thread Pallavi Apotikar
potikar" <[EMAIL PROTECTED]> cc python-win32@python.org Subject Re: [python-win32] Reading .py or .pyc from an excel sheet 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 en

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(valu

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

2008-01-31 Thread Pallavi Apotikar
ot; <[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]> wrote: Hello Sir/Madam, I would like to know, is it possible to read a python file from an excel

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

2008-01-31 Thread Graeme Glass
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 Apotikar > I don't fully understand what you are asking, But... If you wh