Set column width with pandas

So i’m using pandas with python trying to sort a dump from our system into separate files, this is working excellent.
But is there any way to format the column width in the output excel files so you dont have to manually adjust the column width when you open up the file?
Here is the code that generates the output.

split_values = df1["Vendor/supplying plant"].unique()
for vendor in split_values:
    df2 = df1[df1["Vendor/supplying plant"] == vendor]
    output_file_name = str(vendor) + ".xlsx"
    df2.to_excel(xlsxwriter, output_file_name, index=False)