..the apex plugin directory

an initiative of

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: 37061
Votes: 27
Reviews: 87
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.
by K Schlenger
on July 30, 2015
This plug-in doesn't appear to work correctly with firefox but it works fine in IE. Apex vers 4.2 on 11g. After generating the spreadsheet, it always appends .htm to the file being opened. After saving it off and opening it with excel, the spreadsheet is fine. My firefox works with other .xlsx files on different sites,etc, but not with this plug-in. Is the mime correct for firefox? Any ideas what I could be doing wrong?
by Anton Scheffer
on July 10, 2015
No, this plugin use the source query of the report region. It doesn't look at hidden or any other layout attributes.
by Pradyumna
on July 10, 2015
Hi Anton,

Thank you for the nice plugin.
Is there way to exclude the hidden column(s) in the export file.

ORA-06502: PL/SQL: numeric or value erro
by Siva Ram Nutulapati
on June 18, 2015
Hi After using this plugin , i gets below error

ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
@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.
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.