APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX4.0 Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your website or blog.

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

EXCEL2COLLECTIONS

10
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.

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: 7768
Votes: 24
Reviews: 42
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.
0 
CSV field separator by Page Item
by sean
on October 28, 2014
value works. Thank you for the prompt help.
I'm putting your plug-in for a production system Data Import, it performs wonderfully so far. Thanks again, have a wonderful day.
0 
@sean
by Anton Scheffer
on October 28, 2014
Thats's possible in Apex 4.2 Use something like &P1_CSV_SEP. (that's fieldname with ampersand and trailing period ) And check that in the plugin definition "Substitute Attribute Values" is set to Yes
10 
CSV field seperator set by page item
by sean
on October 28, 2014
Thanks for the great plug-in, I enjoyed it.

The field seperator for CSV file is set inside the plug-in settings, can I set it dynamically like by PAGE ITEM? I can't find a way to dynamically change CSV field seperator ( and other settings like Enclosed By), thanks
10 
dates
by Jerome
on October 21, 2014
Hi, my issue regarding dates is already resolved by changing the cell format in xls file..
This plugin rocks..
0 
@Jerome
by Anton Scheffer
on October 17, 2014
If you are uploading a XLS-file, you should try an updated version you can find at the demo-page, https://apex.oracle.com/pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=8299127631645792085&p_fname=process_type_plugin_nl_amis_scheffer_process_excel2collection_0812.sql That version might solve your problem
0 
dates
by Jerome
on October 17, 2014
hi, i noticed that date data types are changed in the collection table..
"1-Oct-14" became "41913"
is there a way to convert it backwards to retain "1-Oct-14" and update the collection table??
0 
by Arif Khadas
on October 8, 2014
Thanks Anton Scheffer it is working fine no issues, just had to set report property Maximum Row Count
0 
by Arif Khadas
on October 8, 2014
Thanks Anton Scheffer for your reply.
Then what can be the reason that it is only uploading 500 records.
Secondly I tried to upload data using DEMO link provided, there too it just uploaded 500 records.
10 
@Arif
by Anton Scheffer
on October 2, 2014
No there are no limits build into the plugin, 5000 records should be no problem
0 
Max Limit of rows that can be uploaded
by Arif Khadas
on October 2, 2014
Is there a maximum limit of rows that can be uploaded. I tried to upload data with more then 5000 records but only 500 could be uploaded.

Thanks & Regards
Arif Khadas
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.