Here's an example from the XSLX Writer documentation:
worksheet.write_formula('A1', '=10*B1 + C1')
Looks simple enough. But what if I want to apply this formula for 'A1:A30'? Also, what if in cell A3, the formula should dynamically update to:
'=10*B3 + C3'
?
I've been unable to do this from looking at the docs. I see a promising option for write_array_formula, but I don't want an array formula.
I've come up with a solution involving looping through each row and column, but I'm hoping there's a simpler one.