Sweet. Here’s my open issue with VisiData about this: https://github.com/saulpw/visidata/issues/1398
There’s a sample file at the end of that thread.
There’s a sample file at the end of that thread.
How much organizational (not technical, we'll get to that) control/authority/input/stakeholder role do you have on the source document templates?
Also, you might want to check out https://github.com/microsoft/advanced-formula-environment/
Yeah in the VisiData ticket I link to a post[1] with some code to handle hidden rows and columns in Pandas+openpyxl.
[1] https://towardsdatascience.com/how-to-load-excel-files-with-...