Monday, 22 October 2018

Finding Range of active/selected cell in Excel using Python and xlwings - continued

I'm coming from this topic

This isn't working for me. I'm using xlwings in Jupyter Lab.

import xlwings as xw
app = xw.App
r = app.selection
print r

works just fine it returns: property at 0x8919598>

but trying to access any property of the range fails. r.row returns: 'property' object has no attribute 'row' same for "address", "column", "value"

I tried combinations of parenthesis and api: r.api.row, r.api.row(), r.row() ... no success.

I looked at available commands by pressing tab shift and got (.deleter, .fedel, .fget. .fset, .getter, .setter). So I tried to extract the desired property r.fget("address") --> no success.

xlwings's version is 0.11.7 excel's version is 13 windows 7

Could anyone give some hint where to look next? Thanks in advance.



from Finding Range of active/selected cell in Excel using Python and xlwings - continued

No comments:

Post a Comment