[python-win32] python-win32 Digest, Vol 58, Issue 53

[Mike Driscoll]

Hi,

Are you wanting to use Python in Excel instead of VBA? There's a thread
about just that sort of thing here:

http://www.velocityreviews.com/forums/t319222-re-python-in-excel.html

Otherwise you'll need to figure out how to use VBA to do some kind of
Python voodoo to check the data type. I suppose something that checks if
it is a long, pass that info along so Python doesn't think it's an int. In
fact, you'll probably have to pass some kind of flag or sentinel value
along to identify the data type for Python.

Maybe one of the gurus here will weigh in with more and better
information.

Mike

> Message: 4
> Date: Thu, 31 Jan 2008 16:06:08 +0530
> From: Pallavi Apotikar <pallavi.apotikar at tcs.com>
> Subject: Re: [python-win32] Reading .py or .pyc from an excel sheet
> To: "Graeme Glass" <graemeglass at gmail.com>
> Cc: python-win32 at python.org
> Message-ID:
> 	
> <OFFFD62BF6.41D497DA-ON652573E1.0039DDAF-652573E1.003A3DC7 at tcs.com>
> Content-Type: text/plain; charset="us-ascii"
> 
> 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 valid python data type. 
> 
> so instead of checking this in python script(/ say program), 
> I wanted to put macro in excel , so that all the values are 
> checked at a stretch (or say while entering - before passing 
> it to the python program.)
> 
> So is it possible ?
> 
> Pallavi Ajabrao Apotikar
> Tata Consultancy Services
> Mailto: pallavi.apotikar at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.   IT Services
>                         Business Solutions
>                         Outsourcing
> ____________________________________________
> 
>