Wassim67 opened a new issue, #7058: URL: https://github.com/apache/hop/issues/7058
## Summary Currently, the Microsoft Excel Input transform requires exact sheet names to be specified. This means users must know the exact name of each sheet they want to read, and must update the pipeline when sheet names change. ## Proposed Change Add a **Regex?** option (Yes/No) on each sheet entry in the Sheets tab. When set to **Yes**, the sheet name field is treated as a Java regular expression and matched against all available sheets in the workbook at runtime. All matching sheets are read sequentially using the same start row/column settings. ## Use Cases - Read all sheets matching a naming convention (e.g., `Data_.*` to read `Data_Jan`, `Data_Feb`, `Data_Mar`) - Dynamically adapt to files where sheet names follow a pattern but vary (e.g., monthly reports) - Avoid maintenance when new sheets are added to a recurring file ## Implementation - `ExcelInputMeta`: add `isRegex` boolean field on `EISheet` + `hasRegexSheets()` method - `ExcelInput`: resolve regex patterns per-workbook at open time via `resolveSheetNamesFromRegex()` - `ExcelInputDialog`: add **Regex?** Yes/No combo column in the Sheets tab - `messages_en_US.properties`: add `SHEET_IS_REGEX` injection key and `IsRegex.Column` UI label -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
