Skip to content

v1.21.0 - Excel Tools Module

Choose a tag to compare

@Gronsten Gronsten released this 25 Feb 01:57
· 6 commits to main since this release
c2d85c4

New Features

  • Excel Tools module — New Python-based Excel workbook utility suite (modules/excel-tools/)
    • Full arrow-key navigation menu with ANSI color output, matching the PowerShell console visual style
    • Configuration via modules/excel-tools/excel-tools.json (Lumen invoice paths and template filenames)
    • Operations available:
      1. Unprotect & Unhide — removes sheet protection and unhides all sheets
      2. Re-protect & Re-hide — per-sheet protection settings via interactive checkbox UI; restores hidden sheets
      3. Strip external links — removes [Book.xlsx] references from formulas
      4. Find & Replace in formulas — text replacement across all formula cells
      5. Dump all formulas — debug export of every formula cell to console
      6. Compare workbooks — structural and formula diff between two workbooks
      7. Generate Lumen invoices — auto-fills monthly billing templates from a PO reference file
      8. Clear all tab colors — removes custom tab colors from all sheets
    • Launched via Start-ExcelTools in console.ps1; runs from its module directory so excel-tools.json is found automatically
    • Dependencies: openpyxl (pip), tkinter (Python stdlib, for file picker)

Menu Changes

  • Added "Excel Tools" to main menu (above "Code Count") — calls Start-ExcelTools
  • Removed "Meraki Backup" from main menu — function and scripts remain; menu option retired as no longer a routine workflow