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: 11589
Votes: 33
Reviews: 59
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 
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.
0 
@Anton Scheffer
by Nikola
on April 1, 2015
About 6 secs
0 
@Nikola
by Anton Scheffer
on April 1, 2015
And what is the time if you load the same using a CSV file
0 
@Anton Scheffer
by Nikola
on April 1, 2015
It takes 12 seconds to load Excel file into collection.
The Excel file is 231 KB in size, has 3689 records and 10 columns.

Is this normal behaviuor?

I have done debug in APEX and have 3 critical moments:

read "sheet name" - it takes 12 secs
Collection - returning collection ID - it takes 3 secs

Nikola
0 
@Nikola
by Anton Scheffer
on April 1, 2015
No, I don't have issues with system overload. That might have to do with the fact that I don't use this plugin to load XLSX-files of more than 100Mb. If you want to load large files, CSV is the fastest option. But, this plugin loads the data into an Apex-Collection. That is the limiting factor for performance. Inserting a lot of data into a collection takes time. And no, this plugin can't restrict file size or type.
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.