How harumiweb/xlflow works
xlflow is a CLI-first Excel VBA development harness: users move VBA and formula data between workbooks and source-controlled files, edit and validate that source, then test or run macros and inspect results. The CLI is the principal workflow entry point; a VS Code extension adds LSP and visual UserForm editing, while a Windows .NET bridge performs Excel automation. The README documents the capabilities and workflow; source-index references support selected internal links, but unsampled implementations and their detailed call paths are not inferred.
Main entry points: root.go Command orchestration · BridgeHost.cs Bridge host and protocol · client.ts VS Code extension · ExcelRunService.cs Macro execution
Components 24
CLI workflow
- xlflow CLI
cmd/xlflow/main.go - Command orchestration
internal/cli/root.go - Structured output
internal/output/output.go
VBA source and analysis
- VBA source files
- VBA import/export
internal/filepull/filepull.go - VBA formatting
internal/vbafmt/fmt.go - VBA linting
internal/lint/linter.go - Semantic analysis
internal/analyze/analyzer.go - UserForm generation
internal/vba/userforms/compiler/compiler.go
Workbook operations
- Formula snapshots
internal/formulas/extract.go - Workbook and source diff
internal/diff/diff.go - Excel workbook
Excel automation
- VBA testing
bridge/dotnet/src/Xlflow.ExcelBridge/Services/ExcelTestService.cs - Macro execution
bridge/dotnet/src/Xlflow.ExcelBridge/Services/ExcelRunService.cs - Bridge host and protocol
bridge/dotnet/src/Xlflow.ExcelBridge/BridgeHost.cs - Bridge request and response
bridge/dotnet/src/Xlflow.ExcelBridge/Contract/BridgeResponse.cs - Excel session management
bridge/dotnet/src/Xlflow.ExcelBridge/Services/ExcelSessionService.cs - Macro worker
bridge/dotnet/src/Xlflow.ExcelBridge/Workers/MacroRunWorker.cs
Editor integrations
- Language server
internal/lspserver/server.go - VS Code extension
editors/vscode/src/client.ts - Operations sidebar
editors/vscode/src/sidebar.ts - UserForm designer
editors/vscode/webview/userFormDesigner/App.tsx - Designer protocol
editors/vscode/src/userFormEditor/protocol.ts
Other components
- Developer or agent
Connections 31
- Developer or agent → xlflow CLI: invokes commands
README.md - xlflow CLI → Command orchestration: dispatches commands
cmd/xlflow/main.go - Command orchestration → VBA import/export: runs pull or push
internal/cli/root.go - VBA import/export → Excel workbook: imports and exports
README.md - VBA import/export → VBA source files: reads and writes
README.md - Developer or agent → VBA source files: edits source
README.md - Command orchestration → VBA formatting: runs formatting
README.md - Command orchestration → VBA linting: runs linting
README.md - Command orchestration → VBA testing: runs tests
README.md - Command orchestration → Macro execution: runs macros
README.md - Command orchestration → Formula snapshots: pulls formulas
README.md - Command orchestration → Workbook and source diff: compares workbooks
README.md - Command orchestration → UserForm generation: builds forms
README.md - Command orchestration → Structured output: formats output
internal/cli/root.go - Developer or agent → VS Code extension: uses extension
README.md - VS Code extension → Language server: starts language server
editors/vscode/src/client.ts - VS Code extension → Operations sidebar: provides operations UI
editors/vscode/src/client.ts - VS Code extension → UserForm designer: opens form designer
- UserForm designer → Designer protocol: uses protocol
editors/vscode/webview/userFormDesigner/App.tsx - Command orchestration → Semantic analysis: performs analysis
internal/cli/root.go - Command orchestration → Language server: provides LSP features
README.md - Command orchestration → Bridge host and protocol: uses Excel bridge
- Bridge host and protocol → Bridge request and response: exchanges messages
bridge/dotnet/src/Xlflow.ExcelBridge/BridgeHost.cs - Bridge host and protocol → Excel session management: dispatches session work
- Bridge host and protocol → Macro execution: dispatches macro work
- Macro execution → Macro worker: invokes worker
bridge/dotnet/src/Xlflow.ExcelBridge/Services/ExcelRunService.cs - VBA testing → Excel workbook: tests macros in
README.md - Macro execution → Excel workbook: runs macros in
README.md - Formula snapshots → Excel workbook: extracts formulas from
README.md - Workbook and source diff → Excel workbook: compares workbook data
README.md - VBA linting → Semantic analysis: uses semantic analysis
internal/lint/linter.go