xl-cli-tools

CLI tools for viewing and editing Excel files
Log | Files | Refs | README | LICENSE

xlfilter.tape (1254B)


      1 # VHS tape for recording xlfilter demo GIF.
      2 # Usage: vhs demo/xlfilter.tape
      3 #
      4 # Prerequisites:
      5 #   - xlfilter binary built and in PATH
      6 #   - Demo xlsx files created: cargo run --example create_demo
      7 
      8 Output demo/xlfilter.gif
      9 
     10 Set FontSize 14
     11 Set Width 1100
     12 Set Height 550
     13 Set Padding 15
     14 Set Theme "GruvboxDarkHard"
     15 
     16 Set TypingSpeed 80ms
     17 
     18 Set Shell "bash"
     19 
     20 Hide
     21     Type 'export PS1="> "'
     22     Enter
     23     Type "clear"
     24     Enter
     25 Show
     26 
     27 # --- 1. FILTER ROWS ---
     28 Type "xlfilter demo/sales.xlsx --where Region=East"
     29 Enter
     30 Sleep 3s
     31 
     32 # --- 2. NUMERIC COMPARISON ---
     33 Type "xlfilter demo/sales.xlsx --where 'Revenue>12000'"
     34 Enter
     35 Sleep 3s
     36 
     37 # --- 3. MULTIPLE FILTERS (AND) ---
     38 Type "xlfilter demo/sales.xlsx --where Region=East --where 'Revenue>10000'"
     39 Enter
     40 Sleep 3s
     41 
     42 # --- 4. SELECT COLUMNS + SORT ---
     43 Type "xlfilter demo/sales.xlsx --cols Region,Product,Revenue --sort Revenue:desc"
     44 Enter
     45 Sleep 3s
     46 
     47 # --- 5. LIMIT OUTPUT ---
     48 Type "xlfilter demo/sales.xlsx --sort Revenue:desc --limit 3 --cols Product,Revenue"
     49 Enter
     50 Sleep 2s
     51 
     52 # --- 6. CONTAINS FILTER ---
     53 Type "xlfilter demo/sales.xlsx --where 'Product~Widget A' --cols Date,Region,Revenue"
     54 Enter
     55 Sleep 3s
     56 
     57 # --- 7. CSV OUTPUT FOR PIPING ---
     58 Type "xlfilter demo/sales.xlsx --where Region=West --csv"
     59 Enter
     60 Sleep 3s