APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX 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: 25350
Votes: 92
Reviews: 157
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 
@Hong
by Anton Scheffer
on August 16, 2017
The download includes a demo application, showing how to use this plugin, and a readme showing how to add a button. And I don't use facebook or any other messaging application outside twitter.
10 
Creating a button calling the plugin
by Hong Gyoon Jung
on August 10, 2017
Hi,
I am a new beginner trying to utilize your plugin.
First of all thank you for your plugin.

I hope to utilize it soon.

I was wondering how could I create a button calling the plugin?

Also, how could I add the CSV data into the existing table on Oracle Apex and mapping all the columns.

Do you have a messenger like Facebook or any others that I can communicate?
I have been having this issue for two months now.
Your help is really appreciated!

Thank you.
Hong
0 
Creating a button calling the plugin
by Hong Gyoon Jung
on August 10, 2017
Hi,
I am a new beginner trying to utilize your plugin.
First of all thank you for your plugin.

I hope to utilize it soon.

I was wondering how could I create a button calling the plugin?

Also, how could I add the CSV data into the existing table on Oracle Apex and mapping all the columns.

Do you have a messenger like Facebook or any others that I can communicate?
I have been having this issue for two months now.
Your help is really appreciated!

Thank you.
Hong
0 
Creating a button calling the plugin
by Hong Gyoon Jung
on August 10, 2017
Hi,
I am a new beginner trying to utilize your plugin.
First of all thank you for your plugin.

I hope to utilize it soon.

I was wondering how could I create a button calling the plugin?

Also, how could I add the CSV data into the existing table on Oracle Apex and mapping all the columns.

Do you have a messenger like Facebook or any others that I can communicate?
I have been having this issue for two months now.
Your help is really appreciated!

Thank you.
Hong
10 
how use the excel2collection plugin
by maram
on July 3, 2017
hi,
I used the plugin
https://apex.oracle.com/pls/apex/f?p=52007:5:110559789031799:::5:P5_PLUG_ID:7805014497003786 in APEX 5.1.

First it didn't work but after replacing apex_application_files with apex_application_temp_files in PL/SQL Code all problems disappeared:)
kind regards
Mary
10 
how use the excel2collection plugin
by maram
on July 3, 2017
hi,
I used the plugin
https://apex.oracle.com/pls/apex/f?p=52007:5:110559789031799:::5:P5_PLUG_ID:7805014497003786 in APEX 5.1.

First it didn't work but after replacing apex_application_files with apex_application_temp_files in PL/SQL Code all problems disappeared:)
kind regards
Mary
0 
@Rajitha
by Anton Scheffer
on June 28, 2017
You don't need anything dynamic for that. Every file loaded it treated indepedend. If you load an Excel with 3 columns, you can see those 3 columns in the APEX collection. If the Excel uses 2 columns, you see 2 columns in the APEX collection
10 
Dynamic column upload
by Rajitha
on June 27, 2017
@Anton, Can we upload dynamic columns using this collections? For eg: My excel file 1 has columns A,B and C. File 2 has Columns A and C.
0 
Dynamic column upload
by Rajitha
on June 27, 2017
@Anton, Can we upload dynamic columns using this collections? For eg: My excel file 1 has columns A,B and C. File 2 has Columns A and C.
10 
Upload Dynamic Columns
by Rajitha
on June 27, 2017
@Anton, Can we upload dynamic columns using this collections? For eg: My excel file 1 has columns A,B and C. File 2 has Columns A and C.
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.