|
Solomon: I think "Val" will be a method on the Excel server. For example, if you have xl = win32com.client.Dispatch("Excel.Application") for your server, you would have say something like iValue = xl.Val(worksheet.Cells(row, col).Value) Again, I haven't used Excel this way, so I'm just going by standard object-oriented practice. You'll have to work out those details yourself. - 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: 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
