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, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Process Type Plugin (IR) Report to Excel (xlsx)

(IR) Report to Excel (xlsx)

10
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: 42786
Votes: 50
Reviews: 124
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 
@Diana
by Anton Scheffer
on August 12, 2016
Hi,

For the last parameter of plugin, “Append sysdate to filename?”, I mixed up help text and the default value. So you have to set this value to a correct value and don’t depend on the wrong default value. Hope this helps.

Anton
0 
bug
by Diana
on August 10, 2016
NL.AMIS.SCHEFFER.PROCESS.XLSX
ORA-01821: date format not recognized

This could be caused by
calling this plugin on a page without a Report Region
specifying a non-existing Report name
my (lack of) programming skills
try running this plugin in debug mode, and send the debug messages to me, scheffer@amis.nl


0.46075 0.00065
ORA-06512: at line 530
0 
bug
by Diana
on August 10, 2016
NL.AMIS.SCHEFFER.PROCESS.XLSX
ORA-01821: date format not recognized

This could be caused by
calling this plugin on a page without a Report Region
specifying a non-existing Report name
my (lack of) programming skills
try running this plugin in debug mode, and send the debug messages to me, scheffer@amis.nl

attribute_04: N
4
0%
0.24402 0.00003
attribute_05: test excell
4
0%
0.24404 0.00003
attribute_06: USER
4
0%
0.24407 0.00003
attribute_07: my_report
4
0%
0.24410 0.00003
attribute_08: The append sysdate to the filename of the generated Excel file. For example my_report_20101215.xlsx
4
0%
0.24412 0.00003
attribute_09:
4
0%
0.24415 0.00003
attribute_10:
4
0%
0.24417 0.00002
attribute_11:
4
0%
0.24420 0.00003
attribute_12:
4
0%
0.24422 0.00003
attribute_13:
4
0%
0.24425 0.00003
attribute_14:
4
0%
0.24427 0.15360
attribute_15:
4
100%
0.39788 0.06267
...Execute Statement: select c001,c002,c003,c004,c005,c006,c007,c008,c009,c010,c011
from apex_collections
where collection_name = 'EMPCOLLECTION'
4
40%
0.46055 0.00016
CGI: PATH_INFO = /f
9
0%
0.46071 0.00003
https://apex.oracle.com/pls/apex
QUERY_STRING=p=95155:22:111694050375988:EXCEL:YES
REQUEST_METHOD=GET
REMOTE_ADDR=109.67.174.149
REMOTE_USER=apex
APEX_LISTENER_VERSION=2.0.10.289.08.09
REFERER=
HTTP_IF_MODIFIED_SINCE=
9
0%
0.46073 0.00002
Cookies: ORA_WWV_RAC_INSTANCE=2; LOGIN_USERNAME_COOKIE=dgil60%40gmail.com; ORA_WWW_MRKT=v:1~g:0E8052BF54EA2148E050E60ACF7F638B~t:NOT_FOUND~c:LP05; ORA_WWW_PERSONALIZE=v:1~i:NOT_FOUND~r:NOT_FOUND~g:EMEA~l:en~cs:NOT_FOUND~cn:that's it; ORASSO_AUTH_HINT=v1.0~20160613211710; ORA_UCM_INFO=3~0E8052BF54EA2148E050E60ACF7F638B~Diana~Gilbert~dgil60@gmail.com; ELOQUA=GUID=2715838a6709414b936470584ae73523&FPCVISITED=1; s_nr=1469380682116; BIGipServer~Public~adc-apex_oracle_com_http=rd2o00000000000000000000ffff8d92722ao7801; __utma=7204706.823496241.1464105532.1470816770.1470829525.63; __utmb=7204706.1.10.1470829525; __utmc=7204706; __utmz=7204706.1464105532.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
9
0%
0.46075 0.00065
ORA-06512: at line 530
1
0%
0.46140 0.00057
...close http header
4
0%
0.46197 0.01327
Show page template header
4
8%
0.47524 0.00858
Rendering form open tag and internal values
0 
bug
by Diana
on August 10, 2016
NL.AMIS.SCHEFFER.PROCESS.XLSX
ORA-01821: date format not recognized

This could be caused by
calling this plugin on a page without a Report Region
specifying a non-existing Report name
my (lack of) programming skills
try running this plugin in debug mode, and send the debug messages to me, scheffer@amis.nl

