OpenPyXL - Adjusting Column Width in Excel Workbooks with Python | Data Automation

This video reviews how to adjust the widths of a column in Excel using the Python library Openpyxl so you can read all of the content. Sorry about the different levels of audio - the microphone had some audio issues, which caused the volume to vary a bit depending on where I was in the video. I use Anaconda's Jupyter Lab interface.

😄 Please consider supporting this channel and making this content possible:

00:00 :: Intro and workbook review
01:09 :: importing load_workbook
01:40 :: Collecting longest string in column
02:08 :: Accessing width from column_dimensions
03:44 :: Looping through column cells
05:13 :: Reviewing worksheet & Overview

#PythonExcelTutorial #openpyxl #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #data #jupyterlab

[prashant]

Can we do auto width for all columns instead of manually setting for each column. I have like rows and iterating just to find out the max length is time consuming.

[bersi]

Great video. There is a bug though:
<-- This crash if you have an integer value. No len() for type int.