Getting formulae in R1C1 style?
I know that it is possible to get cell formulae in A1 style:
import openpyxl
wb = openpyxl.load_workbook("some_workbook.xlsx")
sheet = wb["some_sheet"]
print(sheet["J18"].value)
'=SUM(I18:I25)'
But is it possible by some means to get this in R1C1 style? i.e. some way of getting
'=SUM(RC[-1]:R[7]C[-1])'
instead?
I know I can parse the formulae using openpyxl.formula.Tokenizer
and then convert the references manually, but it would be nice if there were some builtin way of doing this that I have overlooked.