[
https://issues.apache.org/jira/browse/NIFI-14538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17950991#comment-17950991
]
Daniel Stieglitz commented on NIFI-14538:
-----------------------------------------
[~exceptionfactory] Once one the JXLS page you must
# follow the following link on that page [Project Summary Page for
jxls|https://sourceforge.net/projects/jxls]
# Click the File tab
# Click the jxls link
# Click the File tab
# Click 1.0.6 link
# Click
[jxls-1.0.6.zip|https://sourceforge.net/projects/jxls/files/jxls/1.0.6/jxls-1.0.6.zip/download]
to download the source
# Unzip the download
# The Util class mentioned in the Stackoverflow post can be found in folder
jxls-1.0.6/src/jxls-core/src/main/java/net/sf/jxls/util
I just noticed though that Util class code there is different than the one
mentioned in the Stackoverflow code as it does not use HSSF elements explicitly
rather its using the generic Sheet interface. This makes me believe this code
could be suitable for both HSSF and XSSF, although for XSSF we do not need it
as Apache POI already has a copyRow feature for XSSF which we have already
taken advantage of in the SplitExcel processor. I assume the Stackoverflow must
have been referring to an older version of the software. I have not looked at
the older versions.
I do know of a user on my end who has requested this hence this ticket.
> Add support for HSSF format in the SplitExcel processor
> -------------------------------------------------------
>
> Key: NIFI-14538
> URL: https://issues.apache.org/jira/browse/NIFI-14538
> Project: Apache NiFi
> Issue Type: Improvement
> Reporter: Daniel Stieglitz
> Assignee: Daniel Stieglitz
> Priority: Major
>
> With changes made in NIFI-14426 to add support for HSSF format in the
> ExcelReader controller service, similar changes should be made in the
> SplitExcel processor to allow for the SplitExcel processor and ExcelReader
> controller service to be used together for both Excel file types HSSF and
> XSSF (e.g. an instance of SplitExcel processor which sends flow files to for
> a ConvertRecord processor configured with an ExcelReader). It would be
> worthwhile to only start work on this ticket after NIFI-14426 is completed
> to leverage common code needed by both the ExcelReader and SplitExcel.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
