Helper functions for use with pandas and xlsxwriter.
PythonMIT
Xlsx filetype utility functions
autofit_columns: Autofit all columns from dataframe written to xlsxfile with xlsxwriter
defautofit_columns(dataframe, worksheet, padding=1.1, index=True):
""" :param dataframe: Base dataframe written to xlsx workbook :param worksheet: Sheet in xlsx workbook to be formatted :param padding: Optional, padding amount :param index: Optional, Index true/false in dataframe. Defaults true, use false for non-indexed dataframe outputs. :return: formatted worksheet """