Skip to Main Content

APEX

Excel Upload in APEX 5.1

Denes KubicekFeb 28 2017 — edited Jun 7 2017

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

This post has been answered by Marc Sewtz-Oracle on Feb 28 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2017
Added on Feb 28 2017
11 comments
13,267 views