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

10
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: 16657
Votes: 47
Reviews: 89
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 
@Richard
by Anton Scheffer
on February 25, 2016
No, it's not possible to use this plugin to load more than 50 columns
10 
More than 50 columns for EXCEL2COLLETION
by Richard
on February 23, 2016
Hi Anton, please excuse my question if it isn't sensible, I'm new to APEX. I have to process some spreadsheets with more than 50 columns, is it possible to create multiple collections to hold columns 51-100, 101-150 etc.? Thank you, Richard.
10 
More than 50 columns for EXCEL2COLLETION
by Richard
on February 23, 2016
Hi Anton, please excuse my question if it isn't sensible, I'm new to APEX. I have to process some spreadsheets with more than 50 columns, is it possible to create multiple collections to hold columns 51-100, 101-150 etc.? Thank you, Richard.
0 
More than 50 columns for EXCEL2COLLETION
by Richard
on February 23, 2016
Hi Anton, please excuse my question if it isn't sensible, I'm new to APEX. I have to process some spreadsheets with more than 50 columns, is it possible to create multiple collections to hold columns 51-100, 101-150 etc.? Thank you, Richard.
10 
Selection of data to upload
by Stephane RUAULT
on December 18, 2015
Is it possible to select which sheets from an excel file are uploaded?
Is it possible to select a range in the sheet to be uploaded?
We have a case where we have an Excel file with multiple sheets and we would like to load only selected pieces of data.
Thanks in advance for your answer
0 
Selection of data to upload
by Stephane RUAULT
on December 18, 2015
Is it possible to select which sheets from an excel file are uploaded?
Is it possible to select a range in the sheet to be uploaded?
We have a case where we have an Excel file with multiple sheets and we would like to load only selected pieces of data.
Thanks in advance for your answer
6 
Selection of data to upload
by Stephane RUAULT
on December 18, 2015
Is it possible to select which sheets from an excel file are uploaded?
Is it possible to select a range in the sheet to be uploaded?
We have a case where we have an Excel file with multiple sheets and we would like to load only selected pieces of data.
Thanks in advance for your answer
0 
Selection of data to upload
by Stephane RUAULT
on December 18, 2015
Is it possible to select which sheets from an excel file are uploaded?
Is it possible to select a range in the sheet to be uploaded?
We have a case where we have an Excel file with multiple sheets and we would like to load only selected pieces of data.
Thanks in advance for your answer
0 
by Jerome
on October 20, 2015
nevermind the ñ issue
i just have to use 'WE8MSWIN1252' as the value for encoding,, works like a charm..



ps
your plug-in rocks
10 
ñ
by Jerome
on October 20, 2015
hi, i tried to upload a file with a special character ñ,
it looks different in apex_collections

'Nuñez' becomes Nu?

any idea?


ps
your plug-in rocks
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.