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.

 

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: 19806
Votes: 75
Reviews: 128
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 
only the first 50 columns...
by Alex
on February 3, 2017
Do you plan to increase the number of columns in the next version?
10 
only the first 50 columns...
by Alex
on February 3, 2017
Do you plan to increase the number of columns in the next version?
10 
only the first 50 columns...
by Alex
on February 3, 2017
Do you plan to increase the number of columns in the next version?
10 
only the first 50 columns...
by Alex
on February 3, 2017
Do you plan to increase the number of columns in the next version?
10 
by Pushpanjali
on February 2, 2017
I am building appliaction using APEX 5.1
This plug-in is working fine when i select 'Table WWV_FLOW_FILES[Deprecated]' as the Storage type in 'File Browse'.
Since this type is Deprecated, i switched to 'Table APEX_APPLIACTION_TEMP_FILES'. But now this plug-in is not serving the purpose of copying data from Excel to Collections.
Could you please let me know which plug-in i should suppose to use now
10 
by Pushpanjali
on February 2, 2017
I am building appliaction using APEX 5.1
This plug-in is working fine when i select 'Table WWV_FLOW_FILES[Deprecated]' as the Storage type in 'File Browse'.
Since this type is Deprecated, i switched to 'Table APEX_APPLIACTION_TEMP_FILES'. But now this plug-in is not serving the purpose of copying data from Excel to Collections.
Could you please let me know which plug-in i should suppose to use now
10 
by Pushpanjali
on February 2, 2017
I am building appliaction using APEX 5.1
This plug-in is working fine when i select 'Table WWV_FLOW_FILES[Deprecated]' as the Storage type in 'File Browse'.
Since this type is Deprecated, i switched to 'Table APEX_APPLIACTION_TEMP_FILES'. But now this plug-in is not serving the purpose of copying data from Excel to Collections.
Could you please let me know which plug-in i should suppose to use now
0 
@ Will_R
by Anton Scheffer
on January 2, 2017
I don't have Excel2013 at hand right now, but I hope the plugin will handle that format without any changes. If you have any problems please send me a problematic Excel file and I will look into it.
10 
Plugin Update
by Will_R
on December 7, 2016
Hi Anton, do you have an update for excel2013
William
10 
Plugin Update
by Will_R
on December 7, 2016
Hi Anton, do you have an update for excel2013
William
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.