Python With Xlsxwriter To Save Or Assign Formula Result As A Value For Use Later On

I'll be honest and say that I asked a similar question the other day, but I think I over complicated the question and so it wasn't particularly clear on what I a looking for. To su

Solution 1:

The update is a little bit clearer but the question is still missing the part that would help someone answer this: a small working example.

One thing to note is that XlsxWriter doesn't calculated the result of a formula. The result variable in the code above is just a reference to formula variable which is a string like '=AVERAGE(DATA!A1:D4)'.

If you are using that formula in a worksheet that doesn't have a worksheet named DATA then you will probably get the #REf error that you were referring to.