APEX-PLUGIN.COM

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

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: 31228
Votes: 24
Reviews: 80
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 
@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
10 
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.

Thanks,
Tom
0 
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.
0 
@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
0 
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.
0 
@Anuradha
by Anton Scheffer
on July 9, 2014
I can do nothing about that. Try downloading it again
0 
downloaded zip file issue
by Anuradha
on July 9, 2014
Hi,

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.
10 
Enhancement: Export only vis. Columns
by Peter Ettinger
on July 2, 2014
Hi Anton,

i love this plugin. in the first use case, i export data of a very ease standard report. works like charm.
so i did a lttle enhancement in the column selection query. i added an aditional filter where the columns exported are retrieved from "apex_application_page_rpt_cols"
< and col.COLUMN_IS_HIDDEN <> 'Yes'>

Maybe You want to add this, or let the user choose by using an additional property.

If you provide your mail adress we can get in direct contact

Peter
0 
Excellent plugin
by Dejan Lekovic
on June 26, 2014
Thank you for this wonderful plugin, Mr Scheffer. One problem, though: when generated, excel table shows values from actual table and not values from report (LOVs and such). How to solve this little "conundrum"? Oh, and Use IR filters option is set to YES, so...
0 
No Of Rows
by Andrew
on May 20, 2014
Hi,

Is there a limit in the number of rows this plugin can deal with. I have a table that has 150,000 but the IR report is only returning 1 row but the excel plugin times out after a few minutes (500 - Internal Server Error), could this be down to the plugin or (more likely) have I set something up wrong.


Thanks in advance.
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.