[
https://issues.apache.org/jira/browse/NIFI-4465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16198261#comment-16198261
]
ASF GitHub Bot commented on NIFI-4465:
--------------------------------------
Github user patricker commented on the issue:
https://github.com/apache/nifi/pull/2194
@ijokarumawak I made several changes, though not really what you asked
for... I replied separately on data formatting. As for EL, see my comments
below.
I wanted to move towards generating CSV files that can be easily parsed by
using the CSV Record Reader. So I exposed the CSVUtils Properties and put them
on to this processor. I was having problems with comma's in my input file
before, but after these changes that isn't an issue anymore. I also wanted the
code to be easier to maintain, so I tried to move as much of the CSV code to
the existing code in the record serializers module. That code,
`CSVUtils.createCSVFormat`, does not use EL, which makes sense since it's all
being defined on a Controller Service.
I tried making an Excel Spreadsheet Record Reader, and I did make one, but
it did not use streaming. It loaded the whole spreadsheet into memory. I
couldn't find a way using the Apache POI project to do stream reading one row
at a time (instead of all rows at once).
> ConvertExcelToCSV Data Formatting and Delimiters
> ------------------------------------------------
>
> Key: NIFI-4465
> URL: https://issues.apache.org/jira/browse/NIFI-4465
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Core Framework
> Reporter: Peter Wicks
> Assignee: Peter Wicks
> Priority: Minor
> Fix For: 1.5.0
>
>
> The ConvertExcelToCSV Processor does not output cell values using the
> formatting set in Excel.
> There are also no delimiter options available for column/record delimiting.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
