I just tried it ( I did: IntValue = Val(self.worksheet.Cells(row, col).Value)) Though It seems that the COM server doesn't know Val()... or am i doin something wrong?? I got the error: "NameError: global name 'Val' is not defined"
________________________________ Von: [EMAIL PROTECTED] im Auftrag von Greg Antal Gesendet: Mi 19.11.2008 17:15 An: python-win32@python.org Betreff: Re: [python-win32] getting integer value for worksheet.Cells(row, col).Value Solomon: To do this in a Visual Basic module within Excel, you would use intValue = Val(worksheet.Cells(row, col).Value) I haven't tried to use Excel as a COM server, but I think if you can use the "Val()" function, you'll get the data you want instead of a string. - Greg Antal Gregory W. Antal Senior Technical Advisor ATA Engineering, Inc. 11995 El Camino Real, Suite 200 San Diego, CA 92130 www.ata-e.com [EMAIL PROTECTED] 858-480-2072 (Phone) 858-792-8932 (Fax) [EMAIL PROTECTED] wrote: > Hi, > the statement: worksheet.Cells(row, col).Value returns a Value of type of > Strings, > Can anyone tell me how I can get an Integer value? > Casting (int(worksheet.Cells(row, col).Value ) didn't work. > > Many Tnx! > > solomon > _______________________________________________ > python-win32 mailing list > python-win32@python.org > http://mail.python.org/mailman/listinfo/python-win32 > _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32 _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
