Member since
09-20-2024
1
Post
0
Kudos Received
0
Solutions
12-02-2024
06:20 AM
Hi everyone I try to split to records an Excel sheet, using ExcelReader. But get this error: SplitRecord[id=01921045-9bc9-1353-b2a2-96dfb4f1e8af] Failed to split FlowFile[filename=test.xlsx]: org.apache.nifi.processor.exception.ProcessException: IOException thrown from SplitRecord[id=01921045-9bc9-1353-b2a2-96dfb4f1e8af]: java.io.IOException: org.apache.nifi.serialization.MalformedRecordException: Read next Record from Excel XLSX failed on row 546 in sheet reportdata1 - Caused by: java.io.IOException: org.apache.nifi.serialization.MalformedRecordException: Read next Record from Excel XLSX failed on row 546 in sheet reportdata1 - Caused by: org.apache.nifi.serialization.MalformedRecordException: Read next Record from Excel XLSX failed on row 546 in sheet reportdata1 - Caused by: java.lang.NumberFormatException: For input string: "" Indeed, there are 545 filled lines on the sheet, but why ExcelReader doesn't stop, when find empty line?
... View more
Labels:
- Labels:
-
Apache NiFi