Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-13726

Excel specifications and limits are not respected while splitting

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.0.0-M4, 2.0.0
    • 1.28.0, 2.0.0
    • None
    • None

    Description

      As NIFI-13466 demonstrated the splitting doesn't work with bigger excel files. This is most likely caused by the currently used CELL_COPY_POLICY.

      https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

      A workaround could be to allow the possibility to get something other than excel out from the splitter but I believe as per NIFI-13304 comments that this is not possible

      Attachments

        Issue Links

          Testing discovered

          Improvement - An improvement or enhancement to an existing feature or task. NIFI-13819 Provide row number and sheet name if ExcelReader throws exception when it fails to convert a value

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Web Link GitHub Pull Request #9326

          Activity

            People

              dstiegli1 Daniel Stieglitz
              tuomas_kiviaho Tuomas Kiviaho
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m