OpenPyXL - Hiding/Unhiding Rows in Excel Workbooks with Python | Data Automation

preview_player
Показать описание
This video demonstrates how to hide and unhide multiple rows in excel with the Python library Openpyxl. I use Anaconda's Jupyter Lab interface.

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

00:00 :: Intro and Workbook Review
00:40 :: Accessing/Changing the "hidden" attribute
01:50 :: Hiding multiple rows
02:30 :: Unhiding a row
03:00 :: Overview

#PythonExcelTutorial #openpyxl #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #data #jupyterlab
Рекомендации по теме
Комментарии
Автор

thanks for the video, very clear and easy to follow
I see you posted a number of them on sheet style and format, do you plan to make some on functions? like how to use Openpyxl instead of VBA or cell functions, cheers

StefanoVerugi