APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Professional Oracle APEX Hosting
Check it out!
 

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: 10924
Votes: 28
Reviews: 53
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 
@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.
0 
Load problem
by Nikola
on April 1, 2015
Hi,

it seems like this plugin loads our Oracle server every time user uploads Excel file to the application.

Do you have any issues regarding system overlaod?

Is it possible to limit the Excel file with plugin?

Nikola
0 
@Angus Crighton
by Anton Scheffer
on March 11, 2015
This plugin loads every row into a collection. If you know that the first row contains columns you can decide not to process that first row. That's something you have to do your self, this plugin doesn't have an option to skip the first row.
10 
Column Headers
by Angus Crighton
on March 11, 2015
I noticed that when I load my csv file, the column headers appear as the first row of the collection.
How do I stop that happening

Gus
0 
by Alexandra Robin
on February 17, 2015
I realize this isn't quite the forum for support. I'll continue looking on my end. Have a great day.
10 
form/collection
by Alexandra Robin
on February 17, 2015
Yes. Thank you. I understand that. It's getting the data from the collection into the table that I'm needing help with.
And I apologize if I am not using this chat thing correctly. Thanks for a GREAT plugin.
0 
@Alexandra
by Anton Scheffer
on February 17, 2015
This plugin loads the data from a CSV-file into a Apex collection, not into a form. Using that collection you can store the data into a table. And use a primary key from a form if you want.
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.