APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your Website, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Process Type Plugin EXCEL2COLLECTIONS

EXCEL2COLLECTIONS

9
Categories: Process Type Plugin
Author: Anton Scheffer

Upload an Excel file into an Apex Collection

This is a Process Type Plugin to load an Excel file into an Apex Collection.
Excel can be in format XLSX, XLS, XML 2003 or CSV. Because the data is loaded into the "varchar2" columns of an Apex Collection only the first 50 columns of an Excel sheet are loaded.

 See the demo page, https://apex.oracle.com/pls/apex/f?p=33308:LOGIN_DESKTOP:::::: , for the latest version of the plugin.

New version 0.804
  XLSX: Fix bug for formated strings
  CSV: Support for HT separator
New version 0.802
  Support for XLSX numbers stored in scientific notation
  Fix bug for XLSX empty strings



Keywords
Excel

Oracle APEX Plugin
Company: AMIS
Date added: 24.2.2013
Views: 33674
Votes: 105
Reviews: 192
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
2 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.
i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.
can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
2 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.
i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.
can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
2 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.
i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.
can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
2 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.
i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.
can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
2 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.

i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.

can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
0 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.

i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.

can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
0 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.

i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.

can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
0 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.

i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.

can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
0 
msg: apex 5.0 No uploaded document found
by mellad
on October 16, 2018
hi
i am new to this plugin i did the following and received msg in the title need ur help.
actually i want to upload an xlsx file which contains arabic characters too and insert that in a table in database.

i added "file browser" item and button for loading data, and a process then select its type to "excel2collection", that is it.

can you please write for me the codes and other requirement to do to upload the xlsx file and insert it in that table, thanks appreciate your help
0 
@František Mika
by Anton Scheffer
on June 8, 2018
The updated version from the demopage has a "Round Excel number" setting which might help.
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.