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 <[EMAIL PROTECTED]> > Subject: Re: [python-win32] Reading .py or .pyc from an excel sheet > To: "Graeme Glass" <[EMAIL PROTECTED]> > Cc: python-win32@python.org > Message-ID: > > <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > Website: http://www.tcs.com > ____________________________________________ > Experience certainty. IT Services > Business Solutions > Outsourcing > ____________________________________________ > > _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
