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: 29852
Votes: 98
Reviews: 180
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 
@Mohit
by Anton Scheffer
on April 12, 2018
Something not clear in the readme or the example application included in the download?
0 
How to Use
by Mohit
on April 12, 2018
Hi Team

Could you please explain how I can use this plugin.

Regards
Mohit Vishwakarma
0 
How to Use
by Mohit
on April 12, 2018
Hi Team

Could you please explain how I can use this plugin.

Regards
Mohit Vishwakarma
0 
How to Use
by Mohit
on April 12, 2018
Hi Team

Could you please explain how I can use this plugin.

Regards
Mohit Vishwakarma
0 
How to Use
by Mohit
on April 12, 2018
Hi Team

Could you please explain how I can use this plugin.

Regards
Mohit Vishwakarma
0 
@Javier Velez
by Anton Scheffer
on January 24, 2018
I don't know, I've never tried it. But if you receive a server error it doesn't look possible without changing anything.
0 
AJAX Callback
by Javier Velez
on January 24, 2018
can this plugin be used as AJAX Callback? I''m trying to have javascript call an ajax callback process but then it fails with "AJAX call returned server error ... no data found for"
here is my javascript code:
var loadExcel = function() {
apex.server.process(
'loadExcel2', // Process or AJAX Callback name
{pageItems: "#P4_FILE_BROWSER,#P4_NAME"}, // items passed for browse time and collection name
{
dataType: 'text', // Response type (here: plain text)
success: function( pData ) {
alert(pData); // Show the result
apex.event.trigger('#PartCodesList', 'apexrefresh') // refresh Interactive report
}
}
);
};
0 
load varchar2 to collection
by moran
on January 15, 2018
Hi Amis,
Great plugin!!
When I'm loading xls file, I can see string data in the collection, but when I'm loading xlsx file, only the number fields are loaded into the collection.
Is there any way to solve it?
Is it related to the mime type I'm using to built the xlsx file?
Thanks
10 
load varchar2 to collection
by moran
on January 15, 2018
Hi Amis,
Great plugin!!
When I'm loading xls file, I can see string data in the collection, but when I'm loading xlsx file, only the number fields are loaded into the collection.
Is there any way to solve it?
Is it related to the mime type I'm using to built the xlsx file?
Thanks
10 
load varchar2 to collection
by moran
on January 15, 2018
Hi Amis,
Great plugin!!
When I'm loading xls file, I can see string data in the collection, but when I'm loading xlsx file, only the number fields are loaded into the collection.
Is there any way to solve it?
Is it related to the mime type I'm using to built the xlsx file?
Thanks
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.