Coding Coconuts 2 - OpenPyXL, Excel Tables and Removing AutoFilter
I answer YOUR Python coding questions.
Today's question comes from Hibbert. https://stackoverflow.com/questions/7...
Hibbert wanted to know how to turn off AutoFilter in an Excel Sheet after creating a table with OpenPyXL.
We will use Python and OpenPyXL to create an Excel spreadsheet, fill it with data, and create a table. Then I will show you how to turn off the tables AutoFilter with OpenPyXL.
Source code: https://github.com/consod/articles/tr...
Do YOU want to have YOUR questions answered next? Comment below or email [email protected]
Timestamps
0:00 Intro & Problem description
01:12 Creating a Workbook
01:48 Adding data to our Worksheet
03:27 Saving our Workbook
04:19 Adding a Table
06:39 Removing the AutoFilter with OpenPyXL
08:04 Outro
LinkedIn: / connysoderholm
GitHub: https://github.com/consod
Medium: / soderholm.conny