Python openpyxl Filter, Sort, Data Validation

In this python tutorial, we are going to go over how to use the openpyxl package to apply data validation to spreadsheets with LibreOffice Calc. We will also briefly go over some filter and sort examples.

For the examples of how to add a filter and sort condition - it is important to note that this will add the relevant instructions to the Excel file but it will not actually filter or sort the data.

openpyxl is a python library to read/write Excel files. openpyxl can help automate Excel with python (python excel tutorial with openpyxl). The worksheets can be opened with LibreOffice Calc, Numbers, or Google Sheets, etc., as well as with Excel.

This includes parts 10 and 11 of the openpyxl series. The topics covered in this series include:
00-openpyxl introduction
01-openpyxl append, access
02-openpyxl loading from file
03-openpyxl functions
04-openpyxl insert images
05-openpyxl insert, delete, move
06-openpyxl numpy, pandas
07-openpyxl charts
08-openpyxl styles
09-openpyxl conditional formatting
10-openpyxl filter and sort
11-openpyxl data validation

[RyanNoonan]

At the time of this tutorial, the filter and sort options are somewhat limited and may not provide all the functionality one might expect. Maybe options will be added in the future. See the openpyxl documentation for further details (i.e.-Filters and sorts can only be configured by openpyxl but will need to be applied in applications like Excel.).

This is the last tutorial in the openpyxl series. The next series we will start will be Plotly & Dash.

[cinzacaful]

Hey! I keep getting this Excel error after compiling the code for data validation. The excel will delete any data validation from the file. Is there a way to fix this?