- Unprotected
- Password Protected
Sensitive Property: true
This Property is only considered if the [Protection Type] Property has a value of "Password Protected".
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.
split, text
In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values.
| Display Name | API Name | Default Value | Allowable Values | Description |
|---|---|---|---|---|
| Protection Type | Protection Type | Unprotected |
| Specifies whether an Excel spreadsheet is protected by a password or not. |
| Password | Password | The password for a password protected Excel spreadsheet Sensitive Property: true This Property is only considered if the [Protection Type] Property has a value of "Password Protected". |
| Name | Description |
|---|---|
| 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. |
| original | The original FlowFile that was split into segments. If the FlowFile fails processing, nothing will be sent to this relationship |
| split | The individual Excel 'segments' of the original Excel FlowFile will be routed to this relationship. |
| 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. |