APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

 

Top Rated Plugins

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: 12150
Votes: 34
Reviews: 63
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 
@Muhammad
by Anton Scheffer
on June 25, 2015
I have no idea how you should configure your application servers. And I don't see a relation between your configuration and this plugin too.
0 
@Pavel
by Anton Scheffer
on June 25, 2015
Storage type wwv_flow_files might be deprecated, but it still does function, as does the plugin. But the latest version, see the demopage, can handle wwv_flow_temp_files too.
0 
by Muhammad
on June 25, 2015
Using Application Express 4.2.5.00.08 with Oracle (10g and 11g) and ORDS 2.0.
This native excel import with excel2collection works fine.
Now we have to move our APEX programs to run with Glassfish and WLS.
Both application servers uses ORDS 2.0.
How can we configure these application servers/ords to make this native excel import work?

Many thanks,
RI
0 
Problems in APEX 5
by Pavel
on June 23, 2015
Hello!
storage type wwv_flow_files deprecated in apex 5 and plug-in doesn't work. (((
Can you change storage table to APEX_APPLICATION_TEMP_FILES for APEX 5!
Thanks in advance!
0 
by Muhammad
on May 19, 2015
Thank you Anton. It is now working :)

Regards.
0 
@Muhammad
by Anton Scheffer
on May 19, 2015
At the demo application you can find the latest version, which fixes a bug with strings in XLSX on Oracle 10.2 databases. I'm not aware of any bugs on Oracle 11g
0 
Excel2Collection) plugin using for excel
by Muhammad
on May 19, 2015
Hi, I am using this plugin for data loading from the excel file within my APEX application. It is working perfect on dev and test environment which is under the oracle 11g but does not work properly on live that is 11g. There is no error and does work but I found some fields are empy or not mapping while loading. eg. c001, c002, c003 or so on.

10g APEX, c001 missing, c002 ok , c003 ok but c004 missing and so on. Can not find out what's wrong?

Please help. is that a bug?
p.s it is working on 11g.
regards. IK
0 
Excel2Collection) plugin using for excel
by Muhammad
on May 19, 2015
Hi, I am using this plugin for data loading from the excel file within my APEX application. It is working perfect on dev and test environment which is under the oracle 11g but does not work properly on live that is 11g. There is no error and does work but I found some fields are empy or not mapping while loading. eg. c001, c002, c003 or so on.

10g APEX, c001 missing, c002 ok , c003 ok but c004 missing and so on. Can not find out what's wrong?

Please help. is that a bug?
p.s it is working on 11g.
regards. IK
10 
question
by Yang
on May 13, 2015
It takes 272 seconds to load Excel file into collection.The Excel file is 52 KB in size, has 2000 records and 10 columns. if do something wrong. can some one help me??
10 
by Yang
on May 13, 2015
Documentation will be better.
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.