attribute_04: N
4
0%
0.24402 0.00003
attribute_05: test excell
4
0%
0.24404 0.00003
attribute_06: USER
4
0%
0.24407 0.00003
attribute_07: my_report
4
0%
0.24410 0.00003
attribute_08: The append sysdate to the filename of the generated Excel file. For example my_report_20101215.xlsx
4
0%
0.24412 0.00003
attribute_09:
4
0%
0.24415 0.00003
attribute_10:
4
0%
0.24417 0.00002
attribute_11:
4
0%
0.24420 0.00003
attribute_12:
4
0%
0.24422 0.00003
attribute_13:
4
0%
0.24425 0.00003
attribute_14:
4
0%
0.24427 0.15360
attribute_15:
4
100%
0.39788 0.06267
...Execute Statement: select c001,c002,c003,c004,c005,c006,c007,c008,c009,c010,c011
from apex_collections
where collection_name = 'EMPCOLLECTION'
4
40%
0.46055 0.00016
CGI: PATH_INFO = /f
9
0%
0.46071 0.00003
https://apex.oracle.com/pls/apex
QUERY_STRING=p=95155:22:111694050375988:EXCEL:YES
REQUEST_METHOD=GET
REMOTE_ADDR=109.67.174.149
REMOTE_USER=apex
APEX_LISTENER_VERSION=2.0.10.289.08.09
REFERER=
HTTP_IF_MODIFIED_SINCE=
9
0%
0.46073 0.00002
Cookies: ORA_WWV_RAC_INSTANCE=2; LOGIN_USERNAME_COOKIE=dgil60%40gmail.com; ORA_WWW_MRKT=v:1~g:0E8052BF54EA2148E050E60ACF7F638B~t:NOT_FOUND~c:LP05; ORA_WWW_PERSONALIZE=v:1~i:NOT_FOUND~r:NOT_FOUND~g:EMEA~l:en~cs:NOT_FOUND~cn:that's it; ORASSO_AUTH_HINT=v1.0~20160613211710; ORA_UCM_INFO=3~0E8052BF54EA2148E050E60ACF7F638B~Diana~Gilbert~dgil60@gmail.com; ELOQUA=GUID=2715838a6709414b936470584ae73523&FPCVISITED=1; s_nr=1469380682116; BIGipServer~Public~adc-apex_oracle_com_http=rd2o00000000000000000000ffff8d92722ao7801; __utma=7204706.823496241.1464105532.1470816770.1470829525.63; __utmb=7204706.1.10.1470829525; __utmc=7204706; __utmz=7204706.1464105532.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
9
0%
0.46075 0.00065
ORA-06512: at line 530
1
0%
0.46140 0.00057
...close http header
4
0%
0.46197 0.01327
Show page template header
4
8%
0.47524 0.00858
Rendering form open tag and internal values
10 
Need help with Plugin configuration
by Moazzam
on July 20, 2016
Hi, I am new to APEX and using APEX 5.0. I have installed the plugin and tried to follow the readme. When I press the button it is not doing anything. Has anything changed in the way we create the processes in APEX 5.0. I really need to have this plugin working by Friday. Can you please help.

Thanks,
Moazzam
10 
Need help with Plugin configuration
by Moazzam
on July 20, 2016
Hi, I am new to APEX and using APEX 5.0. I have installed the plugin and tried to follow the readme. When I press the button it is not doing anything. Has anything changed in the way we create the processes in APEX 5.0. I really need to have this plugin working by Friday. Can you please help.

Thanks,
Moazzam
10 
Need help with Plugin configuration
by Moazzam
on July 20, 2016
Hi, I am new to APEX and using APEX 5.0. I have installed the plugin and tried to follow the readme. When I press the button it is not doing anything. Has anything changed in the way we create the processes in APEX 5.0. I really need to have this plugin working by Friday. Can you please help.

Thanks,
Moazzam
10 
Need help with Plugin configuration
by Moazzam
on July 20, 2016
Hi, I am new to APEX and using APEX 5.0. I have installed the plugin and tried to follow the readme. When I press the button it is not doing anything. Has anything changed in the way we create the processes in APEX 5.0. I really need to have this plugin working by Friday. Can you please help.

Thanks,
Moazzam
10 
Need help with Plugin configuration
by Moazzam
on July 20, 2016
Hi, I am new to APEX and using APEX 5.0. I have installed the plugin and tried to follow the readme. When I press the button it is not doing anything. Has anything changed in the way we create the processes in APEX 5.0. I really need to have this plugin working by Friday. Can you please help.

Thanks,
Moazzam
10 
Need help with Plugin configuration
by Moazzam
on July 20, 2016
Hi, I am new to APEX and using APEX 5.0. I have installed the plugin and tried to follow the readme. When I press the button it is not doing anything. Has anything changed in the way we create the processes in APEX 5.0. I really need to have this plugin working by Friday. Can you please help.

Thanks,
Moazzam
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.