[
https://issues.apache.org/jira/browse/NIFI-11167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17790712#comment-17790712
]
Philipp Korniets edited comment on NIFI-11167 at 11/28/23 6:23 PM:
-------------------------------------------------------------------
file attached [^Test ExcelReader.xlsx]
QueryRecord !image-2023-11-28-18-22-07-446.png!
CSV data from Excel (via ConvertExcelToCSV)
{code:java}
Description,,Events,Cost per Event,Amount
Securities Settlements:,,,,
With ML,,,,
test1,,0,Waived,123
tets34,,1301,Waived,45
tets dfd,,0,Waived,43
tetst bbb,,318,Waived,234
My test,,10,Waived,1009
Physical (US),,0,Waived,33
Total With ML Waived,,1629,,1487
Away From ML,,,,
test1,,0,25,0
tets34,,1000,20,20000
tets dfd,,0,20,0
tetst bbb,,1500,30,45000
My test,,33,30,990
Physical (US),,0,300,0
Total Away from ML,,2533,,65990
Total Securities Settlements Fees,,,,67477
Payment Fees:,,,,
Test 99,,5,15,75
test 90,,0,50,0
Total Payment Fees,,,,75
Balanced File Delivery Fee,,0,,0
{code}
was (Author: iiojj2):
file attached [^Test ExcelReader.xlsx]
QueryRecord !image-2023-11-28-18-22-07-446.png!
> Add Excel Record Reader
> -----------------------
>
> Key: NIFI-11167
> URL: https://issues.apache.org/jira/browse/NIFI-11167
> Project: Apache NiFi
> Issue Type: New Feature
> Components: Extensions
> Reporter: David Handermann
> Assignee: Daniel Stieglitz
> Priority: Minor
> Fix For: 2.0.0-M1, 1.23.0
>
> Attachments: Test ExcelReader.xlsx,
> image-2023-11-28-18-22-07-446.png, screenshot-1.png
>
> Time Spent: 10h 10m
> Remaining Estimate: 0h
>
> A new Excel Record Reader should be implemented to support reading XSLX
> spreadsheet rows as NiFi Records. This Reader will enable integration with
> various record-oriented components, obviating the need for the narrowly
> focused ConvertExcelToCSVProcessor. The initial version of the Excel Reader
> should not support the legacy binary XLS format.
> The ExcelReader should use a library that supports reading from a stream of
> rows to avoid consuming large amounts of heap memory during processing.
> The ExcelReader should support configurable properties to read selected
> sheets. With Excel supporting typed field values, some amount of field type
> mapping will be required. Additional input filtering properties should not be
> implemented as existing Processors like QueryRecord support a wide variety of
> filtering and projection use cases.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
