Forum Stats

  • 3,874,841 Users
  • 2,266,780 Discussions


Excel Upload in APEX 5.1

Denes Kubicek
Denes Kubicek Member Posts: 6,163 Bronze Crown
edited Jun 7, 2017 8:15AM in APEX Discussions

I just found out that the upload from excel (xls) to a collection doesn't work with 5.1 any more. We upgraded an existing 5.0 to 5.1 and this is now bugging us. The setting is normally done in the ords by adding the four lines to support uploading excel:

<entry key="apex.excel2collection">true</entry>

<entry key="apex.excel2collection.onecollection">true</entry>

<entry key="">EXCEL_COLLECTION</entry>

<entry key="apex.excel2collection.useSheetName">true</entry>

However in APEX 5.1 the simple page with a button to start the upload and the file browse item produces an error.

I tested this on multiple environments where there was an upgrade from 5.0 to 5.1 and it is the same thing.

Anyone with an idea ?


Denes Kubicek


Scott WesleyAnton Schefferuser509009Sven W.

Best Answer

  • Marc Sewtz-Oracle
    Marc Sewtz-Oracle Posts: 1,646 Employee
    edited Feb 28, 2017 1:37PM Answer ✓

    Hi Denes,

    The Excel to Collection functionality no longer works when using ORDS and APEX 5.1. In APEX 5.1 we've changed the page submission to use JSON, which does not work with the current Excel to Collection implementation in ORDS. Unfortunately we don't have an alternative or work around available at this time.





This discussion has been closed.