(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 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 )
I have a report with more 44 columns, i changed this line t_val := apex_plugin_util.get_data2( r_apr.region_source, 1, 100, p_component_name => p_process.name );
but the Excel file still show 32 , what i'm doing wrong?
Tx in advance
apex_debug_message.log_message( 'adding ' || zip_files( i ) );
add1file( t_excel, zip_files( i ), get_file( t_template, zip_files( i ) ) );
The difference seems to be that in your template no reads the directories but in my template does. I have compressed the file as a standar zip. It needs any special encoding?? Your template mime-type is application/x-zip-compressed, but mine contains application/zip.
The thing that I'm trying to do is to change date format from dd/mmm/yy to dd/mm/yyyy. Is there any other way to do it?
Problem is as allways ... dates ... which are shown in all columns but one in readable format (not the same as on the page) but one cell has a number.
|Powered by Sigsiu.NET|