Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX Cloud 20.1 - How to create application to allow users to upload Excel file xslx to a table

Joe1Sep 3 2020 — edited Sep 17 2020

I've read in Cloud 20.1 documentation how to upload xlsx file into table by going to Workspace homepage, SQL workshop, Utilities,Data Workshop, Load Data.  That works fine, but I think this method is for developers or admins only.  I need to create an application that will let a user, not a developer, load their spreadsheet into an existing table, replacing the previous uploaded data.  In order to maintain data integrity, having the user save as csv and then upload csv is not an option; it must be the native spreadsheet.  When I tried creating a Data Loading page within an application, the wizard only shows support for csv or delimited files, not xlsx.

I was hoping Cloud 20.1 would allow direct xlsx upload by a user, but I cannot find that option.  Can anyone give me the options for doing this within 20.1.
This post has been answered by jariola on Sep 12 2020
Jump to Answer

Comments

807569
The file is just a Java properties file, which you can load and save using the java.util.Properties class.

If you want to change the logging level on the fly (while the program is running), you can do that too with Log4J - look at the API documentation of Log4J, I'm sure it's described in there.
807569
I know it is a Java properties file but I have to change the value at more than one places simultaneously and there are two values seperated by a comma(,), out of which only one I need to change. I would like to know that what is most efficient way of changing it.

The other thing is I know that we can change the log level using log4j on the fly, but that we have to do it programatically not manually based on the input seletedt by the user.
1 - 2

Post Details

Added on Sep 3 2020
#apex-discussions, #excel
4 comments
2,956 views