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: 17323
Votes: 59
Reviews: 100
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.
2 
Developer
by mohan
on July 26, 2016
Hi,

I had an issue while uploading a xls file using this plugin. Actually the data in the XLS has several line feeds. After the data is extracted to the collection I don't see the new line feed and all the data is appearing in a single line.
Eg: my data at location A11 in my xls is like

"ABC
EFG
HIJ"

Thanks,
Mohan
2 
Developer
by mohan
on July 26, 2016
Hi,

I had an issue while uploading a xls file using this plugin. Actually the data in the XLS has several line feeds. After the data is extracted to the collection I don't see the new line feed and all the data is appearing in a single line.
Eg: my data at location A11 in my xls is like

"ABC
EFG
HIJ"

Thanks,
Mohan
2 
Developer
by mohan
on July 26, 2016
Hi,

I had an issue while uploading a xls file using this plugin. Actually the data in the XLS has several line feeds. After the data is extracted to the collection I don't see the new line feed and all the data is appearing in a single line.
Eg: my data at location A11 in my xls is like

"ABC
EFG
HIJ"

Thanks,
Mohan
2 
Developer
by mohan
on July 26, 2016
Hi,

I had an issue while uploading a xls file using this plugin. Actually the data in the XLS has several line feeds. After the data is extracted to the collection I don't see the new line feed and all the data is appearing in a single line.
Eg: my data at location A11 in my xls is like

"ABC
EFG
HIJ"

Thanks,
Mohan
2 
Developer
by mohan
on July 26, 2016
Hi,

I had an issue while uploading a xls file using this plugin. Actually the data in the XLS has several line feeds. After the data is extracted to the collection I don't see the new line feed and all the data is appearing in a single line.
Eg: my data at location A11 in my xls is like

"ABC
EFG
HIJ"

Thanks,
Mohan
2 
Developer
by mohan
on July 26, 2016
Hi,

I had an issue while uploading a xls file using this plugin. Actually the data in the XLS has several line feeds. After the data is extracted to the collection I don't see the new line feed and all the data is appearing in a single line.
Eg: my data at location A11 in my xls is like

"ABC
EFG
HIJ"

Thanks,
Mohan
6 
Developer
by mohan
on July 26, 2016
Hi,

I had an issue while uploading a xls file using this plugin. Actually the data in the XLS has several line feeds. After the data is extracted to the collection I don't see the new line feed and all the data is appearing in a single line.
Eg: my data at location A11 in my xls is like

"ABC
EFG
HIJ"

Thanks,
Mohan
6 
Developer
by mohan
on July 26, 2016
Hi,

I had an issue while uploading a xls file using this plugin. Actually the data in the XLS has several line feeds. After the data is extracted to the collection I don't see the new line feed and all the data is appearing in a single line.
Eg: my data at location A11 in my xls is like

"ABC
EFG
HIJ"

Thanks,
Mohan
0 
@Haenen
by Anton Scheffer
on June 15, 2016
When loading a xlsx NLS_NUMERIC_CHARACTERS are used to store a number into a varchar2 collection column. A CSV file doesn't know anything about numbers, it just contains strings. So a string containing digits, comma's and dots is just stored as it is read
10 
user
by Haenen
on June 14, 2016
Hi Anton, nice plugin.

The plugin supports csv as wel as xlsx format, great!
I used it for importing a contingency table.
One small thing though, when importing an excelsheet as csv my number format is 99.99999999 and when using xlsx format the number fomat is 99.9999999 . (comma versus dot)
Is there a way to handle this so that the result is always 99.999999 or always 99,99999?

Thanks Haenen
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.