3 ms·

Sweet. Here’s my open issue with VisiData about this: https://github.com/saulpw/visidata/issues/1398 https://github.com/saulpw/visidata/issues/1398 There’s a s

• no_identd 4y ago
  Do you have a workaround workflow in the meantime? I could imagine a few non-Macro or Macro-light solutions to this. Use a pivot table for example, the results of which I believe get 'magiced' into their destination cells instead of getting hidden, I however don't recall whether they auto-inherit autofilters set on the source table and/or source cell range. 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/ https://github.com/microsoft/advanced-formula-environment/
  • kbd 4y ago
    > Do you have a workaround workflow in the meantime? 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-hidden-rows-and-columns-into-pandas-19d445fa5c47 https://towardsdatascience.com/how-to-load-excel-files-with-...