paper-xlsxAPI referenceformula.translate
openpyxl.formula.translate
paper-xlsx 0.2.1 API reference
This module contains code to translate formulae across cells in a worksheet.
The idea is that if A1 has formula "=B1+C1", then translating it to cell A2 results in formula "=B2+C2". The algorithm relies on the formula tokenizer to identify the parts of the formula that need to change.