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 ?
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
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
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
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
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
:* 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
*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
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
*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
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
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
: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
-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
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
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
16 matches
Mail list logo