${this.escapeXML(data.title)}

```typescript // ExcelReportGenerator.ts import { ReportGenerator } from './ReportGenerator'; import { ProcessedData } from './types'; export class ExcelReportGenerator extends ReportGenerator { protected getFormatName(): string { return 'Excel'; } protected formatHeader(data: ProcessedData): string { // Simplified Excel XML header let header = '\n'; header += '\n'; header += ` \n`; header += ` ${this.escapeXML(data.title)}\n`; header += ` ${data.generatedAt.toISOString()}\n`; header += ` \n`; header += ` \n`; header += ` \n`; // Title row header += ` \n`; header += ` ${this.escapeXML(data.title)}\n`; header += ` \n`; // Column headers header += ` \n`; for (const col of data.columns) { header += ` ${this.escapeXML(col)}\n`; } header += ` \n`; return header; } protected formatData(data: ProcessedData): string { let output = ''; for (const row of data.rows) { output += ` \n`; for (const cell of row) { const type = this.detectCellType(cell); output += ` ${this.escapeXML(cell)}\n`; } output += ` \n`; } return output; } protected formatFooter(data: ProcessedData): string { let footer = ''; // Summary row footer += ` \n`; footer += ` Total Revenue:\n`; footer += ` ${data.summary.total}\n`; footer += ` \n`; footer += ` \n`; footer += ` Average Delivery Time:\n`; footer += ` ${data.summary.average}\n`; footer += ` \n`; // Close tags footer += `

\n`; footer += ` \n`; footer += `\n`; return footer; } private detectCellType(value: string): string { // Detect if value is a number if (/^-?\d+(\.\d+)?$/.test(value.replace(/[$,]/g, ''))) { return 'Number'; } return 'String'; } private escapeXML(text: string): string { return text .replace(/&/g, '&') .replace(//g, '>') .replace(/"/g, '"') .replace(/'/g, '''); } } ``` **Features:** - Excel XML format - Type detection for cells - Proper XML escaping - Styled headers ---

Template Method Implementation in TypeScript

Template Method Implementation in TypeScript

Overview