Solomon:
In what way did *int(worksheet.Cells(row, col).Value *not work? It seems
that it should have. (You should not do a "cast", you want a conversion). To
find out what's going on, try something like:
alpha = worksheet.Cells(row,col).Value
print 'Value was=', repr(alpha)
Perhaps there is some
Greg Antal wrote:
>
> 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
t;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 Visua
[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"
Greg offered that for use "... in a Vi
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.
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.
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
p
