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
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.
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
[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
_
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
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