xlset.tape (1538B)
1 # VHS tape for recording xlset demo GIF. 2 # Usage: vhs demo/xlset.tape 3 # 4 # Prerequisites: 5 # - xlcat and xlset binaries built and in PATH 6 # - Demo xlsx files created: cargo run --example create_demo 7 8 Output demo/xlset.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 "cp demo/sales.xlsx /tmp/demo_edit.xlsx" 24 Enter 25 Type "clear" 26 Enter 27 Show 28 29 # ─── 1. VIEW BEFORE EDITING ─── 30 Type "xlcat /tmp/demo_edit.xlsx --head 3" 31 Enter 32 Sleep 2s 33 34 # ─── 2. SET A SINGLE CELL ─── 35 Type "xlset /tmp/demo_edit.xlsx B2=South" 36 Enter 37 Sleep 2s 38 39 # ─── 3. SET MULTIPLE CELLS ─── 40 Type "xlset /tmp/demo_edit.xlsx D2=99999 E2=500" 41 Enter 42 Sleep 2s 43 44 # ─── 4. VERIFY CHANGES ─── 45 Type "xlcat /tmp/demo_edit.xlsx --head 3" 46 Enter 47 Sleep 3s 48 49 # ─── 5. TYPE TAG: PRESERVE LEADING ZERO ─── 50 Type "xlset /tmp/demo_edit.xlsx C2:str=07401" 51 Enter 52 Sleep 2s 53 54 Type "xlcat /tmp/demo_edit.xlsx --head 2" 55 Enter 56 Sleep 2s 57 58 # ─── 6. BULK UPDATE FROM CSV ─── 59 Hide 60 Type "printf 'cell,value\nA5,2024-06-15\nB5,HQ\nD5,50000\n' > /tmp/updates.csv" 61 Enter 62 Sleep 300ms 63 Show 64 65 Type "cat /tmp/updates.csv" 66 Enter 67 Sleep 2s 68 69 Type "xlset /tmp/demo_edit.xlsx --from /tmp/updates.csv" 70 Enter 71 Sleep 2s 72 73 # ─── 7. WRITE TO NEW FILE ─── 74 Type "xlset /tmp/demo_edit.xlsx --output /tmp/final.xlsx A1=ID" 75 Enter 76 Sleep 2s 77 78 Type "xlcat /tmp/final.xlsx --head 3" 79 Enter 80 Sleep 3s