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: 28210
Votes: 98
Reviews: 175
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 
@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
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
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
0 
@Javier Velez
by Anton Scheffer
on January 13, 2018
At the demo page you can find an updated version of the plugin which supports 'APEX_APPLICATION_TEMP_FILES'
10 
Dev
by Javier Velez
on January 12, 2018
I'm using APEX 5.1.3.00.05 and I've downloaded your plugin. I was able to deploy your demo app it runs great as long as the field browser's storage type is set to 'WWV_FLOW_FILES' (which is deprecated) but when I change it to 'APEX_APPLICATION_TEMP_FILES' it stops working. I was not able to find anything about this in the readme file. Is there something I'm missing or need to do after the change in storage type?

thanks
10 
Dev
by Javier Velez
on January 12, 2018
I'm using APEX 5.1.3.00.05 and I've downloaded your plugin. I was able to deploy your demo app it runs great as long as the field browser's storage type is set to 'WWV_FLOW_FILES' (which is deprecated) but when I change it to 'APEX_APPLICATION_TEMP_FILES' it stops working. I was not able to find anything about this in the readme file. Is there something I'm missing or need to do after the change in storage type?

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.