/** * F5 CLI - Excel to Jira CSV Converter * Converts Japanese issue tracking Excel files to Jira-compatible CSV * * @module @f5/cli/core/excel-to-jira-converter * @version 1.0.0 */ export interface IssueRecord { no: number | string; date: string; reporter: string; type: string; category: string; screen: string; operation: string; issue: string; fix: string; severity: string; priority: string; comments: string[]; rawRow: number; } export interface JiraIssue { summary: string; issueType: string; priority: string; description: string; labels: string[]; component: string; assignee: string; dueDate: string; externalId: string; status: string; } export interface ConversionResult { issues: JiraIssue[]; csv: string; stats: { totalRows: number; convertedRows: number; skippedRows: number; bugs: number; improvements: number; tasks: number; }; warnings: string[]; } export interface ConversionOptions { sheetName?: string; headerRow?: number; projectKey?: string; includeNormal?: boolean; externalIdPrefix?: string; } export declare class ExcelToJiraConverter { private options; private warnings; constructor(options?: ConversionOptions); /** * Convert Excel file to Jira CSV */ convert(filePath: string): Promise; /** * Build column index map from headers */ private buildColumnMap; /** * Parse a single row into IssueRecord */ private parseRow; /** * Convert IssueRecord to JiraIssue */ private convertToJiraIssue; /** * Generate CSV from issues */ private generateCsv; /** * Escape CSV field */ private escapeCsvField; /** * Save CSV to file */ saveCsv(result: ConversionResult, outputPath: string): Promise; } export declare function convertExcelToJiraCsv(inputPath: string, outputPath: string, options?: ConversionOptions): Promise; export default ExcelToJiraConverter;