Tx Anton

But in which part of the plugin i have to implement or change the second way to view more than 32 columns?

The plugin is limited in the number of columns in towi ways. You have changed one. The other is the way in which the column name for Excel ( A, B, C. D, etc ) is generated. In the current implemenation I used a very simple way, but that's limited to only 26 columns. On some other projects I use
function alfan_col( p_col pls_integer )
return varchar2
is
begin
return case
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 )
end;
end;

Hi folks
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

Yeah! In that way, change the template works.

I created that template by taking an Excel file with one empty sheet, renamed the xlsx to zip, took some files I didn't needed out of the zip. And believe that II looked for the index number of a "date" style inside the styles.xml and used that number as a hardcoded value inside the plugin.

Another problem I'm having is when I try to change the column ordering in the filter, the result is that Excel crashes.

Regards,

I'm trying to change the excel template but when I run the process it crashes when it try to add a directory at line:

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?

Regards,

-error058960_01.xml

Errors were detected in file 'G:DownloadsPage Details pg.xlsx'

-Repaired Records: Cell information from /xl/worksheets/sheet1.xml part

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.

This plugin has a max of 50 columns, which can be changed (see some previous reviews), but I don't think thats the problem/ An invalid Excel is generated for some unkown reason. Can you mail me that file. scheffer @ amis . nl