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 (IR) Report to Excel (xlsx)

(IR) Report to Excel (xlsx)

9
Categories: Process Type Plugin
Author: Anton Scheffer

Download the output of your report as an Excelfile

 This plugin uses the source queries of all report regions on a page, either a clasic or interactive,
and puts the results of these queries in a Microsoft Excel file, ready for download. This plugin uses the Excel 2007 format .xlsx

 This plugin is limited to 26 columns!!

On the demopage you can find the latest version

new version 0.806

Special Requirements
Changelog:
version 0.806
support for Wizard Report
support for SQL Report based on a PL/SQL function body returning SQL query
XML-escaping for string data and sheetnames

version 0.804
support for timestamp and clob
filename changed from anton.xlsx

version 0.802
fixed a bug on 11.2 databases

version 0.800
initial version

Keywords
Excel, process type

Oracle APEX Plugin
Company: AMIS
Date added: 14.12.2010
Views: 50111
Votes: 70
Reviews: 158
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 
Downloading filtered Interactive report.
by Hong Gyoon Jung
on October 3, 2017
Hi,
I figured out and it is working now.

But is there a way to just download the filtered rows rather than the entire report?

Thank you in advance.
0 
Downloading filtered Interactive report.
by Hong Gyoon Jung
on October 3, 2017
Hi,
I figured out and it is working now.

But is there a way to just download the filtered rows rather than the entire report?

Thank you in advance.
0 
Questions on the instruction
by Hong Gyoon Jung
on October 2, 2017
Could anyone help out with my issue with the instruction?
Thank you.
0 
Questions on the instruction
by Hong Gyoon Jung
on October 2, 2017
Could anyone help out with my issue with the instruction?
Thank you.
10 
Questions on the instruction.
by Hong Gyoon Jung
on September 28, 2017
Hi Anton,
First of all, thank you for your plugins. Excel2Collection is also a great plugin.

I was wondering whether you can elaborate a little bit more on the instruction in 'Readme' file.
I am currently using the latest APEX 5.

Use as Process Point "On Load - Before Header" (I got this.)

Use a Condition Type "Request = Expression 1"
(I am not sure of it.)
Add a Region Button to your page. (Got this)
I use a HTML Button with Action "Redirect to Page in this Application", but other type will probably function too.(Got this)
The Redirected Page should be the same page, also button, process and report should all be on the same page. (Not sure)
And use as Request the same value you have used in the Condition of the process. (Not sure)

Thank you!
10 
Questions on the instruction.
by Hong Gyoon Jung
on September 28, 2017
Hi Anton,
First of all, thank you for your plugins. Excel2Collection is also a great plugin.

I was wondering whether you can elaborate a little bit more on the instruction in 'Readme' file.
I am currently using the latest APEX 5.

Use as Process Point "On Load - Before Header" (I got this.)

Use a Condition Type "Request = Expression 1"
(I am not sure of it.)
Add a Region Button to your page. (Got this)
I use a HTML Button with Action "Redirect to Page in this Application", but other type will probably function too.(Got this)
The Redirected Page should be the same page, also button, process and report should all be on the same page. (Not sure)
And use as Request the same value you have used in the Condition of the process. (Not sure)

Thank you!
0 
Questions on the instruction.
by Hong Gyoon Jung
on September 28, 2017
Hi Anton,
First of all, thank you for your plugins. Excel2Collection is also a great plugin.

I was wondering whether you can elaborate a little bit more on the instruction in 'Readme' file.
I am currently using the latest APEX 5.

Use as Process Point "On Load - Before Header" (I got this.)

Use a Condition Type "Request = Expression 1"
(I am not sure of it.)
Add a Region Button to your page. (Got this)
I use a HTML Button with Action "Redirect to Page in this Application", but other type will probably function too.(Got this)
The Redirected Page should be the same page, also button, process and report should all be on the same page. (Not sure)
And use as Request the same value you have used in the Condition of the process. (Not sure)

Thank you!
6 
what about bind variables ? not working
by Joe B
on August 8, 2017
Hi,

Our select statements are dominated by many bind variables which we need; but the plug-in does not work in those cases. Any ideas ? Newbie to this group.
6 
what about bind variables ? not working
by Joe B
on August 8, 2017
Hi,

Our select statements are dominated by many bind variables which we need; but the plug-in does not work in those cases. Any ideas ? Newbie to this group.
0 
@tony miller
by Anton Scheffer
on May 12, 2017
The download contains a readme, which shows how you can use the plugin (or any process type plugin). Do you have any specific questions about using this plugin?
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.