[python-win32] getting integer value for worksheet.Cells(row, col).Value

[Solomon.Zewdie.Altek at zf.com]

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: python-win32-bounces+solomon.zewdie.altek=zf.com at python.org im Auftrag von Greg Antal
Gesendet: Mi 19.11.2008 17:15
An: python-win32 at 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

greg.antal at ata-e.com
858-480-2072  (Phone)
858-792-8932  (Fax)



Solomon.Zewdie.Altek at zf.com 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 at python.org
> http://mail.python.org/mailman/listinfo/python-win32
>  
_______________________________________________
python-win32 mailing list
python-win32 at python.org
http://mail.python.org/mailman/listinfo/python-win32