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 not compile PASTE_EXCEL_UTIL package to your schema.
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.