I didn't love the idea of silencing all warnings in case something else comes up but you can supress a specific warning using :

warnings.filterwarnings("ignore", message="Workbook contains no default style", category=UserWarning)