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 (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!!

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: 24263
Votes: 22
Reviews: 70
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 
important
by Henriett
on March 6, 2014
Hi! My new problem is that some report don't have header, but have data and some report have header and don't have data in xlsx. Can you help me? Thank you.
0 
another problem
by Henriett
on February 26, 2014
Hi!
Thanks for your reply, but I have another problem.... In Firefox if i try to export the report the file isn't an xlsx file. For example I need filename.xlsx but the result is filename.xlsx-1.htm. And this is just a firefox problem :( Thanks in advice.
0 
@ Henriett
by Anton Scheffer
on February 24, 2014
That is something I can't reproduce. See for example the demo application, The region "Clasic based on PLSQL-function" has a column name with a space, and that is shown correct in the excel.
0 
space mistake
by Henriett
on February 20, 2014
When I export the report the column names have a space mistake. For example this is the column name: Corrected Start and in the xlsx is Corrected Start
What should I do?
0 
Only Report Can Be Exported in Excel
by Shivakumar Aiyadurai
on December 19, 2013
This is just a wonderful post.

I have a doubt in this plugin.

Is it that only one report data can be exported in excel ?

Else, all the reports created on a particular page can be exported in excel on a single button click ?
0 
by Krishna
on November 16, 2013
How to work this plugin
10 
@David Sykes
by Anton Scheffer
on October 30, 2013
At the time I build this plugin I had no idea how to get those row filtering values, so this plugin doesn't have the possibility to filter the data
0 
IR Report Filter in APEX 4.2.0
by David Sykes
on October 29, 2013
This plugin produces excellent excel output, particulary the auto-filter and freeze-pane options. However, it does not apply the current Interactive Reports (IR) row filtering to the downloaded data set. I am getting the entire table. Any advice would be appreciated. Thanks, Dave
10 
@Klaus Barthels
by Anton Scheffer
on September 30, 2013
If you install this plugin in SQL*Plus you have to set the workspace ID with apex_application_install.set_workspace_id. See http://joelkallman.blogspot.com/2010/07/apexapplicationinstall.html
0 
How to install in apex 4.2
by Klaus Barthels
on September 30, 2013
I try to install this plugin in apex 4.2.
But I get the following messages:
Set Credentials...
Check Compatibility...
API Last Extended:20120101
Your Current Version:20120101
This import is compatible with version: 20100513
COMPATIBLE (You should be able to run this import without issues.)
Set Application ID...
...plugins
Error creating plug-in id="5344994831381285" ORA-20001: Application ID and current security group ID are not consistent.
Error creating plug-in attribute id="5370191867980239" ORA-20001: Application ID and current security group ID are not consistent.
Error creating plug-in attribute value id="5370797408981873" ORA-20001: Application ID and current security group ID are not consistent........

What can I do?

Regards

Klaus
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.