How candyvelazco100/excel_sheetdawgextractor works
Project Type and Purpose
• This is an open-source Office Script written in TypeScript that runs inside Microsoft Excel 365.
• Purpose: Scan an Excel workbook for sheets with similar names, perform lookups on their cell data, and generate a consolidated results sheet.
File Structure Analysis
• Top level:
• SheetDawgExtractor.ts – the single Office Script containing all business logic.
• README.md – installation and usage instructions.
• LICENSE – MIT license text.
• No backend servers, no external dependencies or configuration files; all logic executes in the Excel/Office Scripts environment.
README Insights
• Deployment: copy the .ts file into the user’s Office Scripts folder, open via the Excel “Automate” ribbon.
• Customizable parameters: sheet name patterns, cell references, output sheet name.
• Scalability note: depends on Excel’s compute power; no external services.
Components
a. Main Components
1. User (initiates script via Excel UI)
2. Excel 365 Application (host)
3. Office Scripts Runtime (JavaScript engine inside Excel)
4. SheetDawgExtractor.ts (TypeScript code compiled to Office Script)
5. Input Worksheets (many sheets matching naming pattern)
6. Output Worksheet (newly created “Results” sheet)
b. Relationships and Interactions
• User → Excel UI: clicks “Run Script”
• Excel UI → Office Scripts Runtime: loads the script
• Runtime → Workbook Object Model:
• Enumerates sheets
• Reads cell ranges from matching sheets
• Performs in-memory lookups/transformations
• Creates/appends data to the output sheet
• Workbook → Excel UI: updates the visible worksheets
c. Architectural Patterns and Principles
• Single-page procedural script pattern: all logic in one module
• Asynchronous API calls (Office Scripts API) for I/O operations
• Separation of concerns: detection of sheet names, data lookup, and result writing are distinct code segments (functions)
d. Key Technologies and Libraries
• TypeScript → compiled to JavaScript for Office Scripts
• Office Scripts API (Excel Script namespace)
• Excel workbook as data store (no external database)