Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4883

Teiid Excel Translator should filter blank cells from header row

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Minor
    • 9.3
    • None
    • Misc. Connectors
    • None

    Description

      The teiid translator for excel will throw a duplicate column name exception when using a spreadsheet that has 2 or more columns where the header row doesn't specify a header name. In the attached spreadsheet it's difficult to see that rows E-H should be deleted from the dataset.

      The proposed enhancement is to allow the translator for excel to exclude any trailing columns where there is no column name defined.

      I took a shot at making this enhancement and created a PR at https://github.com/teiid/teiid/pull/951

      If this PR is not going to be accepted, can the methods in the ExcelMetadataProcessor me changed from private to protected so that the processor can be extended easily?

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            dvilaverde_jira David Vilaverde (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: