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