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

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

Excel, process type

Oracle APEX Plugin
Company: AMIS
Date added: 14.12.2010
Views: 34245
Votes: 24
Reviews: 83
Min. APEX Version:
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
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.
@Sue Ellen
by Anton Scheffer
on February 11, 2015
If you follow the readme everything should be working. If it's not working and you don't get an error message you did not follow the readme. Is your process point On Load - Before Header?
Nothing happens when I clik on the butto
by Sue Ellen
on February 11, 2015
Hello Anton, thank you for sharing this plugin.

I installed it and followed the steps you described in the readme.txt file. After I click on the button, nothing happens. The page is refreshed, but the excel file is not generated. I already tried to use different values on the "Request" field. I also tried to change the parameters values, but nothings works.

Could you please give me some guidance how to proceed in this case? Would it be possible if you send the application? So, I could import and try to find where I did it wrong.

Thank you,
Sample application
by Jhuma Chakraborty
on December 2, 2014
Hi, i am getting several errors with plugin like 'End of headers not found', then sometimes its tries to download a zip file. Not sure if I am doing something wrong. Is it possible get a example application that we can import to see how you are setting it up. Thanks
@TOm Raudabaugh
by Anton Scheffer
on October 23, 2014
I've place a new version at the demo page https://apex.oracle.com/pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=6671994813309407839&p_fname=process_type_plugin_nl_amis_scheffer_process_xlsx_0814.sql that version should fix it
Text With Leading Spaces Not Show Space
by Tom Raudabaugh
on October 23, 2014
Hi Anton,
Have been using plugin since initial version. Wondering if current version of XLSX version maintains leading spaces on text data. My version I have is the initial version. When I see text columns the leading spaces are truncated. Need for providing indentation look on columns.

Error in date format
by Eduardo Colazo
on July 17, 2014
The error still remains. I send you an e-mail with details and a debug file. Thanks.
@Eduardo Colazo
by Anton Scheffer
on July 16, 2014
Change the value of the plugin-parameter "Append sysdate to filename?" and everything should work OK
Error in date format
by Eduardo Colazo
on July 16, 2014
When i execute the plugin, i receive the error 'ORA-01821: date format not recognized', even there is no date column selected in the query . The proyect uses default date format 'DD/MM/YYY', as usual in Latinoamerica.
by Anton Scheffer
on July 9, 2014
I can do nothing about that. Try downloading it again
downloaded zip file issue
by Anuradha
on July 9, 2014

I downloaded the excel_plugin.zip file and saved it to my local folder. When i try to open the zip, I get this error message:

"Cannot open file: it does not appear to be a valid archive. If you downloaded this file, try downloading the file again"

I want to use this plugin in my apex application. Quick help appreciated.
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.