SplitExcel 2.0.0

Bundle
org.apache.nifi | nifi-poi-nar
Description
Splits a multi sheet Microsoft Excel spreadsheet into multiple Microsoft Excel spreadsheets where each sheet from the original file is converted to an individual spreadsheet in its own flow file. This processor is currently only capable of processing .xlsx (XSSF 2007 OOXML file format) Excel documents and not older .xls (HSSF '97(-2007) file format) documents. NOTE: All original cell styles are dropped when splitting into multiple Microsoft Excel spreadsheets.
Tags
split, text
Input Requirement
REQUIRED
Supports Sensitive Dynamic Properties
false
Properties
Relationships
Name Description
split The individual Excel 'segments' of the original Excel FlowFile will be routed to this relationship.
original The original FlowFile that was split into segments. If the FlowFile fails processing, nothing will be sent to this relationship
failure If a FlowFile cannot be transformed from the configured input format to the configured output format, the unchanged FlowFile will be routed to this relationship.
Writes Attributes
Name Description
fragment.identifier All split Excel FlowFiles produced from the same parent Excel FlowFile will have the same randomly generated UUID added for this attribute
fragment.index A one-up number that indicates the ordering of the split Excel FlowFiles that were created from a single parent Excel FlowFile
fragment.count The number of split Excel FlowFiles generated from the parent Excel FlowFile
segment.original.filename The filename of the parent Excel FlowFile
sheetname The name of the Excel sheet from the original spreadsheet.
total.rows The number of rows in the Excel sheet from the original spreadsheet.