[NIFI-13304] Add SplitExcel Processor

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0, 2.0.0-M4
• Assignee: Daniel Stieglitz
• Reporter: Philipp Korniets
• Created: 28/May/24 15:00
• Updated: 28/Jun/24 19:32
• Resolved: 25/Jun/24 13:06

Description

Currently ConvertExcelToCSV processor, if processing excel with multiple required sheets in it, produces flowfile per sheet.

New ExcelReader produces one flowfile with all data in it

 

There should be a way to configure output to be sheet-per-flowfile

 

 

Issue Links

• is related to: NIFI-12510 Excel Record Reader | Extend Functionality
• relates to: NIFI-13466 SplitExcel causes file to yield since it does not catch a java.lang.IllegalStateException
• relates to: NIFI-12491 ExcelReader - new Schema Access strategy: Use String Fields From Header
• relates to: NIFI-13442 Remove nifi-poi-utils module from nifi-poi-bundle
• relates to: NIFI-13456 Clean up unused code in TestSplitExcel
• relates to: NIFI-13467 Clarify what the total.rows attribute in SplitExcel Represent
• links to: GitHub PR 8981
• links to: GitHub PR 9011