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: 7140
Votes: 17
Reviews: 39
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.
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
0 
Not working again
by Tobin
on August 3, 2014
It happen again, removing and recreate the File Browser did not help.
Don't know what happen. Anyone can help ?
10 
Generic Validation
by Jacob
on July 31, 2014
When declaring
wrong_file exception;

In code
if t_filename like lower('%.xls%') OR t_filename like lower('%.xlsx%') OR t_filename like lower('%.xml%') OR t_filename like
lower('%.csv%')
then
log( 'proper file found ' );
else
raise wrong_file;
end if;

In exception handling
when wrong_file
then
t_rv.success_message := 'File must be XLS, XLSX, CSV, or XML';
return t_rv;
0 
Suddenly stop working (3) - solved
by Tobin
on July 23, 2014
Problem solved by deleting the file browser page item and create new one.
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.