Automate Simple Excel Tasks with Python: From Password Protection to PDF creations

In this video I demonstrate how to AutoFit rows and Columns, Show and Hide Worksheets, Show and Hide Notes, Add and Remove Passwords, Protect Worksheets, Turn a WorkSheet into a PDF, all using Python.

00:00 | Intro
00:52 | AutoFit Rows/Cols
03:49 | Show Hidden Worksheets
05:56 | Hide Worksheet
06:40 | Hide Notes
10:30 | Show Notes
10:51 | Password Protect Workbook
12:54 | Remove Password Protection
14:38 | Protect WorkSheet
16:39 | Convert WorkSheet to PDF

Let me know in the comment section what else you would like to see automated.
Please subscribe to the channel ! @AIPSolutions