(IR) Report to Excel (xlsx) Tweet
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,
This plugin is limited to 26 columns!!
new 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
support for timestamp and clob
filename changed from anton.xlsx
fixed a bug on 11.2 databases
Excel, process type
Do you have a question about this Plugin? Want to write a Review or Comment?
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
But I get the following messages:
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...
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?
Im my implementation, I have made some minor changes to ensure the column name from A to ZZ, and limit the sheet name to 31 characters since it is hard-coded in Excel.
The changs are as follows:
1. change maximum columns from 50 to 702 (A-ZZ).
t_val := apex_plugin_util.get_data2( r_apr.region_source, 1, 702, p_component_name => p_process.name );'||chr(10)||
2. change chr(64 + c) function, which gives out column name, to: (in 8 places)
case trunc((c-1)/26) when 0 then NULL else chr(trunc((c-1)/26)+64) end||chr( 64 + c-trunc((c-1)/26)*26 )
3. if regin name is longed than 31 characters, cut the tail by SUBSTR function;
when p_sheetname then dbms_xmlgen.convert( substr( translate( r_apr.region_name, 'a/*:?', 'a' ), 1, 31) )
While exporting report to xslx in Firefox, it opens the file in my default browser and not in Excel. All other browsers work excelent. Do you maybe know what the problem is?
But in which part of the plugin i have to implement or change the second way to view more than 32 columns?
function alfan_col( p_col pls_integer )
when p_col > 702 then chr( 64 + trunc( ( p_col - 27 ) / 676 ) ) || chr( 65 + mod( trunc( ( p_col - 1 ) / 26 ) - 1, 26 ) ) || chr( 65 + mod( p_col - 1, 26 ) )
when p_col > 26 then chr( 64 + trunc( ( p_col - 1 ) / 26 ) ) || chr( 65 + mod( p_col - 1, 26 ) )
else chr( 64 + p_col )
|Powered by Sigsiu.NET|