APEX-PLUGIN.COM

..the apex plugin directory

an initiative of
 

Latest Plugins

 

Top Rated Plugins

Context(rightclick) Menu (4.9)10
Combobox (4.8)10
SkillBuilders Super LOV (4.8)10
(IR) Report to Excel (xlsx) (4.8)10
DTreeTable (4.8)10

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 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: 1640
Votes: 1
Reviews: 5
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 
Awesome
by Pete Mahon
on March 28, 2013
APEX team take note - this is a highly desirable feature! Would be great to see this in v5.

Great job Anton, many thanks.
0 
@Drafan
by Anton Scheffer
on March 25, 2013
Excel 2003 (xls) has a numeric precision of about 15 decimals. 214,3999999999999991 and 214,400000000000000 differ beyond that precision. This plugin doesn't look at any Excel formatting, so it can't make a distinction between the 214,3999999999999991 which is stored and the 214,400000000000000 which is displayed
0 
by Drafan
on March 25, 2013
Hi!

Yes, I am sure. If I format field in excel to show 15 decimal places I get 214,400000000000000.

That problem occurs at diferent numbers, some are right and some others not.

I think there is problem with utl_compress.lz_uncompress or utl_encode.base64_decode functions :|
0 
@Drafan
by Anton Scheffer
on March 25, 2013
No, there's no way to change the number.
But are your sure that you don't have 214,3999999999999991 in your Excel (as a result of a formula) and that you DISPLAY only the rounded value?
0 
Problem with showing number values
by Drafan
on March 25, 2013
Hi!

I have one problem with these plug-in. In excel file I have column price and when I import that file in db there is wrong number (eg. in file I have 214,40 and in database is 214,3999999999999991). Is there any way to get right number?

Regards.
March 15, 2013
The Entry has been updated in the meantime!
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.