How ni9999/business_word_excel_automation works
GFG Wash Lab Report Automator is a browser-based suite for finding wash-report data, reviewing it, and downloading generated reports. Its main workflow searches by report number, presents detected entries for review and editing, then requests DOCX and PDF output; pasted Excel rows can also drive a wash-specific PDF workflow. Separate QC lookup and style-to-SharePoint tools are documented by the client screens and API calls. The excerpts do not show all server handlers or conversion internals, so those connections are limited to visible API calls and documented behavior.
Main entry points: MainApp.jsx Report workspace · App.jsx App router · server.js Folder link lookup · QcApp.jsx QC lookup screen
Components 17
Wash Reporting
- App router
client/src/App.jsx - Report workspace
client/src/MainApp.jsx - Report review
client/src/MainApp.jsx
Report Services
- Report search
server.js - Excel cache
server.js - Pasted-row parser
server.js - DOCX generation
server.js - PDF generation
server.js
Lookup Tools
- Folder link lookup
server.js - QC lookup screen
client/src/QcApp.jsx - QC info service
server.js - Style link screen
client/src/LinkApp.jsx
Wash PDF
- Wash PDF screen
client/src/WashApp.jsx - Wash PDF renderer
server.js - Image template
server.js
Other components
- Report user
- SharePoint
Connections 18
- Report user → App router: opens app
- App router → Report workspace: routes default
client/src/App.jsx - App router → QC lookup screen: routes /qc
client/src/App.jsx - App router → Style link screen: routes /link
client/src/App.jsx - App router → Wash PDF screen: routes /wash
client/src/App.jsx - Report workspace → Report search: requests search
client/src/MainApp.jsx - Report search → Excel cache: searches rows
server.js - Report workspace → Pasted-row parser: submits pasted rows
client/src/MainApp.jsx - Report workspace → Folder link lookup: requests folder link
client/src/MainApp.jsx - Report workspace → DOCX generation: requests DOCX
client/src/MainApp.jsx - Report workspace → PDF generation: requests PDF
client/src/MainApp.jsx - QC lookup screen → QC info service: requests file info
client/src/QcApp.jsx - QC lookup screen → Folder link lookup: opens returned link
client/src/QcApp.jsx - Style link screen → Folder link lookup: requests style link
client/src/LinkApp.jsx - Wash PDF screen → Pasted-row parser: parses pasted rows
client/src/WashApp.jsx - Wash PDF screen → Wash PDF renderer: requests wash PDF
client/src/WashApp.jsx - Wash PDF renderer → Image template: uses template
server.js - Folder link lookup → SharePoint: resolves folders