/** * F5 CLI - Excel Analyzer * Auto-detects Excel structure and suggests column mappings * * @module @f5/cli/commands/import/excel-analyzer * @version 1.0.0 */ import XLSX from 'xlsx'; import type { AnalysisResult } from '../../types/excel-schema.js'; export declare class ExcelAnalyzer { private workbook; private filePath; private fileName; constructor(filePath: string); /** * Perform full analysis of the Excel file */ analyze(): AnalysisResult; /** * Analyze all sheets in the workbook */ private analyzeSheets; /** * Find the main data sheet */ private findMainSheet; /** * Detect header row in sheet */ private detectHeaderRow; /** * Detect column mappings from headers */ private detectColumnMappings; /** * Match header to Jira field */ private matchJiraField; /** * Calculate match confidence */ private calculateMatchConfidence; /** * Detect data type from sample values */ private detectDataType; /** * Calculate overall confidence score */ private calculateConfidence; /** * Generate warnings based on analysis */ private generateWarnings; /** * Determine complexity level */ private determineComplexity; /** * Check for special content (images, formulas, merged cells) */ private checkSpecialContent; /** * Get workbook for external use */ getWorkbook(): XLSX.WorkBook; } export default ExcelAnalyzer;