APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

 

Top Rated Plugins

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: 10252
Votes: 28
Reviews: 48
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 
@Angus Crighton
by Anton Scheffer
on March 11, 2015
This plugin loads every row into a collection. If you know that the first row contains columns you can decide not to process that first row. That's something you have to do your self, this plugin doesn't have an option to skip the first row.
10 
Column Headers
by Angus Crighton
on March 11, 2015
I noticed that when I load my csv file, the column headers appear as the first row of the collection.
How do I stop that happening

Gus
0 
by Alexandra Robin
on February 17, 2015
I realize this isn't quite the forum for support. I'll continue looking on my end. Have a great day.
10 
form/collection
by Alexandra Robin
on February 17, 2015
Yes. Thank you. I understand that. It's getting the data from the collection into the table that I'm needing help with.
And I apologize if I am not using this chat thing correctly. Thanks for a GREAT plugin.
0 
@Alexandra
by Anton Scheffer
on February 17, 2015
This plugin loads the data from a CSV-file into a Apex collection, not into a form. Using that collection you can store the data into a table. And use a primary key from a form if you want.
10 
link to form using primary key on form
by Alexandra Robin
on February 17, 2015
I am using Oracle Apex 4.2. This plugin is perfect for what I am trying to do.

I have created a form for cataloging documents in our company. There may be many different items (jars of spices) with which the catalogued document is connected. Instead of the user entering these items one-at-a-time, (or continuing the fiasco of copying and pasting over 4000 characters into a text area using whatever delimiter looks nice for the day) the user exports the list from PeopleSoft, saves it as a .csv, then uses the plugin to upload that list into the form.
So I need to link the primary key for the form to the uploaded csv.

Any suggestions?
0 
CSV field separator by Page Item
by sean
on October 28, 2014
value works. Thank you for the prompt help.
I'm putting your plug-in for a production system Data Import, it performs wonderfully so far. Thanks again, have a wonderful day.
0 
@sean
by Anton Scheffer
on October 28, 2014
Thats's possible in Apex 4.2 Use something like &P1_CSV_SEP. (that's fieldname with ampersand and trailing period ) And check that in the plugin definition "Substitute Attribute Values" is set to Yes
10 
CSV field seperator set by page item
by sean
on October 28, 2014
Thanks for the great plug-in, I enjoyed it.

The field seperator for CSV file is set inside the plug-in settings, can I set it dynamically like by PAGE ITEM? I can't find a way to dynamically change CSV field seperator ( and other settings like Enclosed By), thanks
10 
dates
by Jerome
on October 21, 2014
Hi, my issue regarding dates is already resolved by changing the cell format in xls file..
This plugin 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.