Adjust cell width in Excel

by

You could use set_column as follows:

worksheet1.set_column(1, 1, 25)

This is defined as follows:

set_column(first_col, last_col, width, cell_format, options)

You would need to determine a suitable width, perhaps based on the longest length of text in the whole column. Care though would be needed to base this on the font and size being used. Also consider if a proportional or fixed width font is used.

If you want to autofit all of the columns automatically regardless of the font and size, then you will need to use the win32com interface as follows:

import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(r'file.xlsx')
ws = wb.Worksheets("Sheet1")
ws.Columns.AutoFit()
wb.Save()
excel.Application.Quit()

This can easily be done after you closed the file using your current xlsxwriter code. Note, you might need to supply a full path to your file.

More Related Contents:

  1. append dataframe to excel with pandas
  2. pandas xlsxwriter, format table header – not sheet header
  3. How to write/update data into cells of existing XLSX workbook using xlsxwriter in python
  4. Merge rows based on value (pandas to excel – xlsxwriter)
  5. Write to StringIO object using Pandas Excelwriter?
  6. Putting many python pandas dataframes to one excel worksheet
  7. Appending Pandas DataFrame to existing Excel document
  8. XlsxWriter object save as http response to create download in Django
  9. Export a list of stock prices to excel
  10. Append existing excel sheet with new dataframe using python pandas
  11. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  12. How to call python script on excel vba?
  13. Driving Excel from Python in Windows
  14. check if a file is open in Python
  15. Import multiple excel files into python pandas and concatenate them into one dataframe
  16. How do I read a date in Excel format in Python?
  17. Pandas: Looking up the list of sheets in an excel file
  18. python xlrd unsupported format, or corrupt file.
  19. xlsxwriter: is there a way to open an existing worksheet in my workbook?
  20. How to copy worksheet from one workbook to another one using openpyxl?
  21. Convert date from excel in number format to date format python [duplicate]
  22. drop_duplicates not working in pandas?
  23. Calling python script from excel/vba
  24. How to read SharePoint Online (Office365) Excel files in Python with Work or School Account?
  25. Use Python to Inject Macros into Spreadsheets
  26. python-win32com excel com model started generating errors
  27. Get cell color from .xlsx
  28. Python Pandas – Read csv file containing multiple tables
  29. How to write to an existing excel file without breaking formulas with openpyxl?
  30. Automation Excel from Python

Leave a Comment