I am writing out multiple dataframes to a excel workbook. I want to change the default font to “century Gothic” and size to 9 and color to blue (font color 2659D9) for all the sheets.
I also want the numbers column to have an accounting format and the date columns to have yyyy-mm-dd format. I tried the code below, but it is not working.

I am pivoting a dataframe and then filtering it. And then I need to write it to excel. But when I write it out,