How to write footers that say Page x of n for multiple worksheets in Python XlsxWriter

I have a python program that loops through a dataframe that contains multiple cases in it.