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

[Greg Antal]

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
>