Long intro to my question...

While trying to automate my creation of an Excel spreadsheet to track student marks (don't like any of the mark tracking tools available to me) I created a Python program which would generate my entire mark book for the term. Because our marks for some assignments span up to four categories, some assignments have marks recorded in more than one column in my mark book.

The columns are organized by category: Knowledge, Thinking, Application, Communication. I have space for 15 assignments.

So if my first assignment is being marked on all four categories, it'd have an entry in columns B, Q, AF and AU (column A has the students' names). The next assignment would be columns in C, R, AG and AV, etc.

Seeing as Excel doesn't have a horizontal filter, I thought an alternative would be to set up 15 custom views for each page, if OpenPyxl can do that. Otherwise what I end up doing is just hiding the columns in between manually (or just scrolling through my spreadsheet to get to the column I want).

So... is there a way using OpenPyxl to create custom workbook views? I can't find a tutorial anywhere.

Thanks!