import xlwings as xw
xw.Book() print(xw.Range('c3').offset(0,0).address) # $C$3 print(xw.Range('C3').api.offset(0,0).address) # $B$2