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, GitHup Repository or Blog.

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

EXCEL2COLLECTIONS

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

 See the demo page, https://apex.oracle.com/pls/apex/f?p=33308:LOGIN_DESKTOP:::::: , for the latest version of the plugin.

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: 22543
Votes: 86
Reviews: 146
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 
by Katie Smith
on June 15, 2017
NEVERMIND

I found the readme and was able to get things going.

Great plugin- thank you!
10 
How do I get started
by Katie Smith
on June 14, 2017
I know this plugin is exactly what I need, but How do I get started?

I loaded the plugin through the Shared Component area.

I created a page and added a file browse.
I set the storage type to APEX_APPLICATION_TEMP_FILES

I browsed, selected a simple file, submitted the page and checked my collections. There is nothing populated.

Do I need to manually populate the collection (add member, etc)?
10 
How do I get started using plugin
by Katie Smith
on June 14, 2017
I know this plugin is exactly what I need, but How do I get started?

I loaded the plugin through the Shared Component area.

I created a page and added a file browse.
I set the storage type to APEX_APPLICATION_TEMP_FILES

I browsed, selected a simple file, submitted the page and checked my collections. There is nothing populated.

Do I need to manually populate the collection (add member, etc)?
10 
How do I get started using plugin
by Katie Smith
on June 14, 2017
I know this plugin is exactly what I need, but How do I get started?

I loaded the plugin through the Shared Component area.

I created a page and added a file browse.
I set the storage type to APEX_APPLICATION_TEMP_FILES

I browsed, selected a simple file, submitted the page and checked my collections. There is nothing populated.

Do I need to manually populate the collection (add member, etc)?
10 
How do I get started using plugin?
by Katie Smith
on June 14, 2017
I know this plugin is exactly what I need, but How do I get started?

I loaded the plugin through the Shared Component area.

I created a page and added a file browse.
I set the storage type to APEX_APPLICATION_TEMP_FILES

I browsed, selected a simple file, submitted the page and checked my collections. There is nothing populated.

Do I need to manually populate the collection (add member, etc)?
10 
How do I get started using plugin?
by Katie Smith
on June 14, 2017
I know this plugin is exactly what I need, but How do I get started?

I loaded the plugin through the Shared Component area.

I created a page and added a file browse.
I set the storage type to APEX_APPLICATION_TEMP_FILES

I browsed, selected a simple file, submitted the page and checked my collections. There is nothing populated.

Do I need to manually populate the collection (add member, etc)?
0 
@Anton
by Jolande van den Berg
on May 18, 2017
Yes, that is correct, I selected APEX_APPLICATION_TEMP_FILES. I've uploaded the lates version of the plugin located on the demo page and now it works! Thank you very much! One last thing, the application on your demo page throws an ORA-01653 error.
Thanks again for your help!
0 
@Jolande
by Anton Scheffer
on May 17, 2017
Probably you are using the "new" target APEX_APPLICATION_TEMP_FILES which wasn't available when I created this plugin. So you have two options:
- change the target
- use the latest version of this plugin, see the demo page
0 
No uploaded document found
by Jolande van den Berg
on May 17, 2017
Hi,
I'm using Apex 5 on Oracle 11g database and after loading your plugin and create an upload page I get the message No uploaded document found.
What could I be doing wrong?
Sincerly
Jolande
0 
@Drew
by Anton Scheffer
on May 4, 2017
Loading a XLSX file with 30 columns should work. If the loading just finishes without an error message you probably have a wrong value for the parameter "Sheets" of the plugin.
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.