PS More goodies: https://xlsxwriter.readthedocs.io/working_with_pandas.html https://openpyxl.readthedocs.io/en/stable/usage.html#using-formulae https://www.programcreek.com/python/example/19831/xlwt.Formula -- Dawid