Openpyxl - Merging and Unmerging Cells in Excel with Python | Data Automation
This video reviews how to merge and unmerge cells in a worksheet using the Python library Openpyxl. It also reviews how to align the content of a cell horizontally and vertically. I use Anaconda's Jupyter Lab interface.
Please consider supporting this channel and making this content possible:
🅿
00:00 :: Intro & Workbook review
00:40 :: Importing load_workbook and grabbing sheet
01:24 :: Printing out cell values
01:45 :: merge_cells function
02:55 :: Checking the merge
03:30 :: Importing Alignment
03:44 :: Applying styling to center the text
04:45 :: Checking alignment of text
05:00 :: unmerge_cells function
05:30 :: Checking the unmerge
Watch video Openpyxl - Merging and Unmerging Cells in Excel with Python | Data Automation online without registration, duration 06 minute 09 second in high hd quality. This video was added by user Data Automation 14 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3 thousand once and liked it 30 people.