Forum Stats

  • 3,875,193 Users
  • 2,266,849 Discussions
  • 7,912,104 Comments

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="apex.excel2collection.name">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 ?

Thanks,

Denes Kubicek

pastedImage_0.png

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.

    Regards,

    Marc

«1

Answers

This discussion has been closed.