Open calc and formating width with python

In python ,how can open or create (print) calc filles with custom column width?

The only way to print a data frame to calc is:

 writer = pd.ExcelWriter(b, engine='xlsxwriter')  
 pe_df.to_excel(writer, sheet_name='Sheet1')
 writer.save()

i want the excel files can set the columns width or auto-set width…
I use linux and have only libreoffice for calc files

please ask more specific