Blogging about Oracle Application Express (APEX) and related stuff
I did update old "Paste Excel Data" sample application for APEX 4.1.1.
There is now new features to order rows in collection
Also you can change column headings.
You have IR column headings like &P1_HEAD_1.
You need change headings according item names you are using
Example use APEX_COLLECTION that have 50 column limitation.
You can create your own table with e.g. 100 columns and insert data there, instead of collection.
In blog post there is link to download sample application. I did mean that sample use APEX_COLLECTION.
You can download sample app and install it with supporting objects. Supporting objects creates database package where is all logic save data to APEX_COLLECTION.
First you need create own table where is more columns. Then modify package procedure to store data to your new table.
I hope this helps.
I have a value with multiple lines on the same cell, when I submit the value it was taking as a multiple row rather than a single row. Could you please me to overcome this issue.
I know solution have this issue. I have no need paste multiple line cell data, so that's why not bothered fix problem.
If you fix it please share solution with us.
I had a issue about APEX version 4.0.2.
I can install the sample but create a new page by manual.
Baically copy from your source code but didn't work.
Do you have any idea for me to deal with it of older version?
Thanks a lot~
Hi Jerry Wang,
Im quite sure it relates jQuery version. Unfortunately I don't have access to APEX 4.0 to check